Migration from Oracle 11g to SQL Server 2008

  • Hi,

    We are planning to Migrate Oracle 11g databases to SQL Server 2008 R2. Please advice me the available methods to achieve this.

    Thanks

  • Could you plz advice me. Thanks

  • Well, there is a lot to this.

    The first thing I would recommend is try running the db migration wizard from Microsoft

    http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

    And take a look at what it scripts out.

    How many stored procedures do you have in Oracle, triggers, sequences? these are all going to come into play in terms of how complex the migration is.

    Do you need to migrate data, if so how much?

    That's just for starters, if you are looking for a forum post that tells you step A, B and C you are out of luck.

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

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