Migrating Sybase ASE to SQL

[Former Member]

Hi ASE Community,

I have a customer that is attempting to migrate ASE to SQL via the following method:

"To migrate Sybase Adaptive Server Enterprise (ASE) databases to SQL Server, we must connect to the Adaptive Server that contains the databases that we want to migrate. In our scenario, SSIS packages will create connections which point to Sybase database using Sybase ASE that is called Sybase ASE Data Provider in SQL Server."

What kinds of tools and requirements will this customer need?

Any guidance is greatly appreciated!

Thank you!

[former_member89972 · Accepted solution]

Good luck.

Most of the database vendors -- SAP/Sybase included --  give you tools to migrate from "other" competing database vendors. Similarly MS also provides you some migration tool.

The data migration -- most of the time - is easy. What is difficult typically is migrating the "logic" in form of stored procedures, triggers, defaults, jobs (being run via any number of schedulers ), applications connecting to ASE directly or otherwise (e.g. linkserver), replication to other ASE etc. etc.

If it is really a demanding application supported by ASE then do not underestimate the efforts. You will really need to throw a lot of resources and testing at it.

A couple of places I worked I have seen the migration project (ASE to MSSQL) hit wall and go up in flames due to demanding performance expected.

So good luck again.

Avinash

[Former Member · Accepted solution]

Thank you Avinash.  I do not deal with Sybase products terribly often, so I appreciate your insight very much.

[Former Member · Accepted solution]

Well said Avinash!

[Former Member · Accepted solution]

Good luck.