hi all, i am trying to migrate a db(created using sqlanywhere 5.0 or lesser). when i execute below from sybase central 12. i get below error. dbunload -c "dbn=D:\Quartz32_Iteration3.0_old\DB\qz98;uid=DBA;pwd=SQL" -n c:\temp sqlcode=-131,odbc3 state ="42000" |
The error is a generic "Syntax Error" so does not provide enough information to determine the cause of the problem.
Are you trying to execute the "dbunload" command in the Sybase Central (SC) window? If so then you need to realize that dbunload is not a SC command but is a program that needs to be run from a shell/command prompt.
FWIW, moving from v5 (or even older) to v12 is a huge step - cf. that doc page with some hints to possible problems.
The error should also contain a description, such as "Syntax error near ..." that might give a further clue - it might be that your old database is using a word as identifier which is nowadays a reserved word and treated differently when parsing SQL statements...