SQL Server 2000

[Yuri]

Hello Everyone.

For the last several years we were using AS400 databases with Progress. Now my company purchased SQL Server 2000 and we need to figure out how to make connection to new database server. Can you tell me what has to be done to make this connection.
We are using Progress 9.1C.

My Email is: yzhitnit@dnb.com
Thanks for your time.
Yuri.

 

[S.Conlon]

I assume that you have updated you Progress configuratiuon file (by installing the Progress DataServer for SQL Server).

I converted a Progress database to SQL server. I do not know if you can do this directly from AS400 so maybe you first need to create a Progress DB.

Also, you should first create an empty SQL database on the SQL server and create an ODBC connection to this DB using the Progress SQL Server Dirver (though you can also use the standard "SQL Server" dirver).

Then using the Progress Data Administrator you can connect to the progress database and run the "Progress DB to MS SQL Server" utility.

This will eventually create your schema holder and all the tables on SQL server.

Basicaly these are the steps in a nutshell. Once your schema holder (and the SQL tables) is created you can export you data from AS400 to SQL.

Some things you may need to coinsider:
1. create the SQL database first. Only when its properly created (without errors) should you import the data.
2. case-sensitivity seems to be determined by SQL server. All character fields will be given the case-sensitivity which is the SQL default.
3. When using the "Progress DB to MS SQL Server" you should connect to the SQL Server as the System Administrator - otherwise the tables will not be created. Connecting as a user with SA rights will not work either.

Good luck
Sean