What should I review (stored proc, view, select, etc) before migrate an database (with about 66gb) from ASA 9.0.2 to SQLA 11?

asked 10 Nov '09, 02:45

Zote's gravatar image

Zote
1.7k364050
accept rate: 43%

edited 20 Sep '11, 17:33

Volker%20Barth's gravatar image

Volker Barth
30.0k294448654

2

good edit, on the sa-9... it's probably good to have both tags for versions [Voldemort], 7, 8 and 9. Version 5 should be just sa-5. Why Voldemort? The version number that must never be spoken aloud :)

(11 Nov '09, 21:14) Breck Carter
1

I begun with sa with Voldemort...

(11 Nov '09, 22:42) Zote

Your first step should be to read all the "Behavior Changes" portions of the 4 major "What's new" sections in the Help that apply to you, starting with SQL Anywhere 11 - Changes and Upgrading ยป What's new in version 10.0.0

In DCX (DocCommentXchange), the same material starts at http://dcx.sybase.com/1101en/sachanges_en11/newjasper.html

That will tell you what to look for. Your own knowledge of your application should tell you where to look. If you don't have a thorough understanding of ALL the code in your application (which is OK, especially if you didn't write all of it yourself) then reviewing ALL of the schema and ALL of the application code is probably required.

Don't forget the triggers... and events and web services (CREATE SERVICE)... if you use any of those... especially triggers, folks often forget they exist.

Breck

permanent link

answered 10 Nov '09, 07:26

Breck%20Carter's gravatar image

Breck Carter
27.4k424585837
accept rate: 21%

One disrupting change I stumbled across was the statistics estimation for varchar columns. In sybase 9.0.2 the first 254 chars have been taken into account, in Sybase 11.0.1 (probably already in 10.x) only the first 32 chars are used, this is bad, if your varchar data is only differering in the chars after position 32. This can lead to totally different query behavior when migrating to 11.

permanent link

answered 21 Jan '10, 15:17

Martin's gravatar image

Martin
8.6k115149237
accept rate: 14%

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:

×137
×97
×45

question asked: 10 Nov '09, 02:45

question was seen: 1,022 times

last updated: 20 Sep '11, 17:33