A schema archive is a snapshot of the schema of a registered data source. You use a schema archive in schema comparisons against other data sources and archives. It is useful as a baseline to monitor data loss and inconsistencies when you move databases between testing and production environments.
Archive jobs are versioned. Older versions are retained within an archive.
Archive jobs are located in Data Source Explorer on the Schema Archive Jobs node of the corresponding data source.
The following tasks step you through creating a schema archive:
You create or modify a schema archive in the Configuration Archive Job editor. For more details about the editor, see Schema Archive Job Editor.
To create a new schema archive
To open an existing schema archive
The Job Name and Description pane shows where the job is stored in Project Explorer. When you click the Details button, you can see the project file directory path.
To describe and save a configuration archive job
The Schema Archive Source table specifies the data source from which the archive job is created.
To specify a schema archive job source
When you create a new schema archive, by default all schema properties are included. However, you may choose to archive only a specific group of properties. For example, you may want to define an archive that retains a subset of the properties. You can create multiple schema archives for the same data source.
Archive job properties are located on the Refinements tab of the Schema Archive Job Editor, where they are listed by object name, owner (if applicable to the database platform), and type.
To refine schema archive properties
Use the check boxes to select only the data source objects from which you want to create a schema archive.
Within the same archive, properties are retained across versions unless you specify new values.
Each time you create a new schema archive, DB Change Manager includes all properties of the specified data source and you must again refine the properties. |
The Options tab contains the Include Objects Options, DDL Extraction Options, and the Automatic Purge Options settings.
The Include Table Dependencies option includes table dependent objects in the results of the archive job.
You define whether DDL is extracted and stored in files during the archive process using the DDL Extraction Options. You can also obtain the DDL from the archive after the job runs.
These options include:
If you choose to store the DDL, you can find the directory location of the saved files on the History tab of the editor after archive versions are created.
To specify the DDL extraction process
The Automatic Purge Options delete archive files after a number of days, number of versions, and/or when the size of the files reaches a certain limit. The purge conditions are checked and enforced when an archive job is saved or when a new version is created.
To specify the conditions for automatically deleting archives
When a job completes, DB Change Manager provides various ways of notifying you. For more information, see Setting job notifications.
When you first run an archive job, DB Change Manager creates the first version of the archive. A version stores snapshots of the same archive job for backup or tracking comparison purposes. Versions are listed in the Archive Job History table on the History tab and in the Data Source Explorer.
To create a version and save a schema archive job
After you run a schema archive job, you can look at its contents and, if needed, modify the list of objects to be included in the job. A View Objects Summary report shows you what objects are selected and are included in the DDL Extract script.
To browse the contents of the archive
To modify the contents of the archive
To see a list of objects used in the Extract DDL script
To see the DDL
To edit the DDL
To extract the DDL of the archive contents to a file
You can compare two versions of an object and restore an object to a previous version.
To see the history of an archived object
To restore an archived object to its previous version
After running a schema archive job, you can create a job report using the View Report button on the Version tab. For more information, see Creating a job report.
You can use a schema archive in schema comparison job.
To add a schema archive to a schema comparison job
For more information, see Comparing schemas.
| | | | | | | |