SQL Server Migration Assistance

  • I am looking for an easy to follow instructions on how to use the SQL Server Migration Assistant to migrate a set of tables and stored procedures from Oracle to SQL 2005. I've read many articles on what it can do but no instructions on how to migrate stored procedures and tables. Does anyone have a simple "Migrate Oracle Stored procedures and Tables" using SSMA?

    Thanks

  • MS has a whitepaper that goes into great detail - good luck 🙂

    http://www.microsoft.com/downloads/details.aspx?familyid=3F0F2A3F-DFF9-49CD-8EA7-581AA7A303A4&displaylang=en

  • 1. Open the project file with extension .o2ssproj in the folder on the server

    2. Select Reconnect to oracle

    3. Select Reconnect to SQL SERVER

    4. Select the Schema node on Oracle metadata explorer

    5. Right Click and select "Refresh from Database", Once done

    6. Right Click and select "Convert Schema" , Once done

    7. Right-click Schemas in Oracle Metadata Explorer, and then click Migrate Data.

    7. A popup window appears with a message "Operation Prerequisites Not Met"

    8. Select Continue in the Popup window

    9. Right-click on database node in SQL SERVER metadata explorer

    10. Right click and Select "Synchronize with database"

    If you need any other help let me know.

    Thanks

    Murali

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

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