[dba-SQLServer] Data Transformation Packages from SQL Server 2K to Oracle 9

Jim Lawrence (AccessD) accessd at shaw.ca
Mon Dec 15 21:40:33 CST 2003

Hi Ken:

I have used TOAD, a graphic SQL script editor for building Oracle and MSSQL
scripts and testing them. I do not imagine it would be a big stretch to
migrate between the two as multiple connections can be established. Mine
you, I have not been in an environment where both Oracle and MSSQL were


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Stoker,
Kenneth E
Sent: Monday, December 15, 2003 3:18 PM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer] Data Transformation Packages from SQL Server 2K
to Oracle 9


Has anyone had any experience with this?  I have a coworker who came to
me asking if I could help him.  I don't have any experience working with
Oracle within DTS.

We are trying to first validate what data is in the Oracle 9 database
and make inserts from the SQL Server database of what is missing.

Does anyone also have any good book recommendations for programming DTS

Thanks everyone.  Always a help.

Ken Stoker
Technology Commercialization
Information Systems Administrator
PH: (509) 375-3758
FAX: (509) 375-6731
E-mail:  Kenneth.Stoker at pnl.gov

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list