Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating from SQL SERVER to Oracle
> Hi
>
> Is there any tool for migrating from sql server to oracle.
Kind of depends what you want to migrate.
If your code uses a portable interface library (for instance
ODBC, DBI/DBD or JDBC) then you should only have to migrate the
data.
A tool I have used in the past with great success for this kind
of thing is PowerDesigner Data Architect (
http://www.sybase.com/products/powerdesigner/ ).
Strictly speaking this isn't a migration tool - it's a database
analysis & design package. But it will reverse engineer
database schemas via ODBC, and rewrite then in the target SQL
of a different database. It supports dozens of databases, and
is reliably accurate. It's not cheap though. If you do a lot
of data modelling, then it makes your life a load easier.
You still have to export and import your data though, but this
is rarely difficult - exporting/importing as CSV is often very
simple.
Hope that helps.
Cheers,
Doug.
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6763&cus_id=USENET&qtn_id=6919
Received on Tue Nov 02 1999 - 13:42:37 CST