SQL Script Editor

SQL Script Editor Tab

When this tab opens up you are offered the full sql script created for your table

In SQL and MySQL ONLY all INDEX's will also be included in the script

You can change the Table Name directly in the field on top of this window ONLY (then press the TAB key to process the script which will be automatically rewritten for you with all the necessary other processes)

This script is already saved on hard drive for you in the directory \cgf_import\Structure\ with a naming convention as follows :

'Clone_' and the Table Name and '_' and the SQL driver (SQL-MySQL-Oracle etc...) and finally with '_Struct.sql'

You can modify directly the script and save it to any name you wish by clicking on the "save as..." button

The default name offered for saving uses the same naming convention but instead of 'Clone_' it starts with 'UserScript_' for you to separate them more easily

If you want to abort the complete cloning process you can use the "Stop" button

You click on the "RUN" button to create the new table and have the process follow it's course till the Mappings Tab

In case of an error, you will be told so by two messages and the sql script placed in the clipboard for you

To show you this error message, we removed a comma in the script on column NOMORG ....

You can of course modify the script and try to run it as many times as needed till success or till you cancel the process

The process is now resumed and you are offered the mapping tab for you to transfer your Data