Getting Started

Use the topics in this section to prepare to clone a DMSII database.

Before you clone a DMSII data source, you must create Client control tables. Once they're created, you can populate them with DMSII information sent by the DATABridge Engine and create the actual data tables that will store your cloned data. The resulting data tables are based on information from the Client control tables and any additional customizations you make.

To customize how DMSII data sets get mapped to their relational database tables, you can write user scripts in SQL. Writing and testing user scripts is typically time consuming and requires quite a bit of trial and error. For instructions, see Customizing with User Scripts.

Alternatively, you can customize data set mappings using the Client Configurator. The Client Configurator is compatible with command-line operations and can help make reorganizations easier to handle. For more information, see the Help in the Client Console.

In this Section

Tips for More Efficient Cloning

Creating Client Control Tables

Defining a Data Source

Customizing with User Scripts

Creating Indexes for Tables

Cloning DMSII Dates, Times, and Date/Times

Numeric Date and Time in Non-Contiguous Columns

Adding a Non DMSII Column

Generating DATABridge Client Scripts