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
accordiaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

alpmoonCommented:
Sybase has a migration guide at this link:

http://www.sybase.com/detail?id=1047976
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joe WoodhousePrincipal ConsultantCommented:
Since I haven't seen any more comments on this, I'll answer OP's questions directly.

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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.