Migration

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  February 10, 2010 at 2:40 am

  #141101

  Hi ,

  What is the best way to migrate a SQL Server 2005 database to Oracle 10G.

  I have migrated the whole database with Oracle Sql Developer but it throws errors when it encounters large data sets like image/text.

  I have tried using SSIS, which I loved it but the only problem is, migrating one table at a time.

  The database is totally of size 65 GB and around 185 tables. any guys out there had experience on the same?

  any better implementation in SSIS?

  Thanks all,

• ken-502058

  SSC Enthusiast

  Points: 108

  More actions

  February 18, 2011 at 8:41 am

  #1288887

  Use SSMA for Oracle, see Suresh Article[/url].