I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?
Software/Hardware used:
ASKED:
July 1, 2008 3:29 PM
UPDATED:
July 30, 2008 6:11 PM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.