{"id":3366,"date":"2016-11-22T19:41:11","date_gmt":"2016-11-22T11:41:11","guid":{"rendered":"http:\/\/blog.hoyo.idv.tw\/?p=3366"},"modified":"2023-03-15T23:07:03","modified_gmt":"2023-03-15T15:07:03","slug":"%e5%be%9e%e9%81%a0%e7%ab%af%e7%9a%84-sql-server-%e8%a4%87%e8%a3%bd%e8%b3%87%e6%96%99%e5%ba%ab%e5%88%b0%e6%9c%ac%e5%9c%b0%e7%ab%af","status":"publish","type":"post","link":"https:\/\/blog.hoyo.idv.tw\/?p=3366","title":{"rendered":"\u5f9e\u9060\u7aef\u7684 SQL Server \u8907\u88fd\u8cc7\u6599\u5eab\u5230\u672c\u5730\u7aef"},"content":{"rendered":"<p>\u53c3\u8003<\/p>\n<ul>\n<li><a href=\"https:\/\/dotblogs.com.tw\/terrychuang\/2012\/07\/10\/73318\" target=\"_blank\" rel=\"noopener\">\u5f9e\u9060\u7aef\u9023\u63a5 SQL Server 2012\uff08\u542b Express \u7248\uff09 \u4e4b FAQ<\/a><\/li>\n<li><a href=\"https:\/\/msdn.microsoft.com\/zh-tw\/library\/ee210546.aspx\" target=\"_blank\" rel=\"noopener\">\u8cc7\u6599\u5c64\u61c9\u7528\u7a0b\u5f0f<\/a><\/li>\n<li><a href=\"http:\/\/stackoverflow.com\/questions\/28566610\/unable-to-import-sql-azure-v12-bacpac-type-microsoft-data-tools-schema-sql-sql\">Unable to import SQL Azure V12 BACPAC: \u201ctype Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid\u201d<\/a><\/li>\n<\/ul>\n<p>--<\/p>\n<h2>\u5834\u666f\u6558\u8ff0<\/h2>\n<p>\u4f7f\u7528 SQL Server 2014 Management Studio \u53ef\u4ee5\u5f9e\u9060\u7aef\u9023\u63a5\u8cc7\u6599\u5eab\uff0c\u672c\u5730\u7aef\u6709\u9632\u706b\u7246\u9650\u5236\u554f\u984c\uff0c\u6240\u4ee5\u7121\u6cd5\u4f7f\u7528\u532f\u51fa\u3001\u532f\u5165\u529f\u80fd\u3002<\/p>\n<p>\u56e0\u70ba\u53ea\u6709 SQL Server \u7684\u9023\u7dda\u6b0a\u9650\uff0c\u6240\u4ee5\u4f7f\u7528\u5099\u4efd\u7522\u751f\u7684 .bak \u6a94\u6848\u4e5f\u7121\u6cd5\u53d6\u5f97\uff0c\u6700\u5f8c\u662f\u7528\u300c\u731c\u300d\u7684\u4f7f\u7528\u300c<strong>\u532f\u51fa\u8cc7\u6599\u5c64\u61c9\u7528\u7a0b\u5f0f<\/strong>\u300d\u4f86\u53d6\u5f97\u4e0b\u8f09\u5230\u5b8c\u6574\u7684\u8cc7\u6599\u5eab\u3002<\/p>\n<p>\u53ef\u662f\u61c9\u8a72\u662f SQL Server \u7684\u7248\u672c\u554f\u984c\uff0c\u6240\u4ee5\u96d6\u7136\u53ef\u4ee5\u4f7f\u7528 2014 \u7684 Management Studio \u9023\u7dda\u53ca\u6b63\u5e38\u64cd\u4f5c\uff0c\u53ef\u662f\u5be6\u969b\u532f\u51fa\u5f8c\u7684 BACPAC \u6a94\u6848\u7121\u6cd5\u532f\u5165\u5230 SQL Server 2014<\/p>\n<p>\u5fc5\u9808\u4f7f\u7528 2016 Management Studio \u624d\u80fd\u532f\u5165\uff0cSQL Server \u9084\u662f 2014 \u4e0d\u9808\u5347\u7d1a<\/p>\n<p>--<\/p>\n<h2>\u64cd\u4f5c\u6d41\u7a0b<\/h2>\n<p>\u8cc7\u6599\u4f86\u6e90\u4e3b\u6a5f \u2192 <strong>\u4f86\u6e90\u8cc7\u6599\u5eab<\/strong>\u53f3\u9375 \u2192 \u532f\u51fa\u8cc7\u6599\u5c64\u61c9\u7528\u7a0b\u5f0f<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-medium wp-image-3428\" src=\"http:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-036-300x236.png\" alt=\"image-036\" width=\"300\" height=\"236\" srcset=\"https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-036-300x236.png 300w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-036-768x604.png 768w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-036-381x300.png 381w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-036.png 854w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>\u9084\u539f\u76ee\u6a19\u4e3b\u6a5f \u2192 \u300c<strong>\u8cc7\u6599\u5eab<\/strong>\u300d\u53f3\u9375 \u2192 \u532f\u5165\u8cc7\u6599\u5c64\u61c9\u7528\u7a0b\u5f0f<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-medium wp-image-3426\" src=\"http:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-037-300x236.png\" alt=\"image-037\" width=\"300\" height=\"236\" srcset=\"https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-037-300x236.png 300w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-037-768x605.png 768w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-037-381x300.png 381w, https:\/\/blog.hoyo.idv.tw\/wp-content\/uploads\/2016\/11\/Image-037.png 853w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>--<\/p>\n<h2>Windows 2012 R2 Server \u7684\u554f\u984c<\/h2>\n<p>\u5b89\u88dd SQL Server 2014 Express \u4e26\u4e0d\u6703\u6709\u554f\u984c\uff0c\u554f\u984c\u51fa\u5728\u5b89\u88dd 2016 Management Studio \u4e0a<\/p>\n<p>2016 Management Studio \u4f9d\u8cf4\u00a0KB2919355 \uff0c\u800c\u5b89\u88dd\u00a0KB2919355 \u4e4b\u524d<strong>\u5fc5\u9808\u5148\u5b89\u88dd KB2919442<\/strong> \u624d\u884c<\/p>\n<p>--<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"3366\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;4,382&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u53c3\u8003 \u5f9e\u9060\u7aef\u9023\u63a5 SQL Se...<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"3366\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;4,382&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[263],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/3366"}],"collection":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3366"}],"version-history":[{"count":8,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/3366\/revisions"}],"predecessor-version":[{"id":11815,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/3366\/revisions\/11815"}],"wp:attachment":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}