Microsoft released a new suite of tools that can help you during migration from a third party database to Microsoft SQL.
This tools can be downloaded from the following links:
Microsoft SQL Server Migration Assistant for MySQL v5.1
Microsoft SQL Server Migration Assistant for Oracle v5.1
Microsoft SQL Server Migration Assistant for Sybase v5.1