Question Re: Watcom Database in Technology Q&A

Watcom Database

Former Member — Tue, 23 Oct 2012 03:32:05 GMT

If I have an old Watcom database ...

How can I tell which version of Watcom it is?
How can I migrate this so I can use the data and upgrade to a newer database system?

Re: Watcom Database

Former Member — Tue, 23 Oct 2012 05:33:44 GMT

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.

Re: Watcom Database

VolkerBarth — Tue, 23 Oct 2012 06:50:41 GMT

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

Re: Watcom Database

Former Member — Tue, 23 Oct 2012 07:20:14 GMT

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.

Re: Watcom Database

reimer_pods — Tue, 23 Oct 2012 07:33:00 GMT

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.

Re: Watcom Database

Breck_Carter — Tue, 23 Oct 2012 08:19:25 GMT

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