dbForge Schema Compare for SQL Server - Case Study
Learn how dbForge Schema Compare and Data Compare for SQL Server can assist you in
a challenging process of schema comparison and what benefits it can provide.
A widely-recognized retailer decided to refine its old-established customer management
system to increase sales by converting more
website visitors into customers. One of the solutions was to create accounts for
potential customers to offer a range of customized services.
The retailer's production database contains the Sales schema with the
Customers table holding a list of regular customers. The retailer uses a staging
database to add the Accounts table and a foreign key constraint to the Customers
table, which references the AccountID field of the Accounts table.
After applying the changes, the retailer tries to synchronize the production and
The synchronization fails as the foreign key of the Customers table
cannot be created, because the Accounts table was moved to the Sales
database without data. The retailer searches for a reliable tool to quickly
complete this task without any errors and efforts.
The study case is slightly simplified to illustrate how effectively the Devart tools address
a similar case.
See the script sample for details
The Devart company offers an efficient solution for such a case.
dbForge Schema Compare for SQL Server
and dbForge Data Compare for SQL Server
are specifically designed for non-trivial schema and data comparison and synchronization
tasks. These tools successfully accomplish the desired synchronization, much faster than the
schema synchronization the retailer performed with the other tool.
The retailer uses dbForge Schema Compare for SQL Server to compare the staging database
Sales_2 and the production database Sales_1. The feature-rich schema
comparison wizard helps to compare the selected schemas. The retailer uses the option "Ignore foreign
keys" during comparison and synchronization.
The comparison results showed that the Customers tables are identical in both schemas,
whereas the Accounts table exists only in the Sales_2 table.
After that, the retailer uses dbForge Data Compare for SQL Server to synchronize the data
in the compared tables. The convenient data comparison wizard allows to quickly select and compare the
required databases. Moreover, the retailer was delighted to find multiple essential
comparison options. After synchronization, the Accounts table was created in the Sales_1
The data comparison results are automatically grouped by type, which
significantly simplifies their analysis. The data synchronization wizard ensures
error-free and quick data synchronization while offering backup of the target database, as well as
other useful features to deliver the result the retailer needs.
Then, the retailer returns to the comparison results in dbForge Schema Compare
and once again compares the schemas, this time turning off the "Ignore foreign keys" option selected
for the first comparison. The foreign key differences are shown for the compared Customers tables.
dbForge Schema Compare and Data Compare help synchronize schemas and their data
keeping referential integrity.
dbForge Schema Compare and Data Compare successfully completed the
task and gave a number of benefits including:
Less time for comparison and synchronization
Better insight into schema and data comparison processes thanks to intuitive UIs
Safe synchronization with ability to backup a target database
A wide range of additional options to get a customized result
dbForge Compare Bundle for SQL Server
Devart made it more convenient for you and combined Data Compare for SQL Server and Schema Compare for SQL Server in
a single bundle. It will save you hours of work comparing and deploying SQL Server databases. What is more,
dbForge Compare Bundle for SQL Server offers a significant discount if compared with purchasing each tool separately!
Buy dbForge Compare Bundle for SQL Server now
and double your success!