Microsoft SQL Server Migration Assistant for Access (SSMA)

SQL Server Migration Assistant for Microsoft Access (SSMA)

Download Contact Management Software     Reached the Final for a CRM Award in the Software Satisfaction Awards 2011 Reached the Final for a CRM Award in the Software Satisfaction Awards 2012

Microsoft SQL Server Migration Assistant for Access (SSMA)

The Microsoft SQL Server Migration Assistant for Access (SSMA) can be used to easily upgrade a Microsoft Access database file to SQL Server 2012. It is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure.

Download Microsoft SQL Server Migration Assistant for Access (SSMA)

The Microsoft SQL Server Migration Assistant for Access (SSMA) can be downloaded from here

Download Microsoft SQL Server Migration Assistant for Access

Microsoft SQL Server Migration Assistant for Access Licensing

Microsoft SQL Server Migration Assistant for Access is Free but requires a license key for activation from Microsoft after a simple registration process.

Running Microsoft SQL Server Migration Assistant for Access

We run the Microsoft SQL Server Migration Assistant for Access (32-bit) program.

Microsoft SQL Server Migration Assistant for Access

There are 2 menu options, one ends with (32-bit) and one doesn't. If you see the error below you have probably selected the wrong menu option.

Error message if you select the wrong menu option

Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154. This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. You can run 32-bit SSMA application if you have 32-bit connectivity components or 64-bit SSMA application if you have 64-bit connectivity components, shortcut to both 32-bit and 64-bit SSMA can be found under the Programs menu.

SQL Server Migration Assistant Wizard

By default, the SQL Server Migration Assistant Wizard will start and guide you through the migration.

Upgrade Amphis Customer Access Database to SQL Server 2012 Express

Here's how to upgrade the Amphis Customer database file customer.mdb to a SQL Server 2012 database. First, check that all instances of Amphis Customer are shut down. You need to download and install SQL Server 2012 Express if you haven't already done so. See Install SQL Server Express.

Run SQL Server Migration Assistant for Access (32-bit).

SQL Server Migration Assistant Wizard

Click Next. Select SQL Server 2012. Click Next

SQL Server Migration Assistant Project

Click Add Databases. Browse to your customer.mdb file and double-click or click Open. Click Next.

SQL Server Migration Assistant Add Database

Click Next.

SQL Server Migration Assistant Select Objects

Click Next.

Here you will need to specify the Server name. If you are connecting to SQL Server Express on this PC, the Server name will be .\SQLEXPRESS and it may be filled in for you. To connect to SQL Server Express on another PC called Server1, the Server name will be Server1\SQLEXPRESS. To connect to the full version of SQL Server on another PC called Server1, the Server name will be Server1.

SQL Server Migration Assistant Connect

You will be prompted to create the Customer database. Click Yes.

SQL Server Migration Assistant Create Database

Click Next. On the Link Tables screen, make sure Link Tables is not ticked.

SQL Server Migration Assistant Link Tables

Click Next.

The tables will now be converted and copied to SQL Server.

SQL Server Migration Assistant Convert Objects

SQL Server Migration Assistant Synchronize

Click OK.

SQL Server Migration Assistant Load

Click Close.

Now if you run SQL Server 2012 Management Studio, you should be able to see the tables in the database.

SQL Server Express Database

Unwanted Disallow Zero Length Constraints

The upgrade to SQL Server may generate some "Disallow Zero Length" Constraints in the SQL Server database like this. If it does, right-click on each one and select Delete to delete it (and check the other tables too).

Important - check all the tables and delete all the "Disallow Zero Length" Constraints from all the tables - not just the ones shown here.

SQL Server Disallow Zero Length Constraint

More Information

We have some short CRM Videos about Amphis Customer CRM Software and also a CRM Quick Guide with more details and screenshots. We have Prices, Customer testimonials and CRM Software Case Studies or why not Download our CRM Software Free 60 Day Trial and try it for yourself ?

Bookmark and Share