Posted by: kurtsh | August 26, 2010

RELEASE: Microsoft SQL Server Migration Assistant for Access v4.2

image Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. SSMA 2008 for Access also supports migrating to SQL Azure.

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. You can also link Access tables to SQL Server tables so that you can continue to use your existing Access front-end applications with SQL Server or SQL Azure.

SSMA for Access supports migration from Access 97 and higher to any edition of SQL Server.

Requirements for the SSMA for Access:

  • Microsoft Windows Installer 3.1 or a later version.
  • The Microsoft .NET Framework version 2.0 or a later version. The .NET Framework version 2.0 is available on the SQL Server product media. You can also obtain it from the .NET Framework Developer Center Web site.
  • The ability to access the computer that hosts the target instance of SQL Server.
  • DAO provider version 12.0 or 14.0. You can install DAO provider from Microsoft Office 2010/2007 product or download it from Microsoft web site.
  • Microsoft SQL Server Native Client (SNAC) version 10.5 and above for migrating to SQL Azure. You can install SNAC from Microsoft SQL Server 2008 R2 product or download it from Microsoft web site (SQL Server 2008 R2 Feature Pack).
  • At least 1 GB RAM.

DOWNLOAD: Microsoft SQL Server Migration Assistant for Access v4.2
http://www.microsoft.com/downloads/details.aspx?FamilyID=5abe098d-c7e1-46c6-994a-09a2856eef0b&displaylang=en


Categories

%d bloggers like this: