| **Navigation:**  SQL Drivers > MSSQL Accelerator >====== MSSQL Accelerator Synchronizer Server ====== | [[mssql accelerator supported file commands and functions.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[odbc accelerator driver.htm|{{btn_next_n.gif|Next 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 accelerator drivers.htm|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|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|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 |