Migrade Oracle data to SQL Server 2000

[serge]

I am doing a test on migrating an Oracle 8i database to
SQL 2000. I've never done this before and I would like
to find out if there are any complications or side effects
if I try doing the transfer of data using DTS?

If not DTS then what would you suggest I transfer data
with?

Thank you

[DA Morgan]

serge wrote:

I am doing a test on migrating an Oracle 8i database to
SQL 2000. I've never done this before and I would like
to find out if there are any complications or side effects
if I try doing the transfer of data using DTS?

If not DTS then what would you suggest I transfer data
with?

Thank you

If just data ... any solution will suffice. If any PL/SQL you
will need to rearchitect it.
--
Daniel A. Morgan
http://www.psoug.org
da******@x.wash ington.edu
(replace x with u to respond)

[Chandra]

Hi

DTS will just creat Tables and migrate data from Source to Destination.
This will not take care of the references and constraints on the table.

Also you will not be able to migrate ur Objects like Views, Stored
Procedures and Packages.

U need to generate the scirpt in Oracle and execute the same in SQL
Server. Main thing u need to consider is, the syntax and system
functions avaiable.

Ceratin things that are in Oracle might not be available in SQL Server.

eg NVL(field,'') in Oracle is ISNULL(field,'' ) on SQL Server.

please let me know if you would like to know anything else

best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

[Simon Hayes]

"serge" <se****@nospam. ehmail.com> wrote in message
news:dQ******** ***********@web er.videotron.ne t...

I am doing a test on migrating an Oracle 8i database to
SQL 2000. I've never done this before and I would like
to find out if there are any complications or side effects
if I try doing the transfer of data using DTS?

If not DTS then what would you suggest I transfer data
with?

Thank you

If you're moving only data, then DTS is probably a reasonable solution. You
might also want to check out the Oracle to MSSQL migration resources, which
include a Migration Assistant:

http://www.microsoft.com/sql/migration/default.mspx

Simon

[Martijn Tonies]

> I am doing a test on migrating an Oracle 8i database to

SQL 2000. I've never done this before and I would like
to find out if there are any complications or side effects
if I try doing the transfer of data using DTS?

If not DTS then what would you suggest I transfer data
with?

I'll have to plug our database tool here ... it can transfer/migrate
tables, indices and constraints without having to resort to script
and syntax differences.

Check out the Schema Migrator tool in Database Workbench
www.upscene.com
--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com