{"id":2670,"date":"2012-10-10T04:59:00","date_gmt":"2012-10-10T02:59:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/"},"modified":"2012-10-10T04:59:00","modified_gmt":"2012-10-10T02:59:00","slug":"sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/","title":{"rendered":"SQL Server 2012: SQL Server Data Tools (SSDT) &#8211; Schema and Data Comparison"},"content":{"rendered":"<p>In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The &#8220;Schema and Data Comparison&#8221; feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude) included in VSTS.<\/p>\n<h3>What is SQL Server Data Tools?<\/h3>\n<p>These new tools replace BIDS (Business Intelligence Development Studio). But they are more than just relational database development tools.<\/p>\n<p>SQL Server Data Tools (SSDT), code-named Juneau, is based on the new Visual Studio 2010 and you can use it for all BI projects with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).<\/p>\n<h3>What are the new features?<\/h3>\n<p>First, as I said, this tool replaces BIDS.<\/p>\n<ul>\n<li><strong>Declarative Schema-Based Database Design<\/strong><br \/>\nOne of the main changes is the ability to perform a schema-based database design.<br \/>\nIt can automatically generate the scripts to deploy new database versions.<br \/>\nYou dont have to create a multitude of ALTER scripts &#8230; very nice!<\/li>\n<li><strong>T-SQL Editing and Debugging<\/strong><br \/>\nYou have the full T-SQL IntelliSense to run and debug your code like scripts, Stored Procedures and other database objects.<\/li>\n<li><strong>Development of SQLCLR Projects<\/strong><br \/>\nYou can create SQLCLR objects without Visual Studio. You can build, run and debug SQLCLR objects.<\/li>\n<li><strong>Support<\/strong><br \/>\nIt&#8217;s supported for SQL Server 2005 and later.<br \/>\nYou can develop SQL Azure database project.<\/li>\n<li><strong>Schema and Data Comparison<\/strong><br \/>\nYou can use it to find the differences between 2 versions of the same database.<br \/>\nThis just introduces my subject&#8230;<\/li>\n<\/ul>\n<h3>How to install SSDT?<\/h3>\n<p>SSDT can be installed either by the installation setup wizard\u00a0or using the command line:<\/p>\n<ul>\n<li>Setup Wizard<\/li>\n<\/ul>\n<p>In Feature Selection&gt;Shared Features, check SQL Server Data Tools.<\/p>\n<p><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><a class=\"easyblog-thumb-preview\" title=\"install2.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/install2.png\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png\" alt=\"\" \/><\/a><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li>Command Line<\/li>\n<\/ul>\n<p><samp><span class=\"hps\">Setup.exe <span class=\"hps\">\/<span class=\"hps\">q <span class=\"hps\">\/<span class=\"hps\">ACTION=<span class=\"hps\">Install \/<span class=\"hps\">FEATURES=<span class=\"hps\">BIDS <span class=\"hps\">\/<span class=\"hps\">IACCEPTSQLSERVERLICENSETERMS<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/samp><\/p>\n<p>It&#8217;s funny\u00a0to see that the command line installation\u00a0uses BIDS, the old application&#8217;s name&#8230;:roll:<\/p>\n<h3>How to run it?<\/h3>\n<p>Go to Start Button and in the menu Microsoft SQL Server 2012, click on SQL Server Data Tools.<\/p>\n<p><strong><a class=\"easyblog-thumb-preview\" title=\"Demarrer.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Demarrer.png\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Demarrer.png\" alt=\"\" \/><\/a><\/strong><\/p>\n<p>And\u2026 alas! No SQL menu\u2026<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDTNoSQL.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTNoSQL.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTNoSQL.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Ok, it\u2019s just a mistake and the menu comes when I create an SQL Server project\u2026<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDTNoSQL2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTNoSQL2.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTNoSQL2.jpg\" alt=\"\" \/><\/a><\/p>\n<p><span class=\"hps\"><a class=\"easyblog-thumb-preview\" title=\"SSDTNoSQL3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTNoSQL3.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTNoSQL3.jpg\" alt=\"\" \/><\/a><\/span><\/p>\n<p>Now, I&#8217;m suddenly forwarded to a web page to download SSDT!<\/p>\n<p><span class=\"hps\"><a class=\"easyblog-thumb-preview\" title=\"parameter.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/parameter.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_parameter.jpg\" alt=\"\" \/><\/a><\/span><\/p>\n<p>I was surprised, because I have\u00a0already installed it with the SQL Server setup\u2026;-)<\/p>\n<p>In fact, SSDT in SQL Server Setup allows you to create SSIS, SSAS and SSRS Project. But in order to compare databases you must download SSDT.exe from Microsoft web site <a href=\"http:\/\/msdn.microsoft.com\/en-us\/data\/hh297027\">here<\/a>.<\/p>\n<h3>How to compare 2 schemas?<\/h3>\n<p>Run the downloaded SSDT.exe and restart SQL Server Data Tools<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDT1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT1.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT1.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Now, we have this SQL menu, click it and select Schema Compare &gt; New Schema Comparison<\/p>\n<p><strong><a class=\"easyblog-thumb-preview\" title=\"SSDT2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT2.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT2.jpg\" alt=\"\" \/><\/a><\/strong><\/p>\n<p>A new project SqlShemaCompare1 is created and the first step is to select source and destination databases to be compared.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDT3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT3.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT3.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Don\u2019t forget to click on the Test Connection button to ensure that your connection works.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDT4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT4.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT4.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Before you start a comparison, you can look and choose your options to customize the comparison<\/p>\n<p style=\"text-align: center\"><a class=\"easyblog-thumb-preview\" title=\"SSDT6.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT6.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT6.jpg\" alt=\"\" \/><\/a><\/p>\n<p style=\"text-align: center\"><a class=\"easyblog-thumb-preview\" title=\"SSDT7.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT7.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT7.jpg\" alt=\"\" \/><\/a><\/p>\n<p>For further information about options, click <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/aa833438(v=vs.100).aspx\">here<\/a>.<br \/>\nThen click\u00a0Compare and wait.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDT8.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT8.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT8.jpg\" alt=\"\" \/><\/a><\/p>\n<p>In my demo, between AW2012_data1 and AW2012_data2, I just have changed the schema HumanRessources to HR as you can see in this script for AW2012_data2<\/p>\n<p style=\"text-align: center\"><a class=\"easyblog-thumb-preview\" title=\"changeSchema.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/changeSchema.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_changeSchema.jpg\" alt=\"\" \/><\/a><\/p>\n<h3>The results?<\/h3>\n<p>Three types of actions appear:<\/p>\n<ul>\n<li>Delete<\/li>\n<li>Change<\/li>\n<li>Add<\/li>\n<\/ul>\n<h3 style=\"text-align: center\"><a class=\"easyblog-thumb-preview\" title=\"SSDT9.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT9.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT9.jpg\" alt=\"\" \/><\/a><\/h3>\n<p>Click on each item to expand it and see the actions for the destination.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDT11.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDT11.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDT11.jpg\" alt=\"\" \/><\/a><br \/>\nYou can see the script in the object Definitions Tab.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDTAnalyse01.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTAnalyse01.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTAnalyse01.jpg\" alt=\"\" \/><\/a><\/p>\n<p>You can scroll the green bar to see the code, it&#8217;s fun :-D.<\/p>\n<p>To apply changes, we have 2 choices:<\/p>\n<ul>\n<li>Applying updates directly<\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDTAnalyse05.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTAnalyse05.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTAnalyse05.jpg\" alt=\"\" \/><\/a><\/p>\n<ul>\n<li>Or indirectly, with a magic button <a title=\"SSDTAnalyse02.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTAnalyse02.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTAnalyse02.jpg\" alt=\"\" \/><\/a><\/li>\n<\/ul>\n<h3 style=\"text-align: center\"><a class=\"easyblog-thumb-preview\" title=\"SSDTAnalyse03.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTAnalyse03.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTAnalyse03.jpg\" alt=\"\" \/><\/a><\/h3>\n<p>Click on Excute.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDTAnalyse04.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTAnalyse04.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTAnalyse04.jpg\" alt=\"\" \/><\/a>And an error occurs&#8230;.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDTAnalyse06.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTAnalyse06.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTAnalyse06.jpg\" alt=\"\" \/><\/a><br \/>\nBut why???<br \/>\nThis is easy, in options, the checkbox Block on possible data loss is selected.<strong><br \/>\n<\/strong><\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"SSDTAnalyse07.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/SSDTAnalyse07.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_SSDTAnalyse07.jpg\" alt=\"\" \/><\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>I found that these tools are very easy and professional to use, with a lot of good options.<br \/>\nIt can be useful for DBA or\/and developers before upgrading a version of a software and its database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The &#8220;Schema and Data Comparison&#8221; feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude) included in VSTS. What is SQL Server Data Tools? These new tools replace BIDS (Business [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":2671,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[262,263,49,54],"type_dbi":[],"class_list":["post-2670","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-analysis-services","tag-integration-services","tag-microsoft","tag-sql-server-2012"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2012: SQL Server Data Tools (SSDT) - Schema and Data Comparison - dbi Blog<\/title>\n<meta name=\"description\" content=\"SQL Server Data Tools, code-named Juneau, is based on the new Visual Studio 2010 and you can use it for all BI projects with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). A new feature is &quot;Schema and Data Comparison&quot;. You can use it to find the differences between 2 versions of the same database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012: SQL Server Data Tools (SSDT) - Schema and Data Comparison\" \/>\n<meta property=\"og:description\" content=\"SQL Server Data Tools, code-named Juneau, is based on the new Visual Studio 2010 and you can use it for all BI projects with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). A new feature is &quot;Schema and Data Comparison&quot;. You can use it to find the differences between 2 versions of the same database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-10T02:59:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"394\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2012: SQL Server Data Tools (SSDT) &#8211; Schema and Data Comparison\",\"datePublished\":\"2012-10-10T02:59:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/\"},\"wordCount\":665,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png\",\"keywords\":[\"Analysis services\",\"Integration services\",\"Microsoft\",\"SQL Server 2012\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/\",\"name\":\"SQL Server 2012: SQL Server Data Tools (SSDT) - Schema and Data Comparison - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png\",\"datePublished\":\"2012-10-10T02:59:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"SQL Server Data Tools, code-named Juneau, is based on the new Visual Studio 2010 and you can use it for all BI projects with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). A new feature is \\\"Schema and Data Comparison\\\". You can use it to find the differences between 2 versions of the same database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png\",\"width\":394,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012: SQL Server Data Tools (SSDT) &#8211; Schema and Data Comparison\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012: SQL Server Data Tools (SSDT) - Schema and Data Comparison - dbi Blog","description":"SQL Server Data Tools, code-named Juneau, is based on the new Visual Studio 2010 and you can use it for all BI projects with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). A new feature is \"Schema and Data Comparison\". You can use it to find the differences between 2 versions of the same database.","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:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012: SQL Server Data Tools (SSDT) - Schema and Data Comparison","og_description":"SQL Server Data Tools, code-named Juneau, is based on the new Visual Studio 2010 and you can use it for all BI projects with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). A new feature is \"Schema and Data Comparison\". You can use it to find the differences between 2 versions of the same database.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/","og_site_name":"dbi Blog","article_published_time":"2012-10-10T02:59:00+00:00","og_image":[{"width":394,"height":400,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2012: SQL Server Data Tools (SSDT) &#8211; Schema and Data Comparison","datePublished":"2012-10-10T02:59:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/"},"wordCount":665,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png","keywords":["Analysis services","Integration services","Microsoft","SQL Server 2012"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/","name":"SQL Server 2012: SQL Server Data Tools (SSDT) - Schema and Data Comparison - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png","datePublished":"2012-10-10T02:59:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"SQL Server Data Tools, code-named Juneau, is based on the new Visual Studio 2010 and you can use it for all BI projects with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). A new feature is \"Schema and Data Comparison\". You can use it to find the differences between 2 versions of the same database.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_install2.png","width":394,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012: SQL Server Data Tools (SSDT) &#8211; Schema and Data Comparison"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2670"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2670\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2671"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2670"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}