December 10, 2007 at 7:32 pm
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
December 11, 2007 at 8:55 am
MS has a whitepaper that goes into great detail - good luck 🙂
Tommy
Follow @sqlscribeDecember 14, 2007 at 5:15 am
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