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 available. HTH Jim -----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 Everyone, 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 Packages? 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 http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com