What is meant by schema capture?
When we talk about capturing schema, we mean to “capture” all meta-data describing the schema objects. This meta-data is read from the database server’s catalogs. This captured meta-data is considered to be a snapshot of the schema structures at the point in time when the capture was performed. These snapshots may be saved to files as XML and then later re-loaded. Snapshots are simply meta-data.
When we talk about capturing schema, we mean to “capture” all meta-data describing the schema objects. This meta-data is read from the database server’s catalogs. This captured meta-data is considered to be a snapshot of the schema structures at the point in time when the capture was performed. Thus, snapshots are simply meta-data. These snapshots may be saved as files and then later re-loaded to be used in comparisons, etc. All character data is stored as Unicode. When snapshots are saved as files the format is XML with a UTF-8 encoding.