Because of the much higher performance of SQL Server this is highly recommended for sites with a high number of visitors. This will increase speed and provide a better user experience which in turn will turn visitors into customers more easily.
Open SQL Server Enterprise Manager and click on the database server. You will be presented the following screen. Click on Import or Export Data.
Select Import using Data Transformation Services wizard to start the import process.
Select the Access file that you want to migrate.
Click on the Advanced button to enter additional information and edit Jet OLEDB:Database Password and enter your database password in the value column..
Select Next to go to the destination server details. Select the server and the type of authentication needed. The default SQL Server installation uses SQL Server authentication, username sa and blank password.
Select the database that you want to create or select <New> to create a new database.
If you select to create a new database you will need to provide a name, a data file size and a log file size:
Click Next, select Copy table(s) from the source database and click Next.
Select Next to select the objects that you want to migrate. Click on Select All and Next.
Click on Next and select Run immediately. Click Next to start the migration.
After the migration process has finished check that it has run correctly and all the tables appear in the database chosen.
Unfortunately the process seems to forget converting Access fields set as Autonumber to identity. You will have to do this manually on the following tables. Double click on a table and check the identity column for the following tables/fields:
| Table | Field |
Availability | id |
BillingStatus | id |
Carts | id |
Categories | id |
ColourDefinitions | id |
CommonList | id |
Historic | id |
Orders | id |
Orderlines | id |
OrderComment | id |
OrderCommentType | id |
PriceOptions | id |
Products | id |
RelatedProds | id |
StateMessages | id |
Status | id |
Users | id |
Note: The tables above are not up to date. You will need to check all tables in the access database and look for autonumber fields.
Next you will have to configure your Q-Shop system to use SQL Server as explained in the manual provided.
Tip: Check that your SQL Server database cannot be accessed using login "sa" and blank password.
