EZ DB Loader Application Settings

Details
Category: EZ DB Loader Application

Please note, that EZ DB Loader has been replaced by another application called EZ DB-Sync Application. It is suggested that you replace any usage of EZ DB Loader with the new application as it will no longer be supported.

 

Settings Configuration

 

After the clickOnce installation is complete you will need to configure the Settings.  To access Settings go to >File, >Application Settings

Access

SQL

 

  • User: This is the Username you use to log into EZ-MES
  • PassKey: This is the Passkey that is generated within EZ-MES.  If you dont have one: Generate a New PassKey
  • Web Service URL: This is the URL used to access EZ-MES.  You will need to add the '/eazywebservice.asmx' at the end.  
  • Connection String: Server=50.19.151.124;Database=master; User ID=sa;Password=xxxxx;Trusted_Connection=False;Connect Timeout=600;Pooling=true;
    • This is dependant on the Target SQL Server
  • Scripts Path: Location of EZ DB Loader Scripts
  • Database Settings: You can choose if the Target Database will be Access or SQL
  • SQL
    • DB Name: This is the name of the Target Database
    • DB MDF Path: Enter the path only, to where you will be saving the SQL MDF File
    • DB LDF Path: Enter the path only, to where youwill be saving the SQL LDF FIle
  • Access
    • Access DB Path: Select the Path of the Access Database.
    • DB Name: This is the name of the Target Database
  • Write Batch Size: Currently read-only value of 1.  Write one record at a time.
  • Thread Loop: This loop is in milliseconds and writes any pending Target Records
  • Idle Thread Loop (min): After a completed Target sync is completed, this is how many minutes it will sleep before it checks for any changes again.

Log Settings

  • Zip Previous Log File: Will zip previous days log file.
  • Keep: Keeps this many days of log files
  • Debug mode: This is for admin debugging purposes.  Provides extra messages on processes going on.
  • Email Settings: Will email if application crashes

SOAP Call Time out and Retry Settings (# of retry before the App Stop)

  • TimeOut: will retry SOAP Connections after the Timeout setting if there are any available retries left.
  • Retry: Retries this amount of times before it will cease to retry.  0 is indefinite.

Use the Test Passkey button on the right side to verify your settings are configured correctly.  After the settings are completed successfully close this form.  You should not have to re-enter this for future uses.

 

File

  • Application Settings: See above
  • Open Log Folder: Opens the folder where log files are kept
  • Open Script Folder: Opens the Scripts folder where all JSON scripts are stored.  This is specified in the application settings
  • Reload JSON Script files: Reanalyzes and reloads changes in JSON Script files
  • Add uJob: Adds a uJob (unique number for sJob) for each table when SQL is used.  
  • Fix Database to match Script Files: Reanalyzes JSON files and alters database tables to match any changes in the JSON files (SQL Only).

 

Useful Links