Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
The DataServer Tutorial : DataServer utilities
 

DataServer utilities

OpenEdge supports a number of utilities that allow you to create and maintain a MS SQL DataServer.
To see all available DataServer utilities, choose DataServer > MS SQL Server Utilities. The following table describes the DataServer utilities.
Table 50. DataServer utilities
Utility
Description
Create DataServer Schema...
Creates a schema image in the schema holder for the MS 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 MS SQL Server database
Change DataServer Schema Code Page...
Changes the code page in the schema holder associated with the MS SQL Server database
Server Attributes
Provides an interface to create, view, and maintain server attributes, and define constraint definitions in your OpenEdge database that can be migrated to the server. Constraint definitions are applied to the columns and indexes of the foreign database during migration and become metadata in your OpenEdge schema holder
Delete DataServer Schema...
Deletes a schema image from the schema holder
Schema Migration Tools
Accesses utilities for migrating an OpenEdge database to a MS SQL Server database, for incrementally migrating a schema to MS SQL Server, and adjusting the schema image
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:
To accept the user ID and password combination that you supplied in the User ID and Password dialog box, choose OK. 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 Authorizationand Authentication for information on privileges.
Note that the value msssports that appears in the previous User ID and Password dialog box identifies the MS SQL Server database to which a connection will be attempted. The actual database name that appears will depend on the specific MS SQL Server database to which you are trying to connect.