|
Settings |
  
|
|
Settings |
|
In this setting module you can set the general DMC settings grouped in 4 different groups (Display - DMC and Blob Size - EIP and SQL => click on a TAB to load the respective settings)
All modifications done here will apply immediately in all modules opened after a change is done
From version 1.6.0.3 there is also a PASSWORD for the ODBC module :
IF you leave this field BLANK then nothing is protected
IF you enter a password in this field THEN entering the ODBC module AND this SETTINGS module will be protected and users will have to enter the password
This enables you to protect your SQL passwords from being visible by users of DMC
To get the main frame resized to defaults (height - width and centered) DMC will be automatically closed and then re-open
Define the CHARSET to use in DMC will allow you to read display and write in ANY languages (Greek - Chinese etc ...)
You can define if you want the progress bars to be refreshed each percent or each 10% (default setting) - this can use some system resources on small files but on the contrary is useful on large tables to "know" where about you are.
You can define the DECIMAL separator to use and the number of Decimals to display in Viewer and in ASCII exports
You also have a checkbox to generate the proper data when debugging and logging transfers with Microsoft OutDebug Function (careful : if you do not have this separate tool installed you might get errors)
You can define if during a Clone to SQL (FOLDER or DB or table levels) the sql script should be lowercased for all table - key & column names.
You can define if the Export to TXD or DCTX will be generated in lower case (you also have a checkbox for this in the popup message asking you which TYPE of export you require)
You can also define if for all TRANSFERS you prefer reading only the first 50 records before the Mapping tab (the rest of data will then be read after clicking on the "Transfer" button
This speeds up enormously the process of showing you the mapping tab
You can define the mode of Edit In Place with various possibilities to best suit your way of working ...
Define if you want or not balloon Tips to be displayed on the System Tray Icon ....
Define if you want to display special tips in Data Management Wizard screen to enable direct on site links to HowTo pages.
Set the number of Recently Opened Tables to use in the Wizard
Set the size of the STRING to use when displaying MEMO & BLOB columns in the Viewer (memory problems if set too high) AND also use this setting in case of problems when cloning tables with many MEMO's or BLOB's (because of TPS record limitations)
Define if you want DMC to try and DETECT DATE and/or TIME columns in LONG format when cloning to SQL and change them in destination Table to a valid TYPE of column
(you can also define generic column name portion(s) you use to define a DATE and a TIME column so as to limit the detection - foreign languages usage etc ....)
Set the Destination Table DATE and TIME formats to use as defaults in display lists.
Define is you want to have a "Sum Up" screen displayed when clicking on the main Wizard "Finish" button (this is automatically set to ON in evaluation mode)
it gives you another possibility of canceling a task if need be.
You have a checkbox to specify if you want the Icon in the system tray to popup for 3 seconds a tip with the current task
This icon enables you also to HIDE - SHOW or QUIT the application
You have another checkbox to let you specify wether or not to open DMC after a command line process of a Profile restoration and data transfer in Silent Mode (application being completely hidden)
In the SQL Tab you will find all relevant settings :
Generate or not SQL Tracing files : saved in cgf_import/logs/sql and accessed from the Documents Tasks in the navigation panel
Set ANY 3 LETTER word as SQL RESERVED WORDS Prefix to use when cloning to SQL
Define the Number of records to read during a manual query : the SQL Data Tab displayed will contain and show them - you have of course the possibility to ask (button to load X records) all or more to be displayed.
Number of records to read during SQL CODED Data Transfers (COMMIT) : to avoid memory rising too high during LARGE Tables transfers, define here the number of records which you want read (creation of the SQL script) before the scripts are executed (record insertion)
ie. : a table of 1.2 Million records define a setting of say 2500 records to read before executing the generated scripts and then reading another 2500 records etc ... - this will avoid RAM used by DMC to go too high.