Omnidex SQL: EXTRACT DDL

The OdxSQL EXTRACT command will Extract DDL statements (CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE, CREATE INDEX and CREATE INDEX GROUP) from the currently connected Omnidex Environment to a file. The extracted file can then be modified with an editor and used to build another Omnidex Environment.

The EXTRACT command is particularly helpful in converting Omnidex Environments from previous versions that used the original Omnidex Environment Catalog syntax.

The EXTRACT command can also be used to generate INSERT, DELETE, and UPDATE statements from the existing data. This would typically be used in a testing environment.

EXTRACT DDL [FOR <ENVIRONMENT [environment] | DATABASE database>]
  [TO filespec] [ON [INSTANCE] instance] [WITH options]

EXTRACT [CLUSTERED] <INSERTS | UPDATES | DELETE_WHERES | DELETE_EXCEPTS>
  FROM tables [WHERE criteria] [TO filename]
  [ON [INSTANCE] instance] [WITH options]

If the TO filespec clause is omitted, then the file will be written to extract.sql in the current working directory.

The CLUSTERED option requires tables to be one parent table and any number of linked children.

connect myenv.xml;
extract ddl to myenvnew.sql;

extract ddl to myenv.sql with delete;