Converting from Pervasive to MS SQL



Converting from Pervasive to MS SQL

These are instructions on how to convert Response 6.3 running on a Pervasive database to Response 6.3 running on a MS SQL Server database. Before doing the live conversion you MUST do a trial. This means that you will need a separate test machine that is not your production server.

What you will need:

Either download or purchase the following items first.

• MS SQL Server install CD - purchase

• Pervasive Workstation Engine install – download at

• Response install – download at

• Conversion utilities – download at

• Pre conversion utility – CoLinear will provide this if necessary

• Key file – CoLinear will provide this

Conversion Overview:

• Install MS SQL Server 2000 – A

• Install Pervasive Workstation Engine – B

• Install Response (Application) – C

• Install Response (Database) to MS SQL Server – D

• Register Database Driver – E

o SQLFlex 7 from Mertech Data Systems

o Pervasive driver from DataAccess

• Migrate data from Pervasive Database to MS SQL Server database - F

A. Install MS SQL Server 2000

Please have your network administrator or outside network service provider install and configure your database engine and client connectivity components. Installing and configuring your database engine is not something CoLinear Technical Support can do for you, nor is it something you should attempt yourself unless you’re already familiar with network and database configuration setup procedures. We strongly recommend you plan ahead to be sure you’ll have access to expert help in case it’s needed. Please remember … we only provide the tools, not the expertise for configuring your unique computing environment to use them. That responsibility lies entirely with you.

MS SQL Server Installation

When you setup your MS SQL Server please have SQL Server Database Administrator make the following configuration changes:

• Using Enterprise Manager go to the Security tab in the SQL Server Properties window. Choose “SQL Server and Windows” as the authentication method.

[pic]

B. Install Pervasive Workstation Engine

The Pervasive Workstation Engine is used by the conversion program to copy data out of the old database. It should be installed on one machine only and uninstalled once the conversion is complete. Do not install the Workstation Engine on anything other than the one machine that you use to run the Conversion. Follow these instructions:

Installation

1. Insert the “Response For Windows” CD

2. Run “E:\ psqlwe\Setup.exe” (where “E” is the drive letter of your CD-ROM)

[pic]

3. Select the “Typical” install configuration and click “Next” to proceed to the “Select Installation Directory” screen.

[pic]

4. Accept the default installation directory and click “Next” to install the Transactional and Relational Interfaces.

[pic]

5. Click “Next” to perform the communication tests. Refer to the Pervasive Install Documentation if any of these tests fail.

[pic]

6. Click “Finish” and restart the computer.

C. Install Response (Application)

NOTE: If you haven’t done so already, please SHUT DOWN and REBOOT the server before continuing below. Be sure to perform the following on the “server” (not a workstation).

1. Copy the file uerinfo.key to a floppy disk and label it “Response Key File”. If you do not have this file then contact CoLinear and we will send it to you.

2. Find the previously downloaded file “ResponseForWindows.exe” and double-click it to run it.

3. Click “Microsoft SQL Server New Install”.

4. Click “Next” to proceed to the “Choose Destination Location” screen.

5. Click “Next” to accept the default install location and install the Response For Windows application files. [Please do NOT change the default install location unless you have an excellent reason for doing so and will remember to refer to this other location when we refer to the default.]

6. Response for Windows requires a valid license key file named userinfo.key. When Prompted insert the floppy disk created in step 1 above into your drive and accept the default A:\ prompt, (or enter the location where you saved it) and click “Next.” When complete, click Finish.

D. Install Response (Database) to MS SQL Server

1. Open “Programs \ CoLinear Systems” in the Windows Start Menu.

2. Choose “SQL Database Utility.”

[pic]

3. Select the appropriate server type you are using.

4. Enter the Server Name, Login, and Password.

[NOTE: For MSDE, this information will be defaulted for you.]

5. Click “Login” to view the active R4W Databases. If R4W_Primary is not found it will ask you if you want to create it. Answer “Yes.” This will install the blank Response For Windows database to your MS SQL Server.

6. Multi-company systems: Enter the multi-company code listed on your license disk, and click the Exec Code button. This will add the extra databases required to support multiple divisions.

7. Exit.

E. Register Database Drivers

Since you are copying data from a Pervasive database to a SQL database you will need to register both database drivers.

Pervasive driver from DataAccess

1. Run “…\r4w\bin\dfbtrdrv.exe”

2. Enter the required information. You should already have this information on file. This is what you used to register the Pervasive driver when you converted from Legacy to R4W.

SQLFlex 7 from Mertech Data Systems

1. Open to “Programs \ CoLinear Systems” in the Windows Start Menu.

2. Select “Register Mertech Driver for SQL Server” and enter the required information. CoLinear will send you a word document with this information in it.

** Install New Builds to the MS SQL Database following the instructions for MS SQL Databases so your new MS SQL Database is on the same build as your PSQL Database

F. Migrate data from Pervasive Database to MS SQL Server database

1. Make a copy of your production data. Whether you are doing a trial conversion or the real thing you should make a copy of the production Response data directory, “…\r4w\data”, and work from that copy.

a. When you make the copy all users must be out of Response.

b. Create a sub-directory on the new SQL Server machine called “data_pv” under “…\colinear\r4w”

2. Run pre-conversion utility. It is common for Pervasive databases to have some corrupt data. If this is the case in your database then this data must be fixed prior to running the conversion utility. If it has been determined that you have corrupt data CoLinear will send you a pre-conversion utility to run at this point.

3. Extract the contents of ConvPVtoSQL.zip to the “…\r4w\data_pv” directory created above and double-click on it

[pic]

4. Enter the full path to the Pervasive data directory created in step 3

5. Enter the full path to the SQL data directory created in step C

6. Click OK

7. Log in to the SQLServer using the “Mertech Database Drivers Automatic Login”. Enter the Server, User Name, and Password. IMPORTANT! Do not change the Database “default” entry.

[pic]

When you’ve completed your entries click Connect.

NOTE: Depending on the size of your database and the speed of your workstation, this may take 24 hours or longer to complete.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download