{"id":39301,"date":"2025-06-24T17:37:40","date_gmt":"2025-06-24T15:37:40","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=39301"},"modified":"2025-06-24T17:37:42","modified_gmt":"2025-06-24T15:37:42","slug":"sql-server-2025-local-sql-server-container-schema-compare-preview","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/","title":{"rendered":"SQL Server 2025: Local SQL Server Container – Schema compare preview"},"content":{"rendered":"\n

After my blog about \u201cSQL Server 2025: Local SQL Server Container without Docker Command<\/a>\u201d, I continue to play & test it.<\/p>\n\n\n\n

One new feature in preview is the \u201cschema compare<\/strong>\u201d in this last extension for Visual Code:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I like new feature and now let\u2019s go for a test! \ud83d\ude09<\/p>\n\n\n\n

I create 2 identically databases db1 & db2 with 2 tables and some data inside:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I do a select on both tables on both databases to see if everything is the same:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I run the \u201cschema compare<\/strong>\u201d to be sure I have everything is aligned:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I select the source \u201cdb1\u201d, select the target \u201cdb2\u201d and click on compare:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

After few seconds (due to my small databases), we have the result:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Good! No schema differences were found! It’s a good start…<\/p>\n\n\n\n

Now, I play and change a little bit the db1:<\/p>\n\n\n\n

    \n
  • On table t1:\n
      \n
    • Add a column c4<\/li>\n\n\n\n
    • Drop a column c1<\/li>\n\n\n\n
    • Change the data type of the column c2<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
        <\/ul>\n\n\n\n
          \n
        • Create a new schema test2<\/li>\n<\/ul>\n\n\n\n
            \n
          • Transfer the table t2 from schema dbo to scema test2<\/li>\n<\/ul>\n\n\n\n
              \n
            • Create a new table t3<\/li>\n<\/ul>\n\n\n\n
              \"\"<\/figure>\n\n\n\n

              I run again the schema compare…<\/p>\n\n\n\n

              This time, we have a result:<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              I have all my change but like other tools it will delete the table dbo.t2 and create a new one test2.t2. This is not really the same as a schema transfer…<\/p>\n\n\n\n

              Otherwise, we see the missing table dbo.t2<\/p>\n\n\n\n

              I will now run the compare in the other way db2 as source and db1 as target:<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              I see now the delete of what I change on db1, then it\u2019s good and fine except the schema transfer like usual…<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              I come back to my precedent comparison and this I use the \u201cSwitch Direction<\/strong>\u201d:<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              I test now the script generation<\/strong>:<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              Et voila, I have my change script:<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              It will be very nice to use for developers but as you see in my post, you need to be careful with your change (schema change for tables), control and test the script generated before do it on Production databases!<\/p>\n\n\n\n

              See you soon for the next test on my Local SQL Server Container! \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"

              After my blog about \u201cSQL Server 2025: Local SQL Server Container without Docker Command\u201d, I continue to play & test it. One new feature in preview is the \u201cschema compare\u201d in this last extension for Visual Code: I like new feature and now let\u2019s go for a test! \ud83d\ude09 I create 2 identically databases db1 […]<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368,1504,99,48],"tags":[49,51],"type_dbi":[2874],"class_list":["post-39301","post","type-post","status-publish","format-standard","hentry","category-development-performance","category-docker","category-sql-server","category-technology-survey","tag-microsoft","tag-sql-server","type-sql-server"],"acf":[],"yoast_head":"\nSQL Server 2025: Local SQL Server Container - Schema compare preview - dbi 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:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2025: Local SQL Server Container - Schema compare preview\" \/>\n<meta property=\"og:description\" content=\"After my blog about \u201cSQL Server 2025: Local SQL Server Container without Docker Command\u201d, I continue to play & test it. One new feature in preview is the \u201cschema compare\u201d in this last extension for Visual Code: I like new feature and now let\u2019s go for a test! \ud83d\ude09 I create 2 identically databases db1 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-24T15:37:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-24T15:37:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png\" \/>\n\t<meta property=\"og:image:width\" content=\"939\" \/>\n\t<meta property=\"og:image:height\" content=\"464\" \/>\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=\"5 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-2025-local-sql-server-container-schema-compare-preview\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2025: Local SQL Server Container – Schema compare preview\",\"datePublished\":\"2025-06-24T15:37:40+00:00\",\"dateModified\":\"2025-06-24T15:37:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/\"},\"wordCount\":360,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png\",\"keywords\":[\"Microsoft\",\"SQL Server\"],\"articleSection\":[\"Development & Performance\",\"Docker\",\"SQL Server\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/\",\"name\":\"SQL Server 2025: Local SQL Server Container - Schema compare preview - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png\",\"datePublished\":\"2025-06-24T15:37:40+00:00\",\"dateModified\":\"2025-06-24T15:37:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png\",\"width\":939,\"height\":464},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2025: Local SQL Server Container – Schema compare preview\"}]},{\"@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 & 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 2025: Local SQL Server Container - Schema compare preview - dbi 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:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2025: Local SQL Server Container - Schema compare preview","og_description":"After my blog about \u201cSQL Server 2025: Local SQL Server Container without Docker Command\u201d, I continue to play & test it. One new feature in preview is the \u201cschema compare\u201d in this last extension for Visual Code: I like new feature and now let\u2019s go for a test! \ud83d\ude09 I create 2 identically databases db1 […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/","og_site_name":"dbi Blog","article_published_time":"2025-06-24T15:37:40+00:00","article_modified_time":"2025-06-24T15:37:42+00:00","og_image":[{"width":939,"height":464,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2025: Local SQL Server Container – Schema compare preview","datePublished":"2025-06-24T15:37:40+00:00","dateModified":"2025-06-24T15:37:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/"},"wordCount":360,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png","keywords":["Microsoft","SQL Server"],"articleSection":["Development & Performance","Docker","SQL Server","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/","name":"SQL Server 2025: Local SQL Server Container - Schema compare preview - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png","datePublished":"2025-06-24T15:37:40+00:00","dateModified":"2025-06-24T15:37:42+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/06\/image-73.png","width":939,"height":464},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2025: Local SQL Server Container – Schema compare preview"}]},{"@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 & 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\/39301","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=39301"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39301\/revisions"}],"predecessor-version":[{"id":39319,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39301\/revisions\/39319"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=39301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=39301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=39301"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=39301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}