Page History
...
- Open the Version tab of the schema archive.
- In the Archive Contents list, right-click the object, and then select Extract DLL Scripts.
The Extract DLL Scripts window opens. For more information, see Extract DDL Scripts.
Review the History of Archived Objects
You can compare two versions of an object and restore an object to a previous version.
To see the history of an archived object
- In the Archive Contents list, right-click
...
- the object, and then select History.
The Object History window appears. - Select the two versions that you want to compare.
- Click Compare.
DB Change Manager compares the two and reports on the differences, if any.
To restore an archived object to its previous version
- In the Object History window, select
...
- the version you want to replace and the version with which you want to replace it.
- Click Restore.
The newer version
...
- is replaced by a copy of the older version.
Create a Job Report
After running a schema archive job, you can create a job report using the View Report button on the Version tab. See For more information, see Creating a Job Report for more informationjob report.
Use an Archive in Schema Comparison Jobs
You can use a schema archive in schema comparison job.
To add a schema archive to a schema comparison job
- In the Schema Comparison Job editor, drag and drop an archive version from Data Source Explorer to the Comparison Source or Comparison Target boxes.
- Alternatively, if a data source is selected as the source or target, select Use an Archive in the respective box, and then use the drop-down menu to choose an archive.
See Comparing Schemas for For more information, see Comparing schemas.