Improvement request for Export - 07/05/23 08:17 AM
Please, make some improvements for "Export results":
1. Add string parameter to ExportInit(), with value of table name of result set. Let it be the same value as in "Export results\SQL file", no matter if it is a join.
2. Add parameters to ExportData(): data type and format. Or formatted value. Because now it is not possible to determine type of value (number/date/timestamp or string). This will be enough only in first stage before ExportPrepare().
Or (harder way) improve the export engine (the one that use files in "Scripts" folder).
Add the ability to use templates for export data. Not only ordinary INSERT-s.
1. Add string parameter to ExportInit(), with value of table name of result set. Let it be the same value as in "Export results\SQL file", no matter if it is a join.
2. Add parameters to ExportData(): data type and format. Or formatted value. Because now it is not possible to determine type of value (number/date/timestamp or string). This will be enough only in first stage before ExportPrepare().
Or (harder way) improve the export engine (the one that use files in "Scripts" folder).
Code
ExportResultsToSQLFinalization.sql ExportResultsToSQLInitialization.sql ExportTablesFinalization.sql ExportTablesInitialization.sql ExportUserObjectsFinalization.sql ExportUserObjectsInitialization.sql