{"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:40","modified_gmt":"2025-06-24T15:37:40","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 &#8211; Schema compare preview"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">After my blog about \u201c<a href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-without-docker-command\/\">SQL Server 2025: Local SQL Server Container without Docker Command<\/a>\u201d, I continue to play &amp; test it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One new feature in preview is the \u201c<strong>schema compare<\/strong>\u201d in this last extension for Visual Code:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"464\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-73.png\" alt=\"\" class=\"wp-image-39302\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-73.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-73-300x148.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-73-768x380.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I like new feature and now let\u2019s go for a test! \ud83d\ude09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I create 2 identically databases db1 &amp; db2 with 2 tables and some data inside:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"934\" height=\"1024\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-74-934x1024.png\" alt=\"\" class=\"wp-image-39303\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-74-934x1024.png 934w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-74-273x300.png 273w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-74-768x842.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-74.png 939w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I do a select on both tables on both databases to see if everything is the same:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"636\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-75.png\" alt=\"\" class=\"wp-image-39304\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-75.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-75-300x203.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-75-768x520.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I run the \u201c<strong>schema compare<\/strong>\u201d to be sure I have everything is aligned:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"495\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-76.png\" alt=\"\" class=\"wp-image-39305\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-76.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-76-300x158.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-76-768x405.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I select the source \u201cdb1\u201d, select the target \u201cdb2\u201d and click on compare:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"472\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-77.png\" alt=\"\" class=\"wp-image-39306\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-77.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-77-300x151.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-77-768x386.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"363\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-78.png\" alt=\"\" class=\"wp-image-39307\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-78.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-78-300x116.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-78-768x297.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"306\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-79.png\" alt=\"\" class=\"wp-image-39308\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-79.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-79-300x98.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-79-768x250.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After few seconds (due to my small databases), we have the result:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"241\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-80.png\" alt=\"\" class=\"wp-image-39309\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-80.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-80-300x77.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-80-768x197.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Good! No schema differences were found! It&#8217;s a good start&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, I play and change a little bit the db1:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On table t1:\n<ul class=\"wp-block-list\">\n<li>Add a column c4<\/li>\n\n\n\n<li>Drop a column c1<\/li>\n\n\n\n<li>Change the data type of the column c2<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\"><\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a new schema test2<\/li>\n<\/ul>\n\n\n\n<ul class=\"nv-cv-m wp-block-list\">\n<li>Transfer the table t2 from schema dbo to scema test2<\/li>\n<\/ul>\n\n\n\n<ul class=\"nv-cv-m wp-block-list\">\n<li>Create a new table t3<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"605\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-81.png\" alt=\"\" class=\"wp-image-39310\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-81.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-81-300x193.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-81-768x495.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I run again the schema compare&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This time, we have a result:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"330\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-82.png\" alt=\"\" class=\"wp-image-39311\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-82.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-82-300x105.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-82-768x270.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">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&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Otherwise, we see the missing table dbo.t2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I will now run the compare in the other way db2 as source and db1 as target:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"213\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-83.png\" alt=\"\" class=\"wp-image-39312\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-83.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-83-300x68.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-83-768x174.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I see now the delete of what I change on db1, then it\u2019s good and fine except the schema transfer like usual&#8230;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"448\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-84.png\" alt=\"\" class=\"wp-image-39313\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-84.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-84-300x143.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-84-768x366.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I come back to my precedent comparison and this I use the \u201c<strong>Switch Direction<\/strong>\u201d:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"416\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-85.png\" alt=\"\" class=\"wp-image-39314\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-85.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-85-300x133.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-85-768x340.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I test now the <strong>script generation<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"484\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-86.png\" alt=\"\" class=\"wp-image-39315\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-86.png 938w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-86-300x155.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-86-768x396.png 768w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Et voila, I have my change script:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"581\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-87.png\" alt=\"\" class=\"wp-image-39316\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-87.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-87-300x186.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-87-768x475.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">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<p class=\"wp-block-paragraph\">See you soon for the next test on my Local SQL Server Container! \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After my blog about \u201cSQL Server 2025: Local SQL Server Container without Docker Command\u201d, I continue to play &amp; 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&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[1504,99],"tags":[49],"class_list":["post-39301","post","type-post","status-publish","format-standard","category-docker","category-sql-server","tag-microsoft"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2025: Local SQL Server Container - Schema compare preview - dbi services 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 &amp; 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&hellip;&nbsp;\" \/>\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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-24T15:37:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server 2025: Local SQL Server Container &#8211; Schema compare preview\",\"datePublished\":\"2025-06-24T15:37:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-local-sql-server-container-schema-compare-preview\\\/\"},\"wordCount\":360,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\\\/2025\\\/06\\\/image-73.png\",\"keywords\":[\"Microsoft\"],\"articleSection\":[\"Docker\",\"SQL Server\"],\"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 services 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\\\/2025\\\/06\\\/image-73.png\",\"datePublished\":\"2025-06-24T15:37:40+00:00\",\"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\\\/2025\\\/06\\\/image-73.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2025: Local SQL Server Container &#8211; Schema compare preview\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"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 services 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 &amp; 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&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2025-06-24T15:37:40+00:00","og_image":[{"width":939,"height":464,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/06\/image-73.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server 2025: Local SQL Server Container &#8211; Schema compare preview","datePublished":"2025-06-24T15:37:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-schema-compare-preview\/"},"wordCount":360,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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\/2025\/06\/image-73.png","keywords":["Microsoft"],"articleSection":["Docker","SQL Server"],"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 services 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\/2025\/06\/image-73.png","datePublished":"2025-06-24T15:37:40+00:00","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\/2025\/06\/image-73.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2025: Local SQL Server Container &#8211; Schema compare preview"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","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":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39301\/revisions"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}