Has anyone migrated from Oracle to MSSQL database?

[Former Member]

Hello all,

I am in the process of evaluating the costs between the Oracle licensing and the MSSQL licensing and was wondering if anyone has migrated from Oracle to MSSQL?

If so, how involved was the transition?

Were there any scripts used to migrate data?

Any help on this would be greatly appreciated.

Thanks,

Mike Jewson

[Former Member · Accepted solution]

Hi Mike,

I don't think that this has been done before and scripts aren't available for this purpose.(Colleagues,correct me if wrong please)

There's a migration tool from MS for that purpose but it is not supported for ME as it hasn't been tested.

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

A safe alternative if only objects are required could be to use data Xchange but this won't include reporting data.

Regards,

German

[Former Member · Accepted solution]

HI German,

Thanks for the reply.

I will look into the link that you provided and see where it takes us.

Thank you,

Mike