Click here to Skip to main content
15,868,306 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have a risk with a database application that I want to support data transfer process. I have many tables in sql database. I want to transfer data in all tables of sql database into another sql database in another computer. There is no link connected between these two computer. How can I do this? Have any service for transferring data? I want this process C# code. Can I develop this process programmatically? Please help me.


- Thank You!
Posted
Updated 15-May-14 23:39pm
v2
Comments
_Asif_ 16-May-14 3:40am    
Why can't you simply take backup from source database and restore to target database?

Hello Wyne,

You can achieve this using one of the following ways.

  • Use BCP utility
  • Use BULK INSERT
  • Use SSIS

For more information on these methods, please refer to this[^]TechNet article.

Regards,
 
Share this answer
 
suppose machine 1 and machine2

create link server of machine2 in machine1

so you can perform any quary using two database

How to Config Linked Servers in a Minute[^]
 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900