Data Management > SQL DB or Folder Data Transfers

This Task will allow you TRANSFER DATA from Multiple Source (sql or Folder) Tables at a time to EXISTING Destination Tables (SQL only)

NOTE : there is NO checking done before starting the task if the destination Table exists - the Profile corresponding to a missing table will simply not be run - the error reported and the Next profile Table treated.

Options :

Transfer a complete SQL DataBase (to same or different SQL server) - all the Tables contained in the selected DB will be offered

Transfer a complete FOLDER on your machine - all the TPS and or DAT Files contained in this folder will be offered

(the folder can contain Tables with extensions declared in DMC and those will be associated to their "parent" format)

dmc_sql_db_transfer_message

If you select a FOLDER level task then DMC will scan it and warn you if duplicate names are found (ie a TPS and a DAT with the same NAME on HD) as this would cause problems.

dmc_sql_db_transfer_dupe_message

This allows you to change the File NAMES (or to delete one) to allow this Folder to be selected.

dmc_sql_db_transfer

or if you are cloning an SQL DataBase

dmc_sql_db_transfer_db

All the Tables are pre selected for you (icon on the left of the Table Name)

A double-click will toggle selection or you can use the Tag All UnTag All buttons

Select the DESTINATION DataBase you want to use (double-click)

This will display on screen the next step required

dmc_sql_db_transfer_options

Task Option

Run created Data Profiles

If you want to immediately Transfer all DATA from your source to the existing tables, check this option box and at the end of the Profile creation task DMC will close and reopen to run ALL data Transfer profiles generated and ALL your Data will be transferred immediately.

A new Project is created for you containing all the Profiles and this is what you will find in the Projects & Profiles module

dmc_sql_db_clone_profiles

A Project is created named as per the FOLDER or DB Name selected and it contains ALL the Selected Tables Profiles

You can Export this project and ship it to your clients to use with the RT engine.

NOTES

We recommend you to Restore each and every profile and run it before shipping it to your end-users

We recommend you during these test phases to do all your mapping Options also before you ship the project

THIS TASK IS RUNTIME ENGINE COMPLIANT

If you need to perform this task on your clients machines , then SAVE it as a Profile when all is defined and use the Runtime Engine to run it from your application

The different settings on source - destination Folders (even Table Names) plus some ODBC settings like User Name and Password can be changed dynamically from your application to meet your requirements