18 March 2007

Migrating To SQL Server From Oracle, Part 3

If you're migrating data from an Oracle database to SQL Server 2005, use Microsoft's new tool, the SQL Server Migration Assistant for Oracle (SSMA Oracle). As I mentioned in my previous post for the SSMA for Access tool for migrating data from Access to SQL Server 2005, SSMA for Oracle is very similar in that it converts Oracle's database objects to SQL Server database objects, loads those objects into a SQL Server database, and then migrates the data from the Oracle database to the SQL Server database. If you've ever migrated from one database engine to another, you know that converting data types is difficult enough, but converting database objects can be that much more frustrating. Microsoft has helped ease the pain a little by developing this tool to automate as much as possible.

No comments: