Monday, March 19, 2012

Oracle to Sybase - Data Migration

Hi All,

I need to move data from some tables in oracle to sybase. Its jus kind of ad-hoc process - need to do it manually. I thought of doing it using DTS tool.

In sql server 2005 - using Integration Services - how to achieve this ? any help is greatly appreciated.

thanks.
Mani

It rather depends on the Sybase and Oracle connectivity that you have available. If you have the OLEDB drivers, then the import export wizard in SSIS should work for you. Right click on the SSIS packages node in an SSIS project in BI Dev Studio and select "SSIS Import and Export Wizard"

Donald

No comments:

Post a Comment