Question Re: unload Version 4 database in Technology Q&A

unload Version 4 database

Former Member — Tue, 25 Sep 2012 16:46:38 GMT

I have a database that Looks like it was wrtten in version 4 (1994). Version 10 will not let me unload it because it is so old. How can I unload it? Is there a place to get version 4 or maybe I just need a driver.

Re: unload Version 4 database

regdomaratzki — Wed, 26 Sep 2012 09:31:09 GMT

SQL Anywhere v9 was the last version where we supported unloading a Watcom SQL v4 database.

Unfortunately, as v9 is no longer supported, there is no way to download or find an install image on the Sybase web site for this software.

Re: unload Version 4 database

Former Member — Wed, 26 Sep 2012 09:45:01 GMT

If you google for "SQL Anywhere 9.02" you'll get a few site from where you can download the developer version. C.Burns

Re: unload Version 4 database

reimer_pods — Wed, 26 Sep 2012 11:47:10 GMT

IMHO you should look for "SQL Anywhere 9.0.2 developer"

Re: unload Version 4 database

Former Member — Wed, 26 Sep 2012 14:45:53 GMT

I am having trouble running version 9. I am getting a java error

edit, XP works.

Re: unload Version 4 database

regdomaratzki — Wed, 26 Sep 2012 14:57:35 GMT

Don't worry about running Sybase Central or any of the Java tools. Once SA9 is installed, open a dos prompt and execute a command similar to :

%ASANY9%\\win32\\dbunload.exe -c "uid=dba;pwd=sql;dbf=v4.db" .

This should create a file called reload.sql and a series of .DAT files with all your data in them that can be reloaded into a new v10 database that you create.

Re: unload Version 4 database

Former Member — Wed, 26 Sep 2012 15:30:19 GMT

Thank you, it only works if i use the command line anyway

Re: unload Version 4 database

Former Member — Fri, 28 Sep 2012 12:52:07 GMT

I get most of the data i expect to be in there, but a lot of the dat files are blank. There is one in particular that I want. In the .sql file it shows the table name and columns.

Re: unload Version 4 database

VolkerBarth — Fri, 28 Sep 2012 13:20:11 GMT

Blank data files usually just mean that the according tables are empty. Or has the v9 unload given any errors?

If not, as you obviously can use v9 to unload the database, I would suggest that you use v9 simply to start the database and to connect to it and to have a look whether the according tables are empty or not, something like

%ASANY9%win32dbisqlc -c "uid=dba;pwd=sql;dbf=v4.db"

Re: unload Version 4 database

Former Member — Fri, 28 Sep 2012 14:23:29 GMT

It looks like that column is empty using the interactive SQL. Is it possible that this has to do with the version? It doesnt make sence that half of the tables in the database were created empty. I know specifically that data in this table is used in the calculations I do in the program.

Re: unload Version 4 database

Former Member — Fri, 28 Sep 2012 16:11:06 GMT

there is an EXE that comes with the program that starts the database. trdsk50w. If i run it seperately it launches a little window "Sybase SQL Anywhere Database Engine Version 5.0.01 Build #451"

This launches before the program use the data. I am hoping that maybe i can talk to it also. Any suggestions?