如何将表（包含数据）从一台服务器复制到另一台服务器？ [英] How to copy a table (with the data) from one server to another?

问题描述

如何将表（包含数据）从一台服务器复制到另一台服务器（两台服务器位于不同的PC中）？基本上如果我可以将数据移动到插入命令形式的txt文件（如phpmyadmin的导入/导出），一切都会好的

How to copy a table (with the data) from one server to another (the two servers are in different PCs)? Basically if I could move the data to a txt file inthe form of the insert command (like the import/export of phpmyadmin) all would be ok

推荐答案

你想要吗？将SQL Server A中的表作为表传输到SQL Server B？或者您想将表的内容从SQL Server A导出到另一台PC？


- CK

Do you want to transfer the table in SQL Server A to SQL Server B as a table? Or you want to export the content of a table from SQL Server A to another PC?

-- CK

从SQL服务器A到SQL的表SQL服务器B位于不同的主机（这两个不以任何方式相关）（对于表格结构，我将表脚本编写为创建到以获取查询并在其他SQL中运行它 - 进行适当的修改 - 是表数据有什么相似之处？）

Tables from SQL sever A to SQL server B which is in different host (those two are not related in any way) (For the table sructure I script the table as "Create into" take the query and run it in the other SQL -with the appropriate modifications -is anything similar for the table data?)

您可以使用您的管理工作室并使用导入向导或通过链接服务器连接到其他SQL服务器并执行SELECT * INTO ...


- CK

You can use your management studio and use the Import wizard or connect to the other SQL server through linked server and do a SELECT * INTO...

-- CK

这篇关于如何将表（包含数据）从一台服务器复制到另一台服务器？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！