Database Connection Properties

In addition to the standard ODBC parameters used to establish Database Connection, Cross-Database Studio workspace contains a variety of internal advanced properties.

1. Right-click on Database Connection name
2. Use "Properties" from the menu
3. "Connection properties" dialog will open

General

• Connection Name - Data Source alias defined by user. Use descriptive names to easily differentiate between database connections.
• Description – optional, additional description to the database connection.
• ODBC settings – in order to connect to the database, you can use an existing registered ODBC DSN, or create an ODBC Connection String.
• ODBC tracing – use this option to enable or disable using of Windows ODBC Manager trace facility.
  Note: the option does not start or stop the tracing. When the tracing is disabled, the program forces the ODBC Manager not to call the tracing functionality even if the tracing has been started via ODBC Manager UI.
• Database Type – Database Connection may automatically recognize the back-end database's vendor. Alternatively, there is an option to pre-define back-end database's vendor, selecting the name from the combo-box.
• Test Connection – click to test connection to the database, using defined ODBC parameters.

Settings

• Schema Mode - General ODBC parameters don't deal with Schema parameter. Cross-Database Studio Workspace provides this internal advanced parameter to establish the access to the database objects more quickly and specifically. There are three variants of the mode:
  • Database User Schema – using this mode, all objects, created by the Owner who is defined as the User in ODBC connection string, will be accessed.
  • All Database Schemas – using this mode, there is an option to access all the schemas authorized for the user defined in the ODBC connection string. Press "Set Schemas List" to select schemas you are interested in, from the full list of authorized schemas. Only selected schemas will be shown under Database Connection.
  • Custom Schema – using this advanced mode, you can create "virtual" internal schema. This schema appears only in the Cross-Database Studio environment and isn't shown in the back-end database. This mode allows you to predefine the exact list of objects you are going to use in the Cross-Database Studio with current Database Connection. This mode is recommended if your back-end database has a huge amount of objects in different schemas, but for Comparison, Synchronization and Migration needs you plan to use a short list of objects. To define the custom schema, use "Custom Schema Wizard".
• Order By suffix – ASC/DESC – if specified, all general data selects will be returned using this Order By clause.
• Timeout – an idle timeout, specified in seconds.
• Delimiter Identifiers – for Synchronization, Migration and Scripting and other needs, Cross-Database Studio creates SQL statements. SQL statement will contain a list of objects (for example, list of fields in the SQL Select clause). These objects may be surrounded by different identifiers – single quotation marks, double quotes… To enforce the correct character, which is relevant to your database, select "Use delimiter identifiers". You can use the database predefined characters or specify your own. If you don't want to enforce the character selection, don't select "Use delimiter identifier" and SQL statement will be created without any special characters around the object names.
• Auto Save/Load Settings – while working with the database connection you can change statuses of different objects shown on the tree. You can disable/enable tables or views, use filters or order objects according to your needs. These settings are internal and only the part of Cross-Database Studio Workspace. If you want these settings to be saved and loaded automatically, select "Auto Save/Load Settings"
• Use Transaction mode – if your database supports transactions, it is recommended to select this option. Once this option is selected Database Connection will work under transaction.
• Post Connection Operations - sequence of commands, being transmitted to database and used to adjust the connection, after the connection has been established.

Date/Time Format

Boolean Format

See also:

• Create Database Connection
• Import Database Connection
• Delete Database Connection
• Database Connection Properties
• Connect to the Database
• Database Connection Objects Settings
• Custom Schema