We are upgrading our Software SQL Anywhere Database from version 5 to 11. I found an answer on "How do I upgrade a version 5.5 database to version 11?" which copied the Tables from version 5.5 to 11.

Now... How can I copy 'Procedure & Functions' version 5.5 to 'Procedure & Functions' version 11?

Thank you in advanced.

asked 01 Apr '10, 22:07

Andrew's gravatar image

Andrew
33225
accept rate: 0%

edited 02 Apr '10, 10:30

Breck%20Carter's gravatar image

Breck Carter
27.3k424585836

Comment Text Removed

The dbunload utility copies everything... tables, views, procedures, functions, triggers, user ids, passwords, database options, everything. The technique shown here results in a Version 11 database with all of the functionality of the original version 5.5 database: http://sqlanywhere-forum.sap.com/questions/574/how-do-i-upgrade-a-version-5-5-database-to-version-11

Now, the technique may fail in certain rare cases, especially when dealing with such a large leap and so many behavior changes. My "favorites" are undiagnosed validity errors in the source database. Exceptions thrown by dbunload need to be dealt with on a case by case basis.

Also, applications may no longer work properly because of behavior changes... that's why every single bit of the "Behavior Changes" documentation in the Help, from Version 6.0.0 to 11.0.1, must be studied carefully to see what action must be taken. It's a boring task, especially when it blathers on about later changes to features that didn't exist in 5.5, but ya gotta do it.

permanent link

answered 02 Apr '10, 10:30

Breck%20Carter's gravatar image

Breck Carter
27.3k424585836
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×45

question asked: 01 Apr '10, 22:07

question was seen: 527 times

last updated: 02 Apr '10, 10:30