xpxj (11/29/2010)
167 pgs of instruction for . . ."The free Microsoft SQL Server Migration Assistant (SSMA) for Oracle speeds the migration process. SSMA for Oracle V4.0 converts Oracle database objects (including stored procedures) to SQL Server database objects, loads those objects into SQL Server, migrates data from Oracle to SQL Server, and then validates the migration of code and data."
I really wasn't planning on investing a lifetime.
Have you used SSMA ? Advice ? Pitfalls ?
Thx,
xpxj
Do you want to do it? or do it right?
167 pages for such a critical step seems downright small. You should be able to go through it in less than a day (and if you measure lifetimes in a day, well, that's a different issue). If it's important enough to take the database from Oracle to SQL Server, it's important enough to do it right - the first time. Otherwise, you'll end up with management questioning why did they move from Oracle to this sucky sql server product.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes