SQL Anywhere to ASE migration related questions?

[Former Member]

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?

[Breck_Carter]

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 🙂

[VolkerBarth]

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.

[Breck_Carter]

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

[Breck_Carter]

This rant: Comparing SQL Anywhere With ASE

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

[Former Member]

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

[VolkerBarth]

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:)