Data Management > Clone to TPS

After selecting "Clone a Table" as Task and your SOURCE Table and finally 'TOPSPEED' as DESTINATION you will be able to click on the 'Finish' button to start the process

You are asked in which Destination Folder you want to create the table (select a folder or keep the default value)

(if you select a new folder this path will be stored in memory and used again for any cloning task during the same session of DMC)

(if you select the SAME folder as the Source one then the table will be renamed as 'Dmc_' and append the Source table name not to create naming problems)

The New Table is created for you

1. You may require to adjust the Destination Table STRUCTURE (or if you accepted some date or Time changes) to better fit with your requirements (add a column - delete a Key etc ....) - from the "Mapping Tab" use the Switch Creation Wizard button

DMC opens up for you the Creation Wizard with all your table definitions pre loaded - you can click on the 'Table Creation' button or modify the table Structure

As you can see again in this screen all columns are keys are identical also for you to start your modifications

Again if any GROUP is found then the same rules will apply and will automatically be set for you...

This Creation Wizard will automatically find GROUPS and create all necessary records for you

In case of multiple columned keys, they will of course be automatically created for you to change if need be (double-click to open the key record etc)...

When all modifications are done to your satisfaction, simply click on the "Table Creation" button and a new TPS table with this new structure will be created in cgf_import/destination (overwriting the one created in the cloning process)

For you to transfer your data, you will now simply close this screen and open the main "Data Management" module , select your same source structure as for the cloning process and IN DESTINATION folder this newly created TPS file to carry on.

2. If you do not need to modify the structure (and if NO Date Time changes were done) you can stay in the Column Mapping Tab and Transfer the data (or close this module to keep an empty table)

After the Data is Transferred DMC will open up for you to work with it Windows Explorer in the relevant directory

When cloning from ODBC and when the TOTAL RECORD size will exceed 15k (TPS driver limitation), then DMC will try reducing automatically - in 2 steps 512 and 256 - those field size to allow the cloning process to be successful!

CSV Cloning : When you clone CSV to TPS - DBF - DAT and have a DATE (or TIME) column you are able to use special mapping settings

VERY IMPORTANT INFORMATION (for DEMO version ONLY) : you are ONLY allowed to do create 10 Tables cloned to TPS in demo mode and no extension can normally be given to this limit (different from SQL cloning)

BUT : if you clone TO or FROM our SQL's Test Server then you have NO LIMITATIONS

For example you want to test cloning an SQL table to TPS : select any existing Table in OUR Test servers and clone it to TPS (connection shipped by default with DMC) and you can repeat this task FREELY