如何将数据从本地表传输到在线服务器表 [英] How to transfer data from local table to online server table
本文介绍了如何将数据从本地表传输到在线服务器表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
hi
I have database on my local sql and in one table around 80 rows are there.
I want to move table with all its row in my online server which is located on bigrock.
Is it possible??
or I have to insert data using insert Query for 80 times
How can I achieve it
推荐答案
你可以使用sql server import -export向导
http://msdn.microsoft .com / zh-CN / library / ms140052.aspx [ ^ ]
http:// msdn。 microsoft.com/en-us/library/ms141209.aspx [ ^ ]
You can use the sql server import -export wizard
http://msdn.microsoft.com/en-us/library/ms140052.aspx[^]
http://msdn.microsoft.com/en-us/library/ms141209.aspx[^]
您可以使用以下方法
1. bulkcopy
< a href =http://www.codeproject.com/Articles/16922/SQL-Bulk-Copy-with-C-Net>使用C#.Net 进行SQL批量复制[ ^ ]
使用SqlBulkCopy传输数据 [ ^ ]
2. http://msdn.microsoft.com/en-us/library/ ms141209.aspx [ ^ ]
3.你需要在SQL Server中设置为链接两个服务器然后
You can use following method''s
1. bulkcopy
SQL Bulk Copy with C#.Net[^]
Transferring Data Using SqlBulkCopy[^]
2. http://msdn.microsoft.com/en-us/library/ms141209.aspx[^]
3. you need to set up as Linked both Servers in SQL Server then
Insert Into Server1.Database1.dbo.Table1 (Col1, Col2)
Select Col1, Col2 From Server2.Database2.dbo.Table2
<下面是创建链接服务器的链接
http://msdn.microsoft.com/en-us/library/ms190479.aspx [ ^ ]
4. 传输数据或脚本在两个SQL Server数据库之间 [ ^ ]
这篇关于如何将数据从本地表传输到在线服务器表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文