|
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" |
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.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 01 Jul '15, 09:35
question was seen: 2,543 times
last updated: 01 Jul '15, 10:07
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...