|
Settings |
  
|
|
Settings |
|
In this settings module you can set the general DMC settings grouped in 6 different groups
(Display - DMC - EIP and Blob Sizes - Date & Time - SQL & SQL options => click on a TAB to load more respective settings).
All modifications done here will apply immediately in all modules opened after a change is done.
(you do not need to close and re-open DMC to apply the changes)
Press the Main Frame Reset Size button to get the main frame resized to defaults (height - width and centered). DMC will close and then re-open.
You can define the DECIMAL separator to use and the number of Decimals to display in Viewer and in ASCII exports
Grouping Displays allows you to define how you want to see numbers displayed on screen.
Charset for List boxes allows you to define how DMC will display and write in ANY languages (Greek - Chinese etc ...). The default is ANSI.
Refresh Progress Bars each percent. You control how frequently DMC updates the Progress Bar during a transfer. The default (un-checked) is to update the display for each 10% completed. If you check the Refresh Progress Bars each percent then DMC will update the progress at each 1%. More frequent updates provides more information at the cost of system performance.
Transferred Data controls the list box which show what data was transferred and (sometimes more importantly) what data failed to transfer. If this box is checked and the number of records is less than the Number Records to Transfer Threshold then you'll see these list boxes. If you don't care to see that information, uncheck the box. Use a value of 0 as threshold to display always.
Balloon "Tips" are pop-ups that appear when you hover over a control with the mouse. They provide some additional information - especially helpful for new users. If you find them annoying, then un-check these boxes.
Display a "Sum Up" Data Management Wizard task screen. DMC can display "Sum Up" screen after clicking on the main Wizard "Finish" button (this is automatically set to ON in evaluation mode) which tells you the tasks ahead and gives you another possibility of canceling a task if need be.
Hide the Left Navigation Panel. If you need more room on the screen you can turn on the nice menu on the left navigation panel and use the top toolbar instead.
Balloon Tip in system tray icon.
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 and with progress updates. This icon enables you also to HIDE - SHOW or QUIT the application.
Display GROUPS as MyGroupName:MyColumnName. To help with the "readability" of groups, DMC can add the MyGroupName: before the column name when the group column names are displayed. If you like that idea, just check this box.
Reset all settings to factory defaults will erase all your settings, close and re open DMC with settings set back to when you installed it first.
Long tasks Options is used to allow you to define when you prefer having DMC "out of the way" during tasks which can take up some time to finish.
The Port to SQL Dictionary and Application are such tasks and depending on the number of Tables in your DCT, define a threshold here to hide DMC while it works.
Transfer data tasks can also benefit from this setting after you have defined the number of records threshold to hide DMC while it works.
Output Debug String is only needed if you also have SYSINTERNAL's Debugger installed. Check this box 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)
Read only the first 50 records while doing a Transfer. When checked, this option tells DMC to load only the first 50 records before displaying the Mapping Tab for a data Transfer. This speeds up the process of showing you the mapping tab significantly. This does not limit the data transferred. Once you launch the Data Transfer, all records will be read and transferred based on your other settings.
Delete Temp Tables while closing the application tell DMC to clean up on each exit. For troubleshooting, you may want to turn off this option so you can open those temp tables with Viewer or TopScan.
Open DMC after a command line run. You can run a variety of functions in DMC from the command line. This allows you to execute data transfer Profiles and Projects without having to step through the DMC interface. If you want DMC to complete the task and remain open then check this box. If not, DMC will complete the task silently and stay closed. See the Help for the Runtime Engine for more information.
Cloning a table and/or during Port to SQL
One of the options in the SQL Normalization settings allows you to specify how you want your new Dictionary designed. This setting will determine the case of each table, column and key name. You can select lowercased, UPPERCASED or CamelBack. There are no exclusion options available. This does nothing to your data. It only changes the case for the Table, Column and Key names in the dictionary & created SQL tables. This option is also used during a clone table task.
If you select "lowercased" then all table names, column names and key names will be converted to lowercase letters.
As you would expect "UPPERCASED" puts them all in capital letters, and "CamelBack" leaves them all they way they were in your DCTX.
DMC Module Password. This enables you to protect your SQL passwords from being visible by users of DMC. If you enter a password in this field the ODBC module AND this SETTINGS module will BOTH be protected and users will have to enter the password to view or make changes. If you leave this field BLANK then nothing is protected or restricted.
You can define the mode of Edit In Place with various possibilities to best suit your way of working ... you can also change this setting when you are Viewing a table from the top frame toolbar.
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)
BLOB's are stored in a temporary table during Viewing and data transferring : define the thresholds to switch from a FAST in memory table to a SLOWER (but able to contain any amount of data) hard disk table. If the table you are working on has more Blob's than your threshold OR if the number of records is greater than your threshold, then DMC will switch to a hard disk table.
You can define the SIZE of a MEMO column (TPS side) CLONED from an ACCESS memo to a TPS Table.
Select a Default FORMAT. Default for Destination Table output
Try to Detect Date & Time Columns. 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 ....)
Generic DATE/TIME Column NAMES Used: DMC tries to identify Date/Time columns based on their names as well. This is important for conversion to SQL and creating Date/Time groups. If DMC sees 2 longs in sequence with the name that contain "Generics" from your list it will create a Date/Time group and change the column format. For example: OrderDate with a format @Dx followed by OrderTime with a format @Tx. If these fields are left blank, DMC will offer you ALL the Long columns as possible Date or Time columns.
In the SQL Tab you will find all relevant settings :
SQL Reserved Words Prefix to use. SQL is much less forgiving than other data structures. The use of SQL Reserved Words will lead to errors, so DMC identifies them and offers a suggested replacement. You can make changes to the suggested replacement. After that step (during a Port to SQL task), DMC applies the change(s) throughout your Dictionary and Application code (even your embeds). For example, "Check" is a reserved word. TopSpeed files don't care if you have a column/table or key named Check, but SQL will fail if it stays that way. If you have a column named Check in the Transaction (TRA:) file, DMC will change it to TRA:Sql_Check so it works. DMC will also fix your embeds, keys, and other application code for you so you won't have to do that step manually after the Port to SQL completes. This prefix is also used during Clone to SQL operations.
This setting also is used when performing a normal clone table to SQL task.
Caution: Choose your Prefix carefully. If you table already contains a Sql_Check column (in this example) it will not transfer properly. In such a case, just choose another Prefix as your default - or be sure to fix the replacement column before during the Port to SQL process.
Break SQL INSERT on First ERROR. Do you want DMC to stop when it finds the first error?
Read SQL VIEWS. Check this box to include SQL Views. Careful: this can effect performance when there are many views to list
Generate a log file of all SQL Transfers. For more details about the transfer, check this box and DMC will generate the following files which are saved in cgf_import/logs/sql and accessed from the Documents Tasks in the navigation panel
| • | Transfer_Logfile.Log for SQL tracing - contains any sql script generated to insert or update your data |
| • | Trace_Srce/Dest.Log for ODBC tracing |
Number of Records to Read (SQL manual Query). 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. A setting of 0 (default) will speed up the process as NO records are loaded.
MsSQL Primary Keys. We recommend you select Clustered KEY, but you can also use NON Clustered Keys for your Primary Keys.
SQL: Nb. Records to read before executing the Insert Script. When your table gets very large it may be possible to exceed the memory available. Instead of trying to read all the records before inserting them (setting of 0), you can set number here and split that task into groups. Just enter 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. You can monitor your memory use at the bottom of the DMC screen. You'll notice DMC cycling through a number of Read/Insert/Cleanup events during the transfer. This can also prevent you from thinking the DMC has "hung" during the transfer because it provides more feedback.
SQL Normalization Settings. Here you will access a special screen to customize all the parameters for the Port to SQL function. Note: You can save/restore these settings to suit different needs.
Define any Owner Source Strings that you want DMC to use.
Define any Owner Destination Strings for DMC to use.
Define any Authentication Source Strings that you want DMC to use.
The FIRST line is for the setting to send to the server
The SECOND line is for the command to send to the server
Quotes are NOT required as DMC will add them for you.
SQL Authentication Destination Tab
Define any Authentication Source Strings that you want DMC to use.
Quotes are NOT required as DMC will add them for you.