Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migration Expand / Collapse
Author
Message
Posted Wednesday, February 10, 2010 2:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
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,
Post #863031
Posted Friday, February 18, 2011 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 17, 2011 6:21 PM
Points: 2, Visits: 16
Use SSMA for Oracle, see Suresh Article.
Post #1066439
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse