Best database compare tools

Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. It can compare and sync any databases, even very large ones.

Quick, easy, always delivers a correct result. Try it on your database and comment upon the product. We are using an inhouse developed solution that is basicly a procedure with arguments of what you want included in the comparision SP's, Full SP code, table structure, defaults, indices, triggers.. It is quite easily developed as well, then we just redirect output of procedure to textfiles and do text comparisions between the files.

I've used Red Gate's tools and they are superb. However, if you can't spend any money you could try Open DBDiff to compare schemas. It's the least good looking but the most talented db compare tool amongst the ones I've tried. It can compare both the structure and the data. It tells you which tables exist on one db but does not exist on the other, compares the structure and data of the common ones and it can produce the script to synchronize the two.

It's not free but has a 30 day trial as far as I can remember. I tried OpenDiff Tool. Great tool that is free and easy to use. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. What is best tool to compare two SQL Server databases schema and data? Asked 12 years, 9 months ago.

Active 1 year, 8 months ago. Viewed k times. Improve this question. Community Bot 1 1 1 silver badge. Tom Smykowski Tom Smykowski Also not a duplicate as the other question asks for just a table compare not a db — mmmmmm.

Can we get a tool to downvote the users who mark as duplicate without bothering to post the original links. At least give users opportunity to distinguish between their question, and existing questions.

This is the top ranked google search wrt Comparison tools. It has merit — Peter PitLock. Show 7 more comments. Active Oldest Votes. Improve this answer. Konstantin Tarkus Konstantin Tarkus I've had these sitting on my desktop for years and didn't even know it! Thanks for this tip. I also found that Visual Studio's Data and Schema comparison tool works better than Red-Gates's one it syncs schema more accurately — Konstantin Tarkus.

Missing data compare in VS? Update from Microsoft here: msdn. OrionEdwards this tool is availible in vs Professional as well. I have had Visual Studio crash on me multiple times while trying to use the built-in tools to sync data from our Prod database to the Test database. It works good for small batches, but when you try to sync the entire database RedGate's tool has worked perfectly for me, being able to handle the heavy lifting to sync the entire DB's data. Compare all database objects or selected ones only.

Compare database by all or selected properties of objects only. A wide variety of options for comparison. Compare databases using all or selected object properties. Advanced visual build tree interface for an intuitive visual representation of any differences. Built-in text differences control with SQL syntax highlighting.

Object types that are included in compare database process. Sponsored Links. DBComparer 3. Support DBComparer.