Releases · PNNL-Comp-Mass-Spec/DB-Schema-Export-Tool

11 Jul 00:42

Release 2.0.8957 Latest

Latest

Zip file DBSchemaExportTool_v2.0.8957.zip includes both the GUI and a console application.

Changes

Add option /ColumnFilter, which can be used to skip specific columns when exporting data from tables
Update /NameFilter to support a comma-separated list of filters
Add option /DisableStatementLogging which can be used to disable logging long-running data import statements
Add option /DeleteExtraRows , which will create file with commands to delete extra rows in database tables
- Use option /ForceTruncate to list tables that should be truncated prior to inserting new rows
Add option /DisableTriggers, which will disable triggers prior to importing data
Add options for customizing the Bash script created when /ScriptLoad is provided
- /ScriptUser
- /ScriptDB
- /ScriptHost
- /ScriptPort

Assets 3

27 Apr 22:29

Release 2.0.8152

Zip file DBSchemaExportTool_v2.0.8152.zip includes both the GUI and a console application.

Changes

Continue scripting objects if an error occurs scripting a single object
Show a warning message when trying to script an encrypted object (view, stored procedure, or user defined function)

Assets 3

08 Apr 00:29

Release 2.0.8132

Zip file DBSchemaExportTool_v2.0.8132.zip includes both the GUI and a console application.

Changes

When reading tab-delimited text files with column info, use header names to determine column order
Simplify the logic used to convert names from camelCase to snake_case
Remove trailing whitespace from schema files created by pg_dump

Assets 3