SQL Anywhere to ASE Migration

[former_member647073]

Hi

What is the tool can be used for Migrating Sql Anywhere 16 database to ASE 15?

Narayana

[former_member945921]

Hello Subramanyam,

We are eager to hear about your experience and success stories in migrating from Sybase ASA to ASE in 2018. We also understand that it has been quite some time since this exercise was completed. It would be great help if you could recall your experience and share your insights. Our main goal is to migrate from Sybase ASA to SQL Server 2019/2022. Please share your thoughts and insights based on your First-hand experience.

We also understand that it has been quite some time back this exercise was

Regards

Arun Siripuram

[Former Member]

Hello Subramanyam,

I have done a similar migration. We have relied on Power Designer to reverse engineer the database from ASA to ASE.

Then we used a combination between BCP and powerbuilder pipeline to move the data.

You have to watch out for reserved keywords between ASE and ASE.

Regards,

Marc

[former_member647073]

Thanks, I will try and update you back the status. Currently i am using powerbuilder pipeline logic for table and data copy.

[former_member89972]

There is no single tool.

You migrate data using bullk load copy out from SQLANywhere and copy into ASE.

For logic you can use tools like Sybase Central, DBArtisan, AQUA studio, etc. (google search for more) and convert Anywhere SQL to T-SQL.

(i.e. reverse engineer from SQLAnywhere and try on ASE)

SQL between the two is 85 to 90% compatible. But you have to test each proc/trigger etc by compiling it on ASE.

You can also use SAP/Sybase's PowerDesigner for reverse/forward code generation.

HTH

Avinash