Migrade Oracle data to SQL Server 2000

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 youserge 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
damorgan@.x.washington.edu
(replace x with u to respond)|||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 ***|||"serge" <sergea@.nospam.ehmail.com> wrote in message
news:dQeHe.8467$Dw5.273268@.weber.videotron.net...
>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|||> 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