Database synchronization tools

Open source tool simplifies database synchronization for SQL Server
May 11, 2022 – 05:40 am
SQL Compare and Synchronization Tools

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

There has always been at least two copies - the public version and whatever iterations I've used privately for development and testing. Keeping the schemas for the two in sync was usually something I did by hand, if only because I was used to doing so. Old habits die very hard indeed.

I've since come across a tool that could help make this part of the job much less tedious. It's called OpenDBDiff, a free open source database schema synchronization tool for SQL Server that's hosted on Microsoft's CodePlex website. It is GPLv2 licensed, which means you can use it internally for whatever you want. You can also redistribute the unchanged version of it as you like, but any changes you make to a redistributed version have to be published. The program doesn't need to be formally installed; you can unpack the binaries and support files into any folder and run them from there.

OpenDBDiff works by comparing the schemas of any two databases, noting the differences, and generating a synchronization script. The two databases do not have to be hosted on the same instance of SQL Server or even reside on the same computer; if you can connect to the database over the network, then you can sync to or from it. Each conversion scenario can be saved as a project file and filtered by object type, compared with case sensitivity either on or off, and constrained with a number of other parameters. The generated change script can then be copied out and run at your leisure, so it's not possible to accidentally trash a database schema with this program.

Note that the documentation for the program is pretty skimpy—as in, there's barely any at all. It took some trial and error (and studying of screenshots) before I realized the Server Host field for the source and destination databases needs to be filled out in the format SERVERNAMEINSTANCENAME. In other words, if you have a computer named MYSERVER and a SQL Server instance named SQLEXPRESS, you'd use MYSERVERSQLEXPRESS to connect to it. For me, a more intelligent bit of user interface design would be to place the host and instance names in separate boxes.

Another version of the project also exists, dubbed sql-dbdiff. That one is GPLv3 licensed, and sports some extra capabilities. One example is a feature called Visual Diff that shows the changes between the create script for the old and new versions of a given object. This version of the program is also being developed a little more quickly, so it's probably the better of the two (even if it isn't the original).

Figure 1. OpenDBDiff in its sql-dbdiff variant (click to enlarge)

success antonym success auto sales success baby success clipart success doesn't come from what you do occasionally success image success images success in life success inspirational quotes for work success is counted sweetest success mindset success motivational quotes for work success overnight success positive affirmations success positive motivational quotes success quotes success quotes for men success realty success sharing home depot success sharing home depot success synonyms success thesaurus success through a positive mental attitude success wallpaper success words technaflora recipe for success tethered spinal cord surgery success rate the key success factors in an industry the key to success tarkov the national society of leadership and success reviews the seven spiritual laws of success there is no elevator to success tools for success was reconstruction a success what does a customer success manager do what is the success rate of a spinal cord stimulator attitude eagle quotes success bumble success stories dress for success denver foster care to success how do you spell success lake success, ny membrane sweep success rate misdiagnosed blighted ovum success stories opposite of success performance manager 4 success factors provera pregnancy success success good luck wishes success hunters success in latin success is no accident quotes the law of success celebrate success continuing success goal success quotes ivf success key to success in life magnet of success married at first sight success rate quotes about failure and success slug success success affirmations success credit union success interviews success quotes for business success rate of iui vitrectomy success rate what does a customer success manager do amazon onsite interview success rate ivf calculator success keto success motivate for success ralph waldo emmerson success stem cell transplant success rate study to success success books success companies success is not final, failure is not fatal: it is the courage to continue that counts. success mantra success pronunciation success quote success vision paducah ky the law of success weight watchers success stories achieves success animal mating success ankle ligament surgery success rate attitude eagle quotes success borat great success castor oil at 37 weeks success cdc ivf success rates center for academic success cerebral success class room for success crystal for success customer success metrics director of customer success salary dress for success locations near me equipped for reading success failure and success quotes geritol pregnancy success stories 2020 hotel dash suite success how do you define success interview question how i raised myself from failure to success in selling isaac success iui success stories 2020 ivf success rates by age 2020 ivf success stories john wooden success quote key to success lake success, new york late ovulation pregnancy success liver transplant success rate lumbar radiofrequency ablation success rate mantras for success march to success metformin weight loss success stories mindset the new psychology of success motivational quotes for students success motivational quotes for work success motivational speeches for success outliers the story of success p shot success rate pearson success net peloton success stories pillars of success positive quotes about success prayer for exam success prayer for success at work quotes for future success quotes success rowing machine weight loss success stories rowing machine weight loss success stories scentsy success secret to my success seven spiritual laws of success pdf skill success skill success success success academy middle schools success criterias success factor success meanings success motivation success nutrition facts success plan template success quotes for work success rice success rice out of the bag success thesaurus success vision express success vision topeka success vision topeka sweet success cucumber the 10x rule: the only difference between success and failure the 7 spiritual laws of success the secret of my success the secrets of lake success tips for success topamax and phentermine weight loss success stories 2020 tti success insights vaccine success vasectomy success rate weaning off cymbalta success stories what is success to you framing success plan for success student success center gcu student success completion grant success companies success driving school success is a journey not a destination
Related Posts