|
Hello. I was following this instruction. I've been stopped with error shown on this picture. Can you help me please? Thanx! |
|
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. 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? 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
|