> For the complete documentation index, see [llms.txt](https://learn.capstorm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.capstorm.com/frequently-asked-questions/how-does-copystorm-work/how-to-compare-metadata-from-two-backups.md).

# How to Compare Metadata From Two Backups

Since CopyStorm keeps a copy of Salesforce metadata in local database tables it is a fairly trivial task to compare metadata from multiple CopyStorm backups.

## Problem 1: Compare Table and Field definitions from Two Backups

The key CopyStorm tables required to perform table and field comparisons are *CopyForceTable* and *CopyForceTableField*. These are the tables CopyStorm uses to keep the CopyStorm database structure in sync with Salesforce. Rather than bore you with details, download the following SQL script for an example of how to exhaustively search for table and field differences.

* [Search for Table and Field Differences Script](http://download.capstorm.com/learn/CopyStorm/FindTableAndFieldDifferences.sql).

## Problem: Compare Salesforce Metadata Objects from Two Backups

This solution compares elements like Apex Classes, Page Layouts, Settings, etc. from two difference CopyStorm backups. The key table in CopyStorm is *SFMetaFileProperties* since this table contains the most recently backed version of each metadata type. Note that the companion table, *SFMetaFilePropertiesHistory*, contains historical values for each metadata type. Download the following script for an example of how to exhaustively compare metadata.

* [Exhaustively Compare Metadata Objects Script.](http://download.capstorm.com/learn/CopyStorm/FindMetadataDifferences.sql)

## For Additional Help

* [Where Does CopyStorm Store Salesforce Metadata?](/frequently-asked-questions/how-does-copystorm-work/where-does-copystorm-keep-salesforce-metadata.md)
* [Does CopyStorm Backup Metadata?](/frequently-asked-questions/how-does-copystorm-work/does-copystorm-backup-meta-data.md)
* [Where Does CopyStorm Keep Past Revisions of Metadata?](/frequently-asked-questions/how-does-copystorm-work/where-does-copystorm-keep-past-revisions-of-salesforce-metadata.md)