Hello. I was following this instruction. I've been stopped with error shown on this picture. Can you help me please? Thanx! asked 23 Sep '11, 05:32 enroberte |
I've encountered the same thing with some older databases. In previous SA versions you could use "%" as a comment delimiter. This has been changed, a line starting with a percent sign is no longer accepted as comment and so syntactically incorrect. The newly created database will contain all structures and data, but some or all triggers and/or procedures will be missing if the rebuild stopped at this point. SA should have generated a file name UNPROCESSED.SQL with the erroneous statements. Cf DBUnload. If you fix the statements and execute the SQL file on the new database the conversion should be complete. answered 23 Sep '11, 06:19 Reimer Pods 1
Just to add: Up to v10, you could still allow percent as comment marker with the help of the "percent_as_comment" option. It has been removed with v11 and above.
(23 Sep '11, 07:17)
Volker Barth
|
Thank you guys. I corrected unprocessed.sql and database is rebuilded. I have a problem with character set, which should be cp1250 instead of cp852. Where can I fix this. Is there a way to set correct connection character set? answered 23 Sep '11, 07:42 enroberte How are you doing the unload/reload? With Sybase Central or the DBUNLOAD tool etc.? See this other FAQ I'm quoting from:
So you migth use "DBINIT -z ..." or "CREATE DATABASE ... COLLATION ..." to create a new database with the desired collation. As a starting point, you may have a look at the auto-generated reload.sql from your previous steps: You should find an according (un-commented) CREATE DATABASE statement there, which you might just be able to adjust to you requirements.
(23 Sep '11, 08:45)
Volker Barth
|