Converting to SQL
Before converting your Access database to SQL server, you
must have an existing SQL account. Contact ETI's support
team so that our technicians will be able to setup your
SQL account with the necessary parameters.
- Open your existing database inside of Access and choose
Tools > Database Utilities > Upsizing Wizard (see
figure 1).
- Once the wizard has started choose "Use existing database" and click
"Next" (see figure
2). You will then be asked to choose a data source. If
you already have one set-up for your SQL account, you may
select it here and skip to step eight.
- Go to the "Machine Data Source" tab and click New (see
figure 3).
- Choose a user or system data source depending on your security needs.
Then select "SQL Server" from the list and click "Next" and
"Finish" (see figure
4).
- You will then be prompted for the SQL server information. You received
this when you signed up for your SQL account. The name can
be anything you wish to refer to the data source with. The
description field is optional and the server is the IP address
of your SQL server (see
figure 5).
- On the next screen choose to login using "SQL Server Authentication."
Enter your username and password for your SQL account and
click "Next" (see
figure 6).
Note: Be sure "TCP/IP" is selected
in the "Client Configuration."
- Leave the next two screens at their default settings and click "Finish."
This will pop-up a confirmation screen where you can test
the data source (see
figure 7).
- Once you have your data source created, make sure it is selected
from the list and hit "OK."
- Enter your SQL password and hit "OK."
- You will then be asked which tables you want to convert to the new
database. Move the tables you wish to convert into the window
on the right and click "OK" (see
figure 8) .
- Leave the remaining settings at their defaults unless you know you
need to change them. Click "Finish."
Congratulations! Your database is now residing on the SQL
server. For more information on accessing your SQL data, please read
the SQL FAQ.
If you are using ASP to connect with your database your
code should remain pretty much the same. One thing that will need to
change is the connection string or data source name.
If you are using a DSN to connect with your access database
you will need to change it to the DSN you chose when requesting SQL
setup.
If you are using a connection string with your access
database it may have looked like this:
Driver={Microsoft
Access Driver (*.mdb)}; DBQ=E:\inetpub\users\User_name\Domain.com\Database.mdb
Your new SQL connection string will look like this:
Driver={SQL
Server}; Server=server_name; Database=database_name; UID=user_name;
PWD=password
PLEASE NOTE: These
walkthroughs are intended to assist you in setting up your software.
Screenshots and various instructions may differ depending on the version
of software you are using. When in doubt, please check the software
documentation for specific usage instructions.
|
