How to insert data from one server database table to other server database table using C#

Question

1.00/5 (1 vote)

See more:

How to insert data from one server database table to other server database table using c#

For example I have two SQL server A and B. I want to create one service which will insert data from one server dB to other server dB table. Please help me on this it's urgent.

What I have tried:

Two server A and B
.Data table a = data table B

Posted 23-May-18 7:24am

Member 12932251

Updated 23-May-18 10:38am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

RmcbainTheThird · Answer 1 · 2018-05-23T10:24:00

Solution 1

You need two data connections one for each db. Open the first and pull your data. close it and open the second connection and do your update

Posted 23-May-18 10:24am

RmcbainTheThird

Comments

Member 12932251 23-May-18 22:14pm

Can you share me c# code for get and update data.

RmcbainTheThird 24-May-18 11:49am

Sorry no, I spend enough time writing my own code and am not willing to do yours for free. If you are unsure how to get a connection string from your config file, open a database, query the database, build an insert query with the data from the first query then you need to pick up a book or hit Google to understand and utilize these concepts.

Maciej Los · Answer 2 · 2018-05-23T10:39:00

Solution 2

If it's an SQL Server...

You can use SqlBulkCopy Class (System.Data.SqlClient)[^]

For further details, please see: SQL Server Data Operations in ADO.NET | Microsoft Docs[^]

Posted 23-May-18 10:39am

Maciej Los