Kbase P23300: How to create a schema holder for MS SQL server DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/02/2009 |
|
Status: Verified
GOAL:
How to create a schema holder for MS SQL server DataServer?
GOAL:
How to access a MS SQL database and create a schema holder?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
Windows
MS SQL DataServer
FIX:
Make sure the following is already configured and set up before creating the Schema holder
a. The SQL Server is running and SQL server database has been created.
b. Created a system DSN against the SQL server database using ODBC Administration tool.
Steps to create a schema holder:
1. Create a Progress empty database used as schema holder.
Command line: prodb <schema holder db name> empty
2. Connect to the Progress database in single user mode.
Command line: prowin32 <schema holder db name> -1 (on GUI client)
or
pro <schema holder db name> (on CHUI client)
note: add -rx parameter if you are using a runtime license.
3. Go into Tools menu -> Data Administration -> DataServer -> MS SQL Server Utilities and select "Create DataServer Schema..."
4. Add the below values to following fields
Logical Database Name: <logical name of the SQL server database>
Connection Parameters: -U user -P password
ODBC Data Source Name: <name of the ODBC datasource>
Click OK.
5. At the "User ID and Password" window, you can enter the same or another user name and password but if you just click OK it will use the same username and password that have been entered from the previous window.
6. At the "Pre-Selection Criteria For Schema Pull" window, enter the appropriate values that will be listed.
7. Once the objects are listed at the "Select MSS Objects", select the objects that you would like to pull into the Schema Holder and click OK.
8. Once complete, Progress Data Dictionary main menu will come back.
The building of the Progress Schema Holder is now complete.