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

MartyConnelly martyconnelly at shaw.ca
Tue Dec 16 01:18:38 CST 2003


I don't know if this would be any help but the VB source code for a 
large DMO-SQL program
equivalent to Enterprise Manger is available here.
http://www.asql.biz/DbaMgr.shtm
http://www.asql.biz/DbaMgr/DownLoad.shtm
If not you could e-mail Andrea Montanari at
andrea.sql at virgilio.it
and he might be able to point you in the right direction
Microsoft finally made him an MVP last month.



Stoker, Kenneth E wrote:

>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 
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada





More information about the dba-SQLServer mailing list