Question Re: SQL Anywhere to ASE Migration in Technology Q&A

SQL Anywhere to ASE Migration

former_member647073 — Tue, 04 Sep 2018 12:00:09 GMT

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

Narayana

Re: SQL Anywhere to ASE Migration

former_member89972 — Mon, 10 Sep 2018 14:37:11 GMT

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

Re: SQL Anywhere to ASE Migration

former_member647073 — Tue, 23 Oct 2018 10:47:00 GMT

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

Re: SQL Anywhere to ASE Migration

Former Member — Mon, 29 Oct 2018 05:39:02 GMT

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

Re: SQL Anywhere to ASE Migration

former_member945921 — Fri, 28 Jul 2023 19:52:03 GMT

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