migrate DATA ONLY from Oracle 10g to Sql Server 2008 and then automate for 200+ db's?

• joe-1140674

  Newbie

  Points: 9

  More actions

  August 19, 2009 at 7:23 am

  #203976

  Hi everyone i wonder if you could help,

  We have 200+ Oracle 10 g databases that we are considering migrating to Sql server 2008.

  We already have a blank Sql db with all keys, stored procs, triggers etc in place.

  Therefore we are looking for a reusable solution that we could use to migrate the data (and ONLY the data) in an automated way with minimal hassle.

  Ideally we would generate a csv/xml/sql table with source and target datasources and then press a button. 🙂

  SSIS and SSMA have been mentioned to me. which one would be suitable?

  if SSIS, Our dba has already created a package in SSIS that migrates the data for one db, how would be expand this for 200 dbs? (the db's have identical objects apart from the data)

  If SSMA, how would we go about setting this up for 200+db's?

  Is their another better tool out there? SwisSQL etc?

  Thanks so much for your help in advance

• September 11, 2009 at 12:01 am

  This was removed by the editor as SPAM

• September 11, 2009 at 12:15 am

  This was removed by the editor as SPAM

• September 11, 2009 at 12:23 am

  This was removed by the editor as SPAM

• September 11, 2009 at 1:23 am

  This was removed by the editor as SPAM

• September 11, 2009 at 1:27 am

  This was removed by the editor as SPAM