Sunday, March 11, 2012

Copying database objects and data from Oracle 8 to SQL 2005

Does anyone know how to copying database objects and data from Oracle 8 to SQL 2005 ?You cannot use SSIS to copy "objects" from Oracle to SQL Server. I believe that there is no such tool available for this. However, you can use SSIS to transfer data from tables in Oracle db to SQL Server db. Please refer to SSIS documentation for more info.

No comments:

Post a Comment