Sql Data Compare Script Servers

Full list of features

What can I compare and synchronize?	Standard	Pro
SQL Server 2005, 2008, 2012, 2014, 2016, SQL Azure, & SQL Server on Amazon RDS databases
Native, encrypted, & compressed SQL Server 2005, 2008, & 2012 backup files
SQL Server 2014 backup files
Redgate SQL Backup Pro files
Folders of SQL scripts (for source control)

Features	Standard	Pro
Compare and deploy changes to SQL Server database contents
Compare and synchronize data from within SSMS
Automatically create error-free synchronization scripts
Build sophisticated rules to selectively limit what to synchronize
Index view support so data differences are seen on both views and tables
Comparison on primary keys and unique indexes so you can define identical rows
Custom comparison keys to compare databases based on any field
Pivot-view difference navigation to display row data as columns
Comparison and synchronization of large databases
Create an audit trail by comparing backups
Backup target database before changes are migrated
Command line automation (If you're using the command line on a build server, youll need SQL Change Automation)
Fast table, column, or row level restore of damaged or missing data

Khalidhussain (9/24/2003)

I need to compare two databases (e.g. Development DB and Test DB) to make sure they are 100% identical. Is there a way to create a SQL view, which can do this job for me?

I want to compare following:

Table name in Development and Test databases

Table structure in Development and Test databases (including identity seed and identity increment in each table)

View name in Development and Test databases

View structure in Development and Test databases

Stored procedure name in Development and Test databases

Stored procedure structure in Development and Test databases

We have ‘system data’ tables they hold data, which we need in our VB6 system.

These tables can be identify as prefix ‘sysd’ and table name e.g. sysdStatus hold all possible statuses for a policy.

I need to compare those system data in Development and Test databases as well.

Thank you

I don't see anything where you talk about what you would do if they're different. It you want to make sure they are the same, snapshot one over the other.

Now, if you want to identify the differences, then you'll need something like SQL Compare and Data Compare from Redgate. Yes, you could write your own... it will cost you more to do that both in the form of errors and total hours/dolarrs spent than just buying the product which has been tested and tested and retested.

--Jeff Moden

RBAR is pronounced 'ree-bar' and is a 'Modenism' for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
'If you think its expensive to hire a professional to do the job, wait until you hire an amateur.'--Red Adair
'Change is inevitable... change for the better is not.'
When you put the right degree of spin on it, the number 3 8 is also a glyph that describes the nature of a DBAs job. 😉
Helpful Links:
How to post code problems