SQL Anywhere 17 unload/reload script does not generate password values. Load breaks on error.

[former_member644256]

I am unloading SQLAny FIPS database version 16 with 1252LATIN1 collation and reloading it into the SQLAny FIPS database version 17 with UTF-8 collation. When the reload file is generated by the SQLAny17 dbunload.exe script there is an autogenerated header in the reload.sql file which looks like this:

--
-- This script file reloads a database that was unloaded using "dbunload".
--
-- (Version:  17.0.9.4857)
--
****************** WARNING *******************************
*                                                        *
* This file contains user definitions with removed       *
* password values.                                       *
* It should not be used to create a new database.        *
*                                                        *
****************** WARNING *******************************

...this was not an issue in the SQLAny version 16. But now (in version 17) it breaks the import.

1) because of the missing passwords

2) because the **** characters are not properly commented out.

How can I include the password definitions into the reload.sql file during the unload process?

[former_member194571 · Accepted solution]

http://dcx.sap.com/index.html#sqla170/en/html/090c5e30ef3a4d2fb016266e33f28a23.html

http://dcx.sap.com/index.html#sqla170/en/html/4844bd14a667468b96580dc996cfc2e0.html

Looks like a feature / behavior change, for dbunload in general and not specific for FIPS.

Specify -up for behavior like in previous versions.

HTH

Volker (DB-TecKnowledgy)