Post reply

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

  • August 18, 2009 at 6:22 am

    #135578

    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

  • August 18, 2009 at 6:33 am

    #1040782

    I'd say SSIS would work, but I'm not sure what SSMA is.

    If you have a package, then one way to do this is pass in the name of the db to the package and set your connection from that. Then build another package that loops through your DBs and passes the name of each to the first package. There is a task to execute another package.

  • August 18, 2009 at 6:43 am

    #1040789

    thanks steve SSMA = Sql server migration assistant.

    Do you have any more info on how i would go about what you suggest?

    And any idea how / what tools i might use to validate that the data migration has been successful?

    thanks for your help!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply