Menu
I would like to make the update of the web application as automated as possible.
I'm looking for a tool that can compare two instances of a database and generate an update script for me. As part of the build process create a instance of the last version of the database (ie currently in production) and compare that to what has been changed on the development version.
Any input is appreciated.
973
ApexSQL Compare offers integration for SSMS and Visual Studio, so you can right-click a SQL object in Object Explorer, select the Compare scripts in the right-click context menu, then Set as left/right, and the New comparison query window will be shown.
To compare SQL databases using DacPacs, all we need to do is start SQL Compare, select the source and target script folders, and hit Compare now. After this we can pick and choose which changes we want to include in the synchronization script, just as we would do with any other compare task using SQL Compare.
I like SqlDbDiff. Way cheaper than RedGate's SQL Compare
58
I answered the same question here.
Best of luck! As you will see, I like the Red-Gate tools.
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
