accordia
asked on
How to migrate MSSQL2008 database to ASE 15 database server
We have a task to migrate already existing test database "AdventureWorks2008" on MSSQL2008 server to Sybase ASE 15.
1. Is there an existing migration tool for this task?
2. Or is there a dump for this test database from Microsoft for Sybase ASE 15 DB server?
3. Or can you suggest a procedure to do this task?
Also we will need to migrate this test database to mysql, oracle, derby, postgre, but first will try to use this on sybase ASE.
link to test database: http://msftdbprodsamples.codeplex.com/releases/view/37109
1. Is there an existing migration tool for this task?
2. Or is there a dump for this test database from Microsoft for Sybase ASE 15 DB server?
3. Or can you suggest a procedure to do this task?
Also we will need to migrate this test database to mysql, oracle, derby, postgre, but first will try to use this on sybase ASE.
link to test database: http://msftdbprodsamples.codeplex.com/releases/view/37109
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. There are no tool to automate the code conversion for your stored procedures, views, triggers, rules & constraints. There are tools to convert the tables and columns, but that's the easy bit.
2. There is no dump & load between Sybase and MS or vice versa, except way back in the days of 4.2 when they were the same product.
3. There are no simple or easy ways. You need to migrate the tables & columns (easy), and then go through every piece of SQL ever run in your MS server and rewrite as required to make it work in Sybase (not difficult but time-consuming).
Sorry. Cross-platform migration is incredibly painful and very difficult to do well. Treat is as writing an entire new application.