Sometimes you will have created classification metadata which is applicable to multiple databases, commonly because they are the same schema in multiple environments, or because you are supporting a multi-tenancy scenario.

The script below will copy the classification metadata within the SQL Data Catalog application database so that it is reapplied to a second database.

Scenario: I have classified database 'AW Clone 2012' and wish to apply the metadata to another database, 'AW 2012 Clone number 2'.

Before running my script they look like this in SQL Data Catalog:

After running the script, I see that my metadata has been copied: