1.Not load whole SQL file before execute SQL now ,load the count of "Process SQL count" SQLs then execute them in database ,and continue load from SQL file until all SQL loaded and executed
2.Because of not load whole SQL ,modify the monitor logic , original logic is count SQL number, now is count string size of the SQL file
3.Add thread count options, user can set how many file be processed simultaneously in one database
4.Use can save error data to excel automaticlly when SQL file is being processed simultaneously(One excel file save one database info,and one sheet match one SQL file. Also can save error date when all processing is finished,but it store only 1000 failed sql on one SQL file.
6.User can select SQL file on different path
1.Select multiple database on navigator tree then select "Run SQL file"
2.Select SQL file and check "Auto save error detail to excel" option ,if want to add other databases , drag database from navigator tree ,right click SQL file or database table can delete SQL file or database, click "OK" button to start run SQL file
3.Check whether open processing monitor (one database matches one monitor part),and check whether the SQL file is being processing,when all execution is finished,check whether error data excel (if it has failed SQL) had been saved
4.Click "Export failed data" button to export error data