Possible Duplicate: Free Tool to compare Sql Server tables I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do t.
ApexSQLRedgate ®AzureStandardProfessionalStandardProSQL Server versionSQL Server 2005 - 2019SQL Server editionsExpressStandardEnterpriseCloudAmazon RDS for SQL ServerIntegrationVisual StudioInputsSQL Server database3 rd party backup and projectSource control project (changeset)MySQL databaseOutputsSource control project (changeset synchronization)Differential snapshotReports and exportsExport to a databaseExport to a SQL scriptComparisonCharacter level object differencesExamine differences using the summary viewImpact analysis e.g. Microsoft Great Plains is a database that has over 1,000 tables and 11,000 stored procedures and a large amount of other objects contained in SQL. I have looked at many different products to show the differences between the different versions of GP and ApexSQL, in my opinion was the fastest. Since their new changes to ApexSQL Diff they've even surpassed their own record in how long it takes to compare the databases. I validate this because I didn't do an accurate timing 2 years ago but I'm pretty sure the comparison has gone from 10-15 minutes down to less than a few minutes.
![Sql Sql](/uploads/1/2/5/3/125363974/573156295.png)
It's amazing how fast it really works!
SQLDBDiff is a powerful and intuitive tool that compares the schema and the data of SQL Server databases.