Issues with using dbunload (ASA 11) with ASA 9 DB file
DJS
Okay, I am trying to GET data out of a Sybase ASA 9.0.2 (EBF 3219)
file. It does not matter that the one I am trying AT THIS MOMENT has
some corrupted tables in it, since I am specifying ONLY tables that
are NOT at issue. The SAME problem occurs on a TINY db with only 1
TABLE, that is brand new, and that has nothing corrupted in it.
I am trying to get ASA 11 dbunload to connect to it and get data out
of it, to make a new ASA 11 DB I can use with it. According to the
docs I have been reading (in front of me) I am supposed to be able to
do this.
To verify that the DB at least IS OK, and that dbunload (ASA 9
version) IS working as I expected, I used it first to make sure it
does what I expected. IT DOES.
Now I am trying to connect to it and do the same thing with ASA 11
(the downloaded developers copy) whcih does NOT appear to let me. The
exact version I am trying this with is 11.0.0.1490.
Below is the start line for dbunload (ASA 11):
dbunload @dbunload.copyxxx
The file dbunload.copyxxx contains:
-an /xxx/new_db_dir/new_db_base.db
-c "uid=dba;pwd=sql;DBF=old_db_base.db"
-v
-t 'dummy,table1,table2,...dummy'
The actual filenames and directories above are not that important
(they seem to be working fine).
After I execute the command above and check, then the following IS
running...
/opt/sqlanywhere11/bin32/dbunlspt -qi -qs -hi -hV -ch 40p -ga -n
dbunload_support_engine old_db_base.db -hn 8
I do NOT seem to be able to connect up to it using dbisql at all, but
that may not be any issue.
However, the problem is that after i give it the Y when starting for
the License agreement using the Developer edition) I get the error:
"***** SQL error: Database server not found" and dbunload stops,
leaving the other process (dbunlspt) still running...
ANy other ideas what to try. I have tried many combinations and
cannot seem to make anything work when trying to use the ASA9 DB and
using the ASA11 dbunload utility...
Thanks in advance...