Progress
DataServer for
Microsoft SQL Server
Guide


Preparing to Use the DataServer Utilities

Subsequent sections contain tutorials that illustrate using the DataServer utilities to maintain your schema holder. Before you use these tutorials, you must perform some preparatory steps, including creating the demonstration database and schema holder and accessing the DataServer’s SQL Server Utilities menu.

To prepare to use the DataServer utilities, follow these steps:

  1. Make sure that you have done the following:
    1. Installed and started your data source
    2. Installed and configured your drivers
    3. Installed and configured the client software
  2. Create an empty database for your data source.
  3. Start the ODBC administration tool for your data source.
  4. Select the appropriate ODBC driver.
  5. Select the target ODBC data source.
  6. Make any additional selections required by your data source.
  7. Specify mysport as data source name. The name that you use to register a data source is the name that Progress recognizes.
  8. Exit the ODBC administration tool.
  9. Make sure that the data source has started.
  10. Start a local Progress session using the following command on NT or Windows:
    install-path\dlc\bin\prowin32 
    
  11. Starting a local Progress session also automatically starts the local DataServer.

  12. Access the Progress Data Administration tool. Create a copy of the sports database and connect to it.
  13. Select DataServer MS SQL Server Utilities Schema Migration Tools PROGRESS DB to MS SQL Server to start the Progress-to-MSS Utility.
  14. Specify Progress-to-MS SQL Server parameter values as noted in Table 5–1.
  15. Table 5–1: Progress-to-MSS Utility
    Interface Element
    Description
    Name of the Original Progress Database
    Accept the default value of sports, which is displayed.
    Other connect parameters for Progress Database
    Accept the default value, which specifies the current working database.
    Enter name of Schema holder Database
    Type myholder.
    Enter the Logical Database name
    Type name that Progress will use to identify the SQL Server™ database.
    Enter name for Database in the ODBC data source
    Type mysport, which is the name you used when registering the data source.
    Enter the Username
    Type the user ID for SQL Server™ database.
    Enter user’s Password
    Type the password of the user.
    Enter other connect parameters
    See "Connecting the DataServer," for connection parameters.
    Enter codepage for Schema Image
    Accept the default code page.
    Maximum length of VARCHAR field
    Enter the maximum size of the VARCHAR field. Any size greater will be text. Max size is 8000.
    Create RECID field
    Check this toggle box to obtain the cursor scrolling capability.
    Load SQL
    Leave this box checked to have the generated SQL script loaded into the data source.
    Move Data
    Check this toggle box to dump and load data from Progress to SQL Server™.
    Create Shadow Columns
    SQL Server™ is case insensitive by default. Leave unchecked unless the default has been changed and you want Progress behavior.
    Create Desc Index
    SQL Server™ does not support Descending Indexes. So any indexes that have descending components are skipped. If this box is checked, all indexes are created as ascending.
    Include Defaults
    Check if you want the Progress initial value used as the default in the SQL script.
    Use Field’s SQL Width Column
    If your Progress database contains data that is larger than the display format, you can check this toggle box. Change the SQL width field in the Data Dictionary to the proper size. The utility will use the SQL width field instead of the display format.

    NOTE: For a complete description for running while in batch mode, see Table 5–5 in the "Running the Progress-to-MSS Utility in Batch Mode" section.

    Running the utility creates and connects a schema holder and the SQL Server™ database. It operates as follows:

    1. SQL script is generated.
    2. SQL that creates the schema is sent to the SQL Server™ data manager.
    3. The schema is pulled back to the schema holder.
    4. The schema holder and the Progress database are compared and all information needed by Progress is applied to the schema holder.
    5. Data is loaded if selected.
    6. The schema holder is disconnected.
    7. A message is displayed that tells the user which startup procedure to use to connect. Additionally, the entered connect information is also stored in the db record which the DataServer can use to automatically connect.
  16. Choose DataServer MS SQL Server Utilities to see the available DataServer utilities, described in Table 5–2.
  17. Table 5–2: DataServer Utilities
    Utility
    Description

    Create DataServer Schema...

    Creates a schema image in the schema holder for the SQL Server™ database.

    Update/Add Table Definitions...

    Updates the schema holder to reflect any changes that you make to data definitions.

    Verify Table Definition...

    Makes sure that the data definitions in the schema holder match your data source data definitions.

    Edit Connection Information...

    Changes connection information or the logical database name for a SQL Server™ database.

    Change DataServer Schema Code Page...

    Changes the code page in the schema holder associated with the SQL Server™ database.

    Delete DataServer Schema...

    Deletes a schema image from the schema holder.

    Schema Migration Tools

    Accesses a utility for migrating a Progress database to a SQL Server™ database.

  18. When you access a DataServer utility (as you will do in the tutorials that follow this section), the following dialog box might appear before the utility opens:
  19. In the User ID and Password dialog box, choose OK if you are satisfied with the user ID and password combination that you supplied. If you want to change them, or they were never specified, enter a user ID and password with the privileges required for creating and updating a schema holder. See the "Establishing Permissions" section in "Configuring the DataServer," for information on privileges.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095