Synchronize Metadata Across SQL Server Database Copies

摘要

In addition to the standard development, test, quality assurance, and production versions, there can be copies of the database for implementations by divisions, departments, and development teams. [...] make a copy of MetadataExtractionQuery.sql and rename it so that the filename includes the database identifier. For each database, you can create a batch file that not only runs its customized query but also transports the query's results to a flat file on an FTP server.