EZDD_Admin > Upgrade Tables SQL

This option provides the capability to automatically generate SQL that can be used to move data from one database structure to another. The metadata for both database structures must be included in the EZDD database and the databases will show up in the lists of databases to be selected. The SQL will be generated to move the data from the specified Source Database to the specified Target database, and the SQL will be put into the destination location. The Generate SQL button will create the SQL.

 

The SQL generated for each table in the database looks something like this sample:
INSERT INTO .COLUMNS (
DATABASE_NUMBER
,TABLE_NAME
,COLUMN_NAME
,COLUMN_DEFINITION
,COLUMN_DERIVATION
,COLUMN_ORDER
,COLUMN_SIZE
,COLUMN_SYNONYM
,COLUMN_TYPE
,KEY_COLUMN
,LAST_UPDATED
,PROPOSED_COLUMN_NAME
,SOURCE_DATABASE_NUMBER
,SOURCE_COLUMN_NAME
,SOURCE_DATABASE_NAME
,SOURCE_TABLE_NAME
,UPDATE_FREQUENCY
,UPDATE_RESPONSIBILITY
,USER_DEFINED_DESCRIPTION
,USER_KEYWORD
,USER_NOTE
) Select
DATABASE_NUMBER,TABLE_NAME,COLUMN_NAME,COLUMN_DEFINITION,COLUMN_DERIVATION,COLUMN_ORDER,COLUMN_SIZE,COLUMN_SYNONYM,COLUMN_TYPE,KEY_COLUMN,LAST_UPDATED,PROPOSED_COLUMN_NAME,SOURCE_DATABASE_NUMBER,SOURCE_COLUMN_NAME,SOURCE_DATABASE_NAME,SOURCE_TABLE_NAME,UPDATE_FREQUENCY,UPDATE_RESPONSIBILITY,USER_DEFINED_DESCRIPTION,USER_KEYWORD,USER_NOTE
from .COLUMNS;
commit;