|
|
As discussed briefly under Resources for Schema Comparison you can export a SQL Server database schema objects from a live SQL Server database at any point in time using DBChangeManager. Exporting a databases enables versioning/baselining the database schema at any point in time. Export database captures the database schema objects as standard SQL script files which also enables faster & offiline comparison subsequently. You can export all the database object definitions into a single SQL file or into multiple SQL Files (one per object).
The Exported Database SQL script
files can be used as a source for schema comparison using
DBChangeManager. SQL scripts generated could be compared with another
set of SQL Scripts or or
with a live database. You can also synchronize the SQL Script files
Read more on Exporting a Database
|
|