Tuesday, August 08, 2006
SSMA - What is SSMA?
I think it stands for Sql Server Migration Assistant since there are a few mentions of SSMA and Migration Assistant on Microsoft Downloads page. I saw this - http://www.microsoft.com/downloads/details.aspx?FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&DisplayLang=en and there are Migration Assistants for Oracle as well.
I haven't really played with it but I wonder how different/same it is from the Upsizing Wizard built into Access 97+? From the description, it handles the schema migration only (no forms/reports/etc a la the Upsizing Wizard).
From the description: "Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server.
SSMA for Access supports Access 97 - Access 2003 databases."
I haven't really played with it but I wonder how different/same it is from the Upsizing Wizard built into Access 97+? From the description, it handles the schema migration only (no forms/reports/etc a la the Upsizing Wizard).
From the description: "Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server.
SSMA for Access supports Access 97 - Access 2003 databases."
