|
Command Line Runtime Version |
|
|
DMC has a command line possibility and can be used as a Runtime version
Command line options are :
/P:X where X is the PROFILE ID /B:X where X is the PROJECT ID /S:0 or /S:1 where 0 means NOT SILENT and 1 means SILENT running
You also need to set in Settings / Setup the checkbox to Open or not the Tool at the end of a Silent process treatment
Examples :
If you need to have all the Profiles in SQL projects processed then use this command line argument x:\dmc.exe /B:1 /S:1 (this will run all Project ID 1 Profiles SILENTLY)
If you need to have the Profile ID # 2 processed then use this command line argument x:\dmc.exe /P:2 /S:0 (this will run Profile ID 2 Profiles NOT SILENTLY - IDE will open at the very begining and you can see all processing taking place)
where x:\ is YOUR long path to the DMC executable
When a command line process is finished then either the Interface will Open or not depending on your Settings
A log file is automatically done for all the different processes - you can find it in cgf_import sub directory under the Installation Directory - in a file called "dmclog.log" and you can open it in Notepad This is an example of a batch on 6 profiles done from a simple Project ID Number (same TPS source Table transferred to six different SQL's DB's) :
11:30:50 --> Start Data Transfer of Profile ID : 3 [1 / 6] 11:30:50 --> 11:30:51 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : Open Table OK 11:30:51 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : Load Data OK 11:30:52 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : List Columns OK 11:30:52 --> MySQL Destination Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) : Connection OK 11:30:52 --> MySQL Destination Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) : Open Table OK 11:30:53 --> Load Complete Data : Source (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) 11:30:53 --> Load Complete SQL Data : Destination (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) 11:30:53 --> Start Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) 11:31:16 --> Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL) ERROR : SQL Error: 90 - Error File System 42S22 - Unknown column 'CB_DATEEXP_TIME' in 'field list' 11:31:16 --> 11:31:16 --> MySQL Process interrupted before the end (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 11:31:16 --> 11:31:16 --> End Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 11:31:18 --> 11:31:18 --> Start Data Transfer of Profile ID : 10 [2 / 6] 11:31:18 --> 11:31:18 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : Open Table OK 11:31:18 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : Load Data OK 11:31:19 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : List Columns OK 11:31:19 --> SQL Destination Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) : Connection OK 11:31:19 --> SQL Destination Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) : Open Table OK 11:31:20 --> Load Complete Data : Source (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) 11:31:21 --> Load Complete SQL Data : Destination (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) 11:31:21 --> Start Export to SQL Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) 11:31:57 --> Export to SQL Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> Destination : SQL) 9081 Records Transfered 11:31:57 --> End Export to SQL Table (Profile : 10 [2 / 6] - PSCLIEN.TPS -> Destination : SQL) 11:31:59 --> 11:31:59 --> Start Data Transfer of Profile ID : 11 [3 / 6] 11:31:59 --> 11:31:59 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : Open Table OK 11:31:59 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : Load Data OK 11:32:00 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : List Columns OK 11:32:00 --> DB2 Destination Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) : Connection OK 11:32:00 --> DB2 Destination Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) : Open Table OK 11:32:01 --> Load Complete Data : Source (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) 11:32:02 --> Load Complete SQL Data : Destination (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) 11:32:02 --> Start Export to SQL Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) 11:32:57 --> Export to SQL Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> Destination : DB2) 9081 Records Transfered 11:32:57 --> End Export to SQL Table (Profile : 11 [3 / 6] - PSCLIEN.TPS -> Destination : DB2) 11:32:59 --> 11:32:59 --> Start Data Transfer of Profile ID : 6 [4 / 6] 11:32:59 --> 11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : Open Table OK 11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : Load Data OK 11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : List Columns OK 11:33:00 --> MySQL Destination Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) : Connection OK 11:33:01 --> MySQL Destination Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) : Open Table OK 11:33:02 --> Load Complete Data : Source (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) 11:33:02 --> Load Complete SQL Data : Destination (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) 11:33:03 --> Start Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) 11:33:40 --> Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 9081 Records Transfered 11:33:40 --> End Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 11:33:42 --> 11:33:42 --> Start Data Transfer of Profile ID : 7 [5 / 6] 11:33:42 --> 11:33:43 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : Open Table OK 11:33:43 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : Load Data OK 11:33:44 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : List Columns OK 11:33:44 --> Oracle Destination Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) : Connection OK 11:33:44 --> Oracle Destination Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) : Open Table OK 11:33:46 --> Load Complete Data : Source (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) 11:33:48 --> Load Complete SQL Data : Destination (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) 11:33:55 --> Start Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) 11:35:01 --> Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> Destination : Oracle) 9081 Records Transfered 11:35:01 --> End Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> Destination : Oracle) 11:35:03 --> 11:35:03 --> Start Data Transfer of Profile ID : 5 [6 / 6] 11:35:03 --> 11:35:04 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : Open Table OK 11:35:04 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : Load Data OK 11:35:05 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : List Columns OK 11:35:05 --> MySQL Destination Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) : Connection OK 11:35:05 --> MySQL Destination Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) : Open Table OK 11:35:07 --> Load Complete Data : Source (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) 11:35:08 --> Load Complete SQL Data : Destination (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) 11:35:14 --> Start Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) 11:36:12 --> Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 9081 Records Transfered 11:36:12 --> End Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 11:36:12 --> 11:36:12 --> End of all Processes
As you can see from this example any ERROR is logged and the process stops and returns automatically to the next one
When running in SILENT mode the only way to know where about the processes are is y moving the mouse OVER the SYSTEM TRAY icon : it displays the process number and details of Source and destination table Names
LICENSING : As you may need to distribute DMC to your clients so as to let them use this command line option, we have implemented this version in BOTH the Viewer and Enterprise versions. We have created specially for this case special bulk quantities licensing plans to allow you to have access to numerous licenses at a very interesting price Please consult the current pricing's from our Web Site
|