{"id":2902,"date":"2022-04-15T08:00:34","date_gmt":"2022-04-14T23:00:34","guid":{"rendered":"https:\/\/www.oqiita.com\/?p=2902"},"modified":"2022-04-15T08:00:34","modified_gmt":"2022-04-14T23:00:34","slug":"%e3%80%90sqlserver%e3%80%91bacpac","status":"publish","type":"post","link":"https:\/\/www.oqiita.com\/?p=2902","title":{"rendered":"\u3010SQLServer\u3011bacpac"},"content":{"rendered":"<p>\u4f7f\u3046\u6a5f\u4f1a\u304c\u3042\u3063\u305f\u306e\u3067\u30e1\u30e2<\/p>\n<p><!--more--><\/p>\n<p>bacpac\u3068\u306f\uff1f<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/azure\/azure-sql\/database\/database-export#:~:text=BACPAC%20%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AF%E3%80%81%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AE,%E3%82%92%E6%8C%81%E3%81%A4%20ZIP%20%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%A7%E3%81%99%E3%80%82\" rel=\"noopener\" target=\"_blank\">BACPAC \u30d5\u30a1\u30a4\u30eb\u3078\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/a><\/p>\n<pre>BACPAC \u30d5\u30a1\u30a4\u30eb\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u3068\u30c7\u30fc\u30bf\u3092\u542b\u3080 BACPAC \u306e\u62e1\u5f35\u5b50\u3092\u6301\u3064 ZIP \u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002<\/pre>\n<p>\u30fb\u30fb\u30fb\u30fb\u3060\u305d\u3046\u3067\u3059\u3002<\/p>\n<p>SQL Server Management Studio \u304b\u3089\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3001\u30a4\u30f3\u30dd\u30fc\u30c8\u304c\u53ef\u80fd\u3002<\/p>\n<h3 id=\"i-0\">\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/h3>\n<p>SQL Server Management Studio \u3067\u3001\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305f\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001<br \/>\n\u30e1\u30cb\u30e5\u30fc\u304b\u3089 [\u30bf\u30b9\u30af] &gt; [\u30c7\u30fc\u30bf\u5c64\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8] \u3092\u9078\u629e\u3002<br \/>\n\u65b0\u3057\u3044\u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u4fdd\u5b58\u5148\u3092\u9069\u5f53\u306b\u8a2d\u5b9a\u3057\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308c\u3070\u5b8c\u4e86\u3002<br \/>\n<a href=\"https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac001-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac001-1-300x242.png\" alt=\"\" width=\"300\" height=\"242\" class=\"alignnone size-medium wp-image-2909\" srcset=\"https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac001-1-300x242.png 300w, https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac001-1-1024x826.png 1024w, https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac001-1-768x620.png 768w, https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac001-1-940x758.png 940w, https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac001-1.png 1061w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\"><\/a><\/p>\n<h3 id=\"i-1\">\u30a4\u30f3\u30dd\u30fc\u30c8<\/h3>\n<p>SQL Server Management Studio \u3067 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057 [\u30c7\u30fc\u30bf\u5c64\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30a4\u30f3\u30dd\u30fc\u30c8] \u3092\u9078\u629e\u3002<br \/>\nbacpac\u3092\u9078\u629e\u3057\u3066\u3001\u9069\u5f53\u306b\u6b21\u3078\u30dc\u30bf\u30f3\u9023\u6253\u3067\u5b8c\u4e86\u3002<br \/>\n<a href=\"https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac004.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac004-300x219.png\" alt=\"\" width=\"300\" height=\"219\" class=\"alignnone size-medium wp-image-2908\" srcset=\"https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac004-300x219.png 300w, https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/bacpac004.png 520w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\"><\/a><\/p>\n<p>\u30c7\u30fc\u30bf\u3068\u304bDB\u69cb\u9020\u3092\u914d\u5e03\u3059\u308b\u306e\u306b\u4fbf\u5229\u3060\u306d\uff08\u68d2\uff09<\/p>\n<p>\u4ee5\u4e0a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4f7f\u3046\u6a5f\u4f1a\u304c\u3042\u3063\u305f\u306e\u3067\u30e1\u30e2<\/p>\n","protected":false},"author":1,"featured_media":2904,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[90],"tags":[39],"class_list":{"0":"post-2902","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-db","8":"tag-sqlserver","9":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.oqiita.com\/wp-content\/uploads\/2022\/04\/sango_sqlserver_icatch.png","jetpack_shortlink":"https:\/\/wp.me\/p8QluP-KO","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/2902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2902"}],"version-history":[{"count":5,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/2902\/revisions"}],"predecessor-version":[{"id":2913,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/2902\/revisions\/2913"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/media\/2904"}],"wp:attachment":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}