Looking for good tool to convert Oracle - sql server

Question

Hi

I'am looking for good tool that can convert from Oracle to sql server and from sql server to oracle.

I found some, but there was many errors during the conversion

thank's in advance

Answer 1

Unfortunately there is no single silver bullet for this. Most of the tools out there do 80-95% of the job depending on your schema but there are still a few things which are so pl/sql centric that only way to convert them is hand writing the code.

However, if you post the actual errors encountered, this forum can certainly help you.

Answer 2

Microsoft have some very nifty tools in getting you to the darkside. Most notibily is the SQL Server Migration Assistant availaible in 2005 and 2008 flavours