{"id":5045,"date":"2024-01-13T19:29:37","date_gmt":"2024-01-13T11:29:37","guid":{"rendered":"https:\/\/www.kenpai.com\/cms\/5045\/"},"modified":"2024-01-13T19:29:37","modified_gmt":"2024-01-13T11:29:37","slug":"sql-server2008%e6%96%b0%e5%bb%baodbc%e9%93%be%e6%8e%a5%e6%9c%8d%e5%8a%a1%e5%99%a8","status":"publish","type":"post","link":"https:\/\/www.kenpai.com\/cms\/5045\/","title":{"rendered":"SQL Server2008\u65b0\u5efaODBC\u94fe\u63a5\u670d\u52a1\u5668"},"content":{"rendered":"<\/p>\n<p>\u672c\u6587\u7684\u76ee\u7684\u662f\u5bfc\u51faMySQL\u5e93\u5230SQL Server\uff0c\u7531\u4e8e\u8fc7\u4e8e\u9ebb\u70e6\uff0c\u5efa\u8bae\u6709\u76f8\u540c\u76ee\u7684\u7684\u8bf7\u51fa\u95e8\u5de6\u8f6c\u627e&ldquo;Microsoft SQL Server Migration Assistant 2008 for MySQL&rdquo;\u6b64\u7269\u3002<\/p>\n<\/p>\n<p>\u8bfb\u6b64\u6587\u524d\uff0c\u5148\u8981\u5b66\u4f1a\u521b\u5efaODBC\u6570\u636e\u5e93\u3002<\/p>\n<p>1.\u6307\u7684\u662f<\/p>\n<\/p>\n<p>2.\u4e0a\u65b9\u7ea2\u6846\u586b\u5199\u8981\u521b\u5efa\u7684\u540d\u5b57\uff0c\u4e0b\u65b9\u7ea2\u6846\u586b\u5199\u6570\u636e\u6e90\u540d\uff0c&ldquo;\u4ea7\u54c1\u540d\u79f0&rdquo;\u7591\u4f3c\u53ef\u4ee5\u4efb\u610f\u586b\u5199<\/p>\n<\/p>\n<p>3.\u9009\u62e9\u5de6\u4e0a\u65b9&ldquo;\u5b89\u5168\u6027&rdquo;\uff0c\u8f93\u5165\u7528\u6237\u540d\u5bc6\u7801<\/p>\n<p>\u4e0d\u505a\u672c\u6b65\uff0c\u4f1a\u62a5\u8fdc\u7a0bIP\u9519\u8bef13\u548c126\u3002<\/p>\n<\/p>\n<p>4.\u590d\u5236\u94fe\u63a5\u670d\u52a1\u5668\u5e93\u5230SQL Server\u6570\u636e\u5e93\u3002<\/p>\n<\/p>\n<p>SELECT * INTO databasename.dbo.tablename FROM openquery(servername, \\\\\\&#8217;SELECT * FROM databasename.tablename\\\\\\&#8217;) \u4e0a\u65b9\u7684databasename\u548ctablename\u4e3aSQL Server\u7684\u5e93\u540d\u8868\u540d\uff0c\u5e93\u9700\u8981\u65b0\u5efa\uff1b<\/p>\n<\/p>\n<p>\u4e0b\u65b9\u7684databasename\u548ctablename\u4e3a\u94fe\u63a5\u670d\u52a1\u5668\u7684\u5e93\u540d\u548c\u8868\u540d\uff1b<\/p>\n<p>\u4e0b\u65b9\u7684servername\u4e3a\u94fe\u63a5\u670d\u52a1\u5668\u540d\u3002<\/p>\n<\/p>\n<p>\u672c\u65b9\u6cd5\u9700\u8981\u9010\u8868\u590d\u5236\uff0c\u5f88\u9ebb\u70e6<\/p>\n<\/p>\n<\/p>\n<p>\u66f4\u591a\u5173\u4e8e\u4e91\u670d\u52a1\u5668\uff0c<span class='wp_keywordlink'><a href=\"https:\/\/www.kenpai.com\/domain.html\" title=\"\u57df\u540d\u6ce8\u518c\" target=\"_blank\">\u57df\u540d<\/a><\/span>\u6ce8\u518c\uff0c\u865a\u62df\u4e3b\u673a\u7684\u95ee\u9898\uff0c\u8bf7\u8bbf\u95ee<span class='wp_keywordlink'><a href=\"https:\/\/www.kenpai.com\/\" title=\"\u57a6\u6d3e\u79d1\u6280\u5b98\u7f51\" target=\"_blank\">\u57a6\u6d3e\u79d1\u6280<\/a><\/span>\u5b98\u7f51\uff1a<span class='wp_keywordlink'><a href=\"https:\/\/www.kenpai.com\/\" title=\"\u57a6\u6d3e\u79d1\u6280\u5b98\u7f51\" target=\"_blank\">www.kenpai.com<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u7684\u76ee\u7684\u662f\u5bfc\u51faMySQL\u5e93\u5230SQL Server\uff0c\u7531\u4e8e\u8fc7\u4e8e\u9ebb\u70e6\uff0c\u5efa\u8bae\u6709\u76f8\u540c\u76ee\u7684\u7684\u8bf7\u51fa\u95e8\u5de6\u8f6c\u627e&ldquo;Microsoft SQL Server M<\/p>\n","protected":false},"author":2,"featured_media":4348,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3322],"tags":[3914],"class_list":["post-5045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ktougao","tag-sql-server2008odbc"],"_links":{"self":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/posts\/5045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/comments?post=5045"}],"version-history":[{"count":0,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/posts\/5045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/media\/4348"}],"wp:attachment":[{"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/media?parent=5045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/categories?post=5045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kenpai.com\/cms\/wp-json\/wp\/v2\/tags?post=5045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}