{"id":1114,"date":"2005-11-17T20:11:00","date_gmt":"2005-11-18T01:11:00","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=1114"},"modified":"2005-11-17T20:11:00","modified_gmt":"2005-11-18T01:11:00","slug":"sql-server-comparison-tools","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/","title":{"rendered":"SQL Server comparison tools"},"content":{"rendered":"

“There are so many SQL server database and structure comparison tools; may I know which one is better?\u201d. Well this is one of the most frequent questions, asked in SQL Server communities,therefore I decided to clarify this based on my experience and the products I’ve used so far. <\/P>
\n

I mainly use Red Gate SQL Bundle developer edition <\/A>for all DB related tasks and mostly for keeping my DBs in sync as I move up from dev to test to pre-prod and finally production, that\u2019s why I prefer Red Gate myself. Doesn’t mean it’s “better”, I think that’s a personal subjective thing, but there are two more possibilities that I’m aware of:<\/P>
\n

1) Apex<\/A> <\/P>
\n

2) DB Ghost<\/A><\/P>
\n

When I first used Apex SQL Edit, I was under the impression that their products are NOT as polished as they should be; it hangs a lot when it comes to huge databases and it hugs the resources a lot, so for the sake of this article, I took their products out of my benchmarking task. I\u2019ve mucked around with DB Ghost a lot recently and I have found it to be extremely reliable and it provides additional capability beyond comparison e.g. a rock-solid process to upgrade your databases (same as Red Gate),but still believe that from a developer’s perspective Red-Gate dose a better job than all its competitors. Below is only a feature comparison on Red-Gate and DB Ghost’s most popular product.<\/P>
\n

SQL Bundle Developer Edition  (Red-Gate):<\/P>
\n


\n

SQL Compare and Synchronization<\/STRONG>:Yes
SQL Data Compare<\/STRONG>:Yes
DTS Compare<\/STRONG>: Yes (That’s really handy if you are using DTS as an ETL tool)
Build Database from Script<\/STRONG>:Yes
Scripter<\/STRONG>:Yes
Extra<\/STRONG>:SQL Toolkit (APIs and command line tools to programmatically compare database objects are all exposed to the clients)
Price<\/STRONG>: http:\/\/www.red-gate.com\/dynamic\/shoppingcart\/QuoteProductOption.aspx?Product=SQLBundleDeveloper<\/A><\/P><\/BLOCKQUOTE>
\n

DB Ghost Professional Edition\u2122<\/P>
\n


\n

SQL Compare and Synchronization<\/STRONG>: Yes
SQL Data Compare<\/STRONG>:Yes
DTS Compare<\/STRONG>:No
Build Database from Script<\/STRONG>:Yes
Scripter<\/STRONG>:Yes
Extra<\/STRONG>:Nothing
Price<\/STRONG>:http:\/\/www.innovartis.co.uk\/database_solution_Purchase.aspx<\/A>  <\/P><\/BLOCKQUOTE><\/p>\n","protected":false},"excerpt":{"rendered":"

“There are so many SQL server database and structure comparison tools; may I know which one is better?\u201d. Well this is one of the most frequent questions, asked in SQL Server communities,therefore I decided to clarify this based on my experience and the products I’ve used so far. I mainly use Red Gate SQL Bundle […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1114","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\nSQL Server comparison tools - Reza Alirezaei's Blog %<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reza Alirezaei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/11\\\/17\\\/sql-server-comparison-tools\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/11\\\/17\\\/sql-server-comparison-tools\\\/\"},\"author\":{\"name\":\"Reza Alirezaei\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"headline\":\"SQL Server comparison tools\",\"datePublished\":\"2005-11-18T01:11:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/11\\\/17\\\/sql-server-comparison-tools\\\/\"},\"wordCount\":359,\"commentCount\":0,\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/11\\\/17\\\/sql-server-comparison-tools\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/11\\\/17\\\/sql-server-comparison-tools\\\/\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/11\\\/17\\\/sql-server-comparison-tools\\\/\",\"name\":\"SQL Server comparison tools - Reza Alirezaei's Blog %\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\"},\"datePublished\":\"2005-11-18T01:11:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/11\\\/17\\\/sql-server-comparison-tools\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/\",\"name\":\"Reza Alirezaei's Blog\",\"description\":\"Blogging from the field!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\",\"name\":\"Reza Alirezaei\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"caption\":\"Reza Alirezaei\"},\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/author\\\/rezaa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server comparison tools - Reza Alirezaei's Blog %","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/","twitter_misc":{"Written by":"Reza Alirezaei","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/#article","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/"},"author":{"name":"Reza Alirezaei","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"headline":"SQL Server comparison tools","datePublished":"2005-11-18T01:11:00+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/"},"wordCount":359,"commentCount":0,"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/","url":"https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/","name":"SQL Server comparison tools - Reza Alirezaei's Blog %","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#website"},"datePublished":"2005-11-18T01:11:00+00:00","author":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.devhorizon.com\/reza\/2005\/11\/17\/sql-server-comparison-tools\/"]}]},{"@type":"WebSite","@id":"https:\/\/blogs.devhorizon.com\/reza\/#website","url":"https:\/\/blogs.devhorizon.com\/reza\/","name":"Reza Alirezaei's Blog","description":"Blogging from the field!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.devhorizon.com\/reza\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938","name":"Reza Alirezaei","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","caption":"Reza Alirezaei"},"url":"https:\/\/blogs.devhorizon.com\/reza\/author\/rezaa\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=1114"}],"version-history":[{"count":0,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1114\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=1114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=1114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=1114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}