Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

accept rate: 0%

edited 15 Mar '13, 18:22

Mark%20Culp's gravatar image

Mark Culp

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

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 23 Oct '12, 03:32

question was seen: 4,544 times

last updated: 15 Mar '13, 18:22