Ask the Expert

Tool to transfer DB objects from Oracle 8i to SQL Server

I have an Oracle 8i database that I wish to convert to a SQL Server 2000 database. I have used the import tool that comes with SQL Server but find that it does not transfer foreign key, check constraints, indexes, primary keys, etc. Are there any tools available that will provide a better transfer, i.e. transfer more of the database objects?

    Requires Free Membership to View

The problem with doing a simple transfer is that very few of the transfer tools are good at divining Oracle's constraints, etc. You really need a tool that can do forward and reverse database engineering to do a good job.

ERWin (from Computer Associates) is the grand-daddy of these tools. Visio Architect (Microsoft) is also very good and much less expensive. PowerDesigner from Sybase is also a good tool, and there are many other tools from other third parties, and many freeware packages that will help with these transfers.

Another option would be to script out the Oracle PL/SQL script to rebuild the database (using Oracle's TOAD), then manually editing that script so it will run in the SQL-2000 environment. This is a bit more work than the tools that will do the conversion "automagically" for you, but it will also produce much better results since you'll understand exactly what was changed, how, and why.

For More Information

This was first published in November 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

Forgot Password?

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

Your password has been sent to: