I am sending this on behalf of an ISUG member in Mexico. He is considering upgrading from SQL Anywhere to ASE and is looking for some guidelines for the process.

He is concerned about the usual migration issues: creating the database objects (DDL) and loading the data. I have worked with SQL Anywhere but do not remember if it has a tool to extract the data to flat files and then use BCP to load it into ASE.

Also, I don't believe that SQL Anywhere uses T-SQL. It must use ANSI SQL, so that means that many of his queries should probably be rewritten.

Any hints and tips will be greatly appreciated. Migration guide?

asked 16 Jul '12, 14:14

dareys's gravatar image

dareys
16113
accept rate: 0%

edited 16 Jul '12, 15:36

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k379124

Tip: Don't mark anything "community wiki"... it has no purpose, EXCEPT to prevent you from gaining any reputation points... and you need points to do simple things like upload files... gotta love those unintended consequences :)

(16 Jul '12, 15:24) Breck Carter
Replies hidden

Just to correct: SQL Anywhere does support two SQL dialects:

  • Watcom SQL (close to ANSI SQL) and
  • T-SQL (close to ASE and MS SQL).

So in case one uses the T-SQL dialect, there is a chance that procedures and triggers (and application code) might be fitting for ASE to a certain degree, too.

(17 Jul '12, 03:21) Volker Barth
2

@Graeme: If you were to disable the community wiki feature altogether, you wouldn't get any objection from me :)

(17 Jul '12, 08:07) Breck Carter

This rant: Comparing SQL Anywhere With ASE

...leads to this 71-page migration guide: Migrating SQL Anywhere database applications to ASE

permanent link

answered 16 Jul '12, 15:21

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

2

Wow! 71 pages! How about Migrating ASE to SQL Anywhere? I bet that it would only have 5 pages.

(17 Jul '12, 00:13) cirxesoul
Replies hidden
1

Well, although Breck's great "Technical Document list" shows several "Migrating DBMS X to SQL Anywhere" articles, ASE is not among X - for whatever obvious reason:)

(17 Jul '12, 03:33) Volker Barth
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:

×53
×53

question asked: 16 Jul '12, 14:14

question was seen: 2,477 times

last updated: 17 Jul '12, 08:07