The EFT Database Utility is a command-line tool designed to manage and perform various database-related tasks for EFT. 

Key Capabilities

The database utility enables administrators to:

• Check database version status
• Generate SQL scripts for schema creation
• Perform database upgrades
• Analyse database prerequisites

System Requirements

Before using the utility, ensure you have:

• .NET Framework installed
• For Oracle databases: 32-bit data access components (ODAC)

Execution and Location

The utility (dbutility.exe) is typically located in the "dbutility" subdirectory within the program files folder. To run the tool, open a Windows command prompt and navigate to the appropriate directory.

Once in the correct directory, run the following command replacing the specific DB details: 

DBUtility.exe -action=UpgradePreview -dbtype=SQLServer -server=YOUR_DB_SERVER -database=YOUR_DB_NAME -username=YOUR_DB_USER -password=YOUR_DB_PASSWORD

Logging and Output

The utility provides flexible logging options:

• Default output displays errors and warnings
• Optional verbose mode for detailed logging
• Ability to specify log file using the "-logfile" parameter

Common Parameters

Key parameters include:

• -help: Display help documentation
• -action: Specify utility action (e.g., checkversion, createscript)
• -logfile: Define log file location
• -verbose: Enable detailed debug logging

Important Considerations

When using the utility:

• Ensure you have appropriate database credentials
• Use double quotes for parameter values containing spaces
• Check SQL script availability in database-specific subdirectories