////Where Does CopyStorm Keep Past Revisions of Salesforce Metadata?
Where Does CopyStorm Keep Past Revisions of Salesforce Metadata? 2018-03-26T20:13:44+00:00

Where Does CopyStorm Keep Past Revisions of Salesforce Metadata?

When metadata backup is enabled for CopyStorm a table named SFMetaFileProperties will be created in the target database to hold metadata backups. In addition a table named SFMetaFilePropertiesHistory will be created to hold past revisions of metadata.

The columns in SFMetaFileProperties mimic the FileProperties data structure returned from the Salesforce Metadata API:

Column Description
id The ID of this metadata record — unlike other IDs in Salesforce it is not guaranteed to be non-null OR unique. In short, internal Salesforce objects violate the normal non-null uniqueness rule.
metatype The type of metadata in this record (e.g. CustomObject, ApexTrigger, etc…). Note that if a meta type is contained within another meta type (e.g. CustomField lives within CustomObject) then it will not have an entry in this table. The data will be contained in the parent record for the object.
fileName  The name of the file the metadata API requires for the record.
fullName The full API name of the record.
manageableState This field will contain “unmanaged” for types of metadata that can be redeployed.
namespacePrefix For installed packages this contains the name of the package’s namespace.
metaxml For records that require a companion “-meta.xml” this field contains the content.
content The raw base64 encoded data for this meta record.
body For records in UTF-8, contains the decoded value of the content column.
createdById ID of the user in Salesforce who created this metadata record. NOTE: this value may be null.
createdByName Name of the user in Salesforce who created this metadata record. NOTE: this value may be null.
createdDate Timestamp of when the record was created.
lastModifiedById ID of the user in Salesforce who last modified this metadata record. NOTE: this value may be null.
lastModifiedByName Name of the user in Salesforce who last modified this metadata record. NOTE: this value may be null.
lastModifiedDate Timestamp of when the record was last modified.

The companion table “SFMetaFilePropertiesHistory” has the same structure as SFMetaFileProperties but with two additional columns:

Column Description
historyDate Timestamp of when this history record was written. Older versions have older historyDate values.
version The history date represented as the number of milliseconds since 1-Jan-1970.

It is doubtful that you will want to access these tables directly. However, CopyStorm’s companion product, CopyStorm/Restore, uses these tables to provide a metadata report experience that can be performed with surgical accuracy.

CONTACTS

Product Questions: info@capstorm.com
Technical Support: support@capstorm.com
Phone: +1 314.403.2143