SQL Company Setup

> SQL Company Setup

SQL Company Setup

You use this program to migrate one of your existing C-ISAM based companies to a SQL database.

SQL Company Setup

See Prerequisites in Notes and warnings.

Field

Description

Test Connection

Proceed through the prerequisites reminders and select Next to test the connection to SQL Server.

I require this wizard to create the database on selecting Next >

Select this to let the wizard to create the database.

Generally the model database is used to determine the initial size and other initial settings for the database.

I will create the database myself before selecting next>

Select this to create the database yourself using a SQL Server utility.

Please enter database name

SYSPRO uses a separate database for each company.

The database name can be up to 20 characters long and should be used to identify the company. It must be entered in this field.


	SYSPRO requires a database with Binary or Case Sensitive collation.

See also Database collations.

I require the wizard to create the SYSPRO tables for me

The database requires a definition of all the tables used to store your company's data.

Select this if you want the wizard to create the required tables.

Create Tables

Select this to create the required tables. This is performed by using CREATE TABLE SQL statements.

I have already created the tables and wish to continue

Select this if you previously created the required tables. After selecting this option, you select Next> to continue.

The bulk copy process requires a temporary directory for storing the intermediate bulk copy format files

For optimum data migration, SYSPRO uses the SQL Server BULK INSERT statement. This requires that each of your ISAM files is transferred to an intermediate bulk copy file format and then the BULK INSERT statement will 'import' these files into the database.

Temporary directory

Indicate the temporary directory to use for the BULK INSERT process.

Change Code Page

Select this to specify the code page to use for the bulk insert. If you do not select this option, then a default code page is used by the wizard. The code page is used by the bulk insert command when collating data.

Restart bulk copy

If the bulk copy processes fails, you use this option to resume the process.

Skip Bulk Copy

Select this to skip the bulk copy process.


	If you skip the bulk copy process, then your ISAM data will not be inserted into the SQL tables. You select this option if there is no data to migrate, or if the data has already been migrated.

Start Bulk Copy

Select this to proceed with the bulk copy process.

This option must only be selected once.

Do not select this option after the Bulk Copy process has started or if it failed. You must use the Restart Bulk Copy option in this case. Failure to do this results in duplications of data in your SQL tables.

The bulk copy process was completed successfully

Select this proceed to the next screen.

The new database name is

This indicates the name of the new SQL database created by the migration process.

Your company company name is now ready to be used

Allow operators to login to this company

Select this to enable operators to be able to log into the newly migrated SQL company.

Test Current Login

Select this to verify that you can connect to the new database with the appropriate permissions.

Depending on your authentication method, you will need to set up a login and password in SQL Server.

If you are using SQL Server Authentication, then the SQL Server login is defined against each operator. The default login is the operator code with a blank password. You can amend this using the Operator Maintenance program.

Finish

Select this to exit the wizard.

Notes and warnings

Prerequisites

Before starting the migration, please ensure that you have met the following requirements:

You require an installed and running version of Microsoft SQL Server 7.0 Service pack 1 or higher or Microsoft SQL Server 2000.
You will need an ODBC data source that links to SQL Server
You must ensure that the SQL Server Administration information has been configured correctly using the System Setup program. These settings include database connection information, system-wide database information and SQL Server Admin login credentials.

Restrictions and limits

Operators are denied access to your existing ISAM base company during the migration process. This is to prevent partially updated information from being transferred.

Date formats

Dates and times are formatted using the universal format YYYY-MM-DDTHH:MM:SS where T indicates the time in 24 hour time notation.

For example July 1 2014 1:10PM is inserted into the database as 2014-07-01T13:10:00.