Used to migrate from non SQL Server environments to SQL Server.
Can migrate Access mdb's
Oracle and others
Process:
DB discovery
Schema discovery
Data migration
Embedded SQL Statement
DB connectivity
User login and permissions
Has a testing module to test the objects in the DB after conversion.
This is a tool we have in house that would mainly be used to convert Access DB. For the record, Microsoft is now saying that Customers are saying SQL Server 2008 R2 is now out performing Oracle when it comes to data retrieval. Joe, I don't want to debate it. :)
SSMA 5.0 was just released and is much faster than the previous version. Supports SQL Server 2008, R2,"Denali" and SQL Azure.
Location:TechEd 2011
No comments:
Post a Comment