You use this program to migrate one of your existing C-ISAM based companies to a SQL database.
See Prerequisites in Notes and warnings.
| Field | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Test Connection | Select Next to test the connection to SQL Server. | ||||||||||
| Database creation | SYSPRO uses a separate database for each company. You
can use this wizard to create the database, or create the
database yourself using a SQL Server
utility.
|
||||||||||
| Table definition | The database requires a definition of all the tables
used to store your company's data.
|
||||||||||
| Temporary directory | This is the temporary folder that SYSPRO uses for the BULK INSERT process. The process requires that each of your C-ISAM files is transferred to an intermediate bulk copy file format before being imported into the database. | ||||||||||
| Change Code Page | Select this to specify the code page to use for the BULK INSERT statement when collating data. If you do not select this option, then a default code page is used by the wizard. You can configure a code page at company level. | ||||||||||
| Restart bulk copy | If the bulk copy processes fails, then this option lets you resume the process. | ||||||||||
| Skip Bulk Copy | This skips the bulk copy process (e.g. there is no data to migrate, or the data has already been migrated). If you skip the bulk copy process, then your C-ISAM data will not be inserted into the SQL tables. | ||||||||||
| Start Bulk Copy |
This starts the bulk copy process. It must be selected once only. If the process fails, then you must use the Restart bulk copy option. Otherwise you will have duplicate data in your SQL tables. |
||||||||||
| 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 | This lets you 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 Operators program. |
||||||||||
![[Note]](images/note.png)
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
- 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.
-
Operators are denied access to your existing C-ISAM-based company during the migration process. This is to prevent partially updated information from being transferred.