Click here to Skip to main content
14,024,527 members
Rate this:
 
Please Sign up or sign in to vote.
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
Posted
Updated 2-Mar-13 2:18am
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

   
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

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


following is the link to create link server
http://msdn.microsoft.com/en-us/library/ms190479.aspx[^]


4. Transfer data or script between two SQL Server databases[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190419.4 | Last Updated 2 Mar 2013
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100