Migrate an Oracle database to SQL2005

265 pts.
Tags:
Database
Database migration
Oracle
SQL Server
SQL Server 2005
I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

Answer Wiki

Thanks. We'll let you know when a new response is added.

The migration tool and white papers on Microsoft.com are a good place to start. After creating your new tables and moving your data, you’ll need to rewrite pretty much every stored procedure and function as Oracle and Microsoft SQL both use different languages.

After all this has been tested in Dev and QA you can deploy the tables and procedures to production and do the final data migration.

Testing will be the key to a successful migration.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following