SQL Server Instructions

SQL Server Instructions
Converting SPC Explorer RT / SPC-PC IV Explorer's MDB database to SQL Server

Run Enterprise Manager
Select the SQL Server where you want to import the data
Right-Click on the Databases Folder and select All Tasks…/Import Data… from the menu.

In SQL 2008: Select the Import and Export Data option within the Microsoft SQL Server 2008 group in the Start menu.
When prompted for Data Source select Microsoft Access and browse to the MDB file you want to import.
When prompted for a Destination:

Select the Microsoft OLE DB Provider for SQL Server (SQL 2005) or SQL Server Native Client 10.0 (SQL2008); these are usually selected by default.
Type in the name of the SQL Server (usually provided by default)
Select the authentication method you wish to use (must have database creation permissions)
For Database select . This will prompt you for a database name. All other values can initially be left as default.

Set the Primary Key and Identifier field for each of the tables (the SQL Server Import utility does not do this automatically)

Using Enterprise Manager (SQL2005) / SQL Server Management Studio (SQL2008), select the database that was just imported
Select the Tables icon to get a listing of all the tables in the database
In Tools->Options->Designers->Table and Database Designers, uncheck the option for "Prevent saving changes that require table re-creation".
Right-Click on the first table and select Design Table from the menu
Within the design window right-click on the top field (the table's ID field) and select the Primary Key menu option
Also within the design window select the Identity checkbox for this top field to indicate it is a unique identity field within the table.
Close the design window and when asked to save select Yes.
Repeat these steps for every table in the database except for the system tables (system tables begin with “sys”)

Place the SPC Explorer disk into your CD drive.
Select Install SQL Server Files from the installation utility
The database has now been imported to SQL Server. Proceed to Step 4 if you need to configure the SPC Explorer RT Web Server.

Using Microsoft Access open the config.mdb file located (by default) in c:\inetpub\wwwroot\SPCExplorerRT
Double-Click on the Table called SPC
In the first record UNSELECT the Access field and SELECT the SQLServer field
Fill in the SQLServerName field with the name of the SQL Server machine
Fill in the SQLServerDatabase field with the name of the database supplied during the Import
Fill in the SQLServerUID field with the an SQL User that has SELECT/ INSERT/UPDATE/DELETE privileges to tables in the database
Fill in the SQLServerPWD field with the password for the SQL User