cancel
Showing results for 
Search instead for 
Did you mean: 

Watcom Database

Former Member
4,969

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?

reimer_pods
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member

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.

VolkerBarth
Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Breck_Carter
Participant

@@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 🙂