Data Compare for SQL Server compares not only database backups, tables, views but also static data from local scripts folder
against a database of a source control project.
Data comparison setup
Include tables or views into comparison by mask or individually
Exclude objects from comparison by mask or individually
Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables)
Float types rounding option
Ignore Case and Ignore Trailing Spaces options for string comparison
LOB comparison options
WHERE filter for limiting data that needs to be compared (e.g. in extra large tables)
How can I compare data in two databases with different structures?
User mapping feature allows comparing tables with different names and column set
Map one table in source with two or more tables in target (useful when table was
Custom Query feature allows comparing a table with a query result
How can I analyze comparison results?
Filter and sort objects in results
View data differences for each pair of objects
Quickly navigate through data differences
Perform full-text search in data
View number of changes per column
Hide unmodified columns to simplify analysis
Select arbitrary columns for display
How can I export data comparison results?
Generate data comparison report in Excel and HTML formats
Include actual data into report
Report on selected objects only
Create accurate synchronization scripts
Migrate individual records, groups of records, or all data differences
Toggle synchronization direction to apply data changes to both databases
Rollback changes on error
Synchronize LOBs via files
Warnings on possible problems prior to synchronization
How can I automate my routine tasks?
Save comparison project settings for future use
Use command line interface for automatic routine synchronizations
Thank you for subscribing to our monthly digest!
Your subscription is now complete.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.