Common Schema Migration and Extraction Options

From DBArtisan

Go Up to Schema Extraction and Migration

When extracting or migrating schema, the wizards present a set of options that let you specify how the extraction or migration script is created. The following table describes these options.

Note: Depending on the DBMS you are working with, the types of objects you choose to migrate/extract, and the specific migration or extraction operation, not all options are available.

Task and Setting Description

Group Dependencies

If set to True, objects that are dependent on each other are placed together in the script. For example, Table A would be followed by all objects dependent on Table A. If set to False, all objects of the same type are extracted simultaneously.

Script

Depending on the DBMS you working with and the types of objects you selected, these options let you specify whether you want to include Create statements, Drop statements, System Privileges, Object Privileges, and If Not Exists statements in the script.

Script Owner

True/False whether to include the owner in the scripts.

Owner

Retain Owner/Change Owner.

Change Owner To

If you opted to change the owner, choose the new owner to use when scripting options from the drop-down list.

Copy Owner

Migration only. Lets you retain the owner in the extraction/migration.

Overwrite Existing

Migration only. Choose one of the following options:

  • Overwrite Existing. Objects are overwritten with no prompt. Objects on the target datasource are dropped before new objects are created.
  • Prompt Whether to Overwrite. The receives a prompt before the object is dropped and re-created. Note: This action occurs on an object-by-object basis.
  • Do Not Overwrite Existing. If the object exists on the target datasource, no attempts is made to recreate it on the target.
  • Ignore Overwrite. Default. DBArtisan attempts to create the migrated objects, without checking the existence on the target datasource.

Generate Script

Migration only. If set to FALSE, the generated DDL is executed on the target datasource. If set to TRUE, DBArtisan generates a script which could be used to migrate the schema at a later date.

Topics

Retrieved from "https://docwiki.embarcadero.com/DBArtisan/191/e/index.php?title=Common_Schema_Migration_and_Extraction_Options&oldid=7955"