If I have an old Watcom database ...

  1. How can I tell which version of Watcom it is?

  2. How can I migrate this so I can use the data and upgrade to a newer database system?

asked 23 Oct '12, 03:32

Confused's gravatar image

Confused
31113
accept rate: 0%

edited 15 Mar '13, 18:22

Mark%20Culp's gravatar image

Mark Culp
24.9k10139297

Do you have only the database without the associated software? In that case it could be helpfull to dump the first block of the database file (.db). It might contain something like
"WATCOM International Corp., Copyright (c) 1987, 1994"
to indicate the version it was created with.

(23 Oct '12, 07:33) Reimer Pods

1) Look at "Properies" -> "Details" -> "File version" in explorer for dbeng*.exe or run a "select @@version" SQL statement. 2) The dbunload tool of newer versions can be used to unload or upgrade the databases.

permanent link

answered 23 Oct '12, 05:33

Hartmut%20Branz's gravatar image

Hartmut Branz
40629
accept rate: 0%

This will tell the version of the database engine, which is not necessarily the same as the version of the database file itself.

(23 Oct '12, 06:50) Volker Barth

There is no way to find out the exact version with that a Watcom SQL database has been created. But anyway, its enough to know which version of Watcom SQL software can start and use the database file.

(23 Oct '12, 07:20) Hartmut Branz
Replies hidden
1

@@version does not tell you what version CAN start and use the database file, since you must HAVE started the database before you can use @@version... and at that point, you no longer need to run @@version :)

(23 Oct '12, 08:19) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×20

question asked: 23 Oct '12, 03:32

question was seen: 4,369 times

last updated: 15 Mar '13, 18:22