cancel
Showing results for 
Search instead for 
Did you mean: 

Convert base from SA 12.0.1.4134 to SA 17.0.9.4913

0 Kudos
1,691

Hi All,

There is a database created under server SA 12.0.1.4134, you need to convert it for server SA 17.0.9.4913.

When trying to unload it into a file (reload.sql + *.dat) using the utility

C:\\SQLANY17\\Bin64\\dbunload -up -c "uid=dba;pwd=sql;dbf=d:\\test" unload

I get an error message

SQL Anywhere Unload Utility Version 17.0.9.4913
Connecting and initializing
***** SQL error: Procedure 'sa_exec_script' not found

Question: How to fix it so that I could convert the base for the new version of the server ?

Accepted Solutions (1)

Accepted Solutions (1)

Found the reason for this error. In my database, the user "dba" for some reason was not included in the group "PUBLIC". As soon as I added it to this group, dbunload immediately began to work without this error.

VolkerBarth
Contributor
0 Kudos

@Stalker: Glad you found the issue. I marked your answer as accepted, alright?

0 Kudos

I agree with your decision

Answers (1)

Answers (1)

0 Kudos

I used the rebuild method "2217114 - How to upgrade to SQL Anywhere 17" and it worked for me:

call "%SQLANY17%\\bin64\\dbunload" -c "UID=DBA;PWD=sql;dbf=D:\\test\\dbname.db" -an "D:\\test\\Rebuild\\dbname.db"

Connect to the new DB "D:\\test\\Rebuild\\dbname.db" and execute:

select @@version and sp_disk_info (for example, this is a new sp in V17) to be sure you are in 17 version.

0 Kudos

Does not work. I get the same error about "sa_exec_script"