如何将数据从本地表传输到在线服务器表 [英] 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屋！