Access to SQL Server Upgrade for your CRM Software

Access to SQL Server Express - Upgrade Amphis Customer CRM Software to use a true Client Server Database

You can use Amphis Customer CRM Software with the free version of Microsoft SQL Server called SQL Server Express. This means you can support many users in true client-server fashion which gives superior performance and scalability improvements over using Microsoft Access.

What does this cost ? Absolutely nothing. Microsoft SQL Server Express is totally free. Amphis Customer CRM Software supports Microsoft SQL Server Express at no extra charge.

You just need to upgrade your existing Access Database to SQL Server Express and change the config.mdb file to use SQL Server Express instead of the supplied Microsoft Access Database.

Upgrade to SQL Server for Superior Performance and Scalability

This 2 mins 30 seconds video shows how to upgrade (for free) the supplied Access database to a SQL Server Express (Free Edition) database for Superior Performance and Scalability. This is recommended for more than about 10 or 12 users and allows you to expand the number of users beyond what a Microsoft Access database can handle.

You need to set a valid SQL Server connection string in config.mdb and and you need to set useSQLServer to true.

Here is an example connection string.

Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=customer;Trusted_Connection=yes;

We have a free tool you can download here to test your connection string. Just unzip and run the .exe

You can use the Access 2007 facility to Upgrade your Access Database to SQL Server 2005.

Please upgrade to the latest version of Amphis Customer before upgrading to SQL Server. For the latest version information, see our home page.

Access to SQL Server

For detailed instructions on upgrading your Amphis Customer database to SQL Server Upgrade to SQL Server