User Tools

Site Tools


mssql_accelerator_synchronizer_server.htm
Navigation:  SQL Drivers > MSSQL Accelerator >====== MSSQL Accelerator Synchronizer Server ====== Previous pageReturn to chapter overviewNext page

Clarion's Enterprise Edition includes the MSSQL Synchronizer Server and the Data Dictionary Synchronizer. The Dictionary Synchronizer uses the Synchronizer Server to gather complete information about an MSSQL database.

The MSSQL Synchronizer Server is one of several used by the Dictionary Synchronizer. All the common behavior of all the SQL Accelerators is documented in the SQL accelerators section. All behavior specific to this driver is noted here.

MSSQL Accelerator Synchronizer Login Dialog

Clarion's Dictionary Synchronizer Wizard (Enterprise Edition) lets you import an entire MSSQL database definition into your Clarion Data Dictionary in a single pass. During this process, the Synchronizer Wizard opens an MSSQL login dialog. This dialog collects the connection information for the MSSQL database.

NoteBox.jpg

If you are using a Trusted Connection (Integrated NT Security), you must establish a connection to the NT workstation running the MSSQL Server before you can connect to the MSSQL database and import table definitions. You can verify your connection by running the MSSQL ISQL_w Server utility installed with your MSSQL Client software.

Fill in the following fields in the login dialog:

Host Select the workstation running the MSSQL database to import from. If the Host list is empty, you may type in the name. See your DBA or network administrator for information on how the host is specified.
Database Select the MSSQL database that contains the tables or views to import. If the Database list is empty, you may type in the name. See your server documentation or your DBA for information on database names.
Username For Standard Security, type your MSSQL Username. For Trusted Security (Integrated NT Security) no Username is required. See your server documentation or your DBA for information on applicable Usernames and security methods.
Password For Standard Security, type your MSSQL Password. For Trusted Security (Integrated NT Security) no Password is required. See your server documentation or your DBA for information on applicable Passwords and security methods.
Include System Files Select this option to include system tables in the list of importable objects.
Exclude System Files Select this option to exclude system tables from the list of importable objects.
Other Filter Select this option to provide a filter expression to limit the list of tables and views to import. The filter expression queries the dbo.sysobjects table. The filter expression is limited to 1024 characters in length.

TipBox.jpg

The filter is case sensitive, so type your filter value accordingly.

Following is a list of the column names (and their Clarion datatypes) you can reference in your filter expression. Generally, filtering on MSSQL system tables requires not only an intimate knowledge of the MSSQL system tables, but also of the MSSQL stored procedures. For example, to filter on table owner:

   uid = user_id('DBO')

See your SQL server documentation for information on the MSSQL system tables and stored procedures.

name CSTRING(31)
id LONG
uid SHORT
type STRING(2)
userstat SHORT
sysstat SHORT
indexdel SHORT
schema_ver SHORT
refdate STRING(8)
crdate STRING(8)
version LONG
deltrig LONG
instrig LONG
updtrig LONG
seltrig LONG
category LONG
cache SHORT
mssql_accelerator_synchronizer_server.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1