SQL Data Transfer between databases

Question

0.00/5 (No votes)

See more:

I have two databases

I want to be able to transfer specific data from one to the other using C#, is there a easy way to transfer a selected record including all related data from one database to another database that has the exact same table schema.

Please keep in mind this also has to pull the relational data ,

I know about insert selects and most probably there's no out-of-box solution for this but has anyone came across a framework I can use ?

Posted 19-Sep-11 1:05am

L Viljoen

Updated 19-Sep-11 1:33am

v2

Add a Solution

3 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)

sachin10d · Answer 1 · 2011-09-19T01:22:00

Solution 1

Below query transfers all the data from employee table of testsource database
to employee table of testdestination database

SQL

insert into TestDestination.dbo.Employee 
select * from TestSource.dbo.Employee

for the specific data to transfer you will add where clause for the select as follows

SQL

insert into TestDestination.dbo.Employee 
select * from TestSource.dbo.Employee 
Where Id > 10 and Id < 20

Posted 19-Sep-11 1:22am

sachin10d

Updated 19-Sep-11 1:24am

v2

Comments

AditSheth 19-Sep-11 7:29am

If Id is Identity then it gives error

sachin10d 19-Sep-11 12:49pm

specify all the columns name comma separate and eliminate the Identity column
in both insert and select part

sachin10d 19-Sep-11 12:50pm

insert into TestDestination.dbo.Employee (Column1, Column2, ...)
select (Column1, Column2, ...) from TestSource.dbo.Employee
Where Id > 10 and Id < 20

member60 · Answer 2 · 2011-09-19T01:25:00

Solution 2

try the following :

INSERT INTO TargetDB.dbo.TargetTable (ColumnID, SomeColumn1, SomeColumn2)

SELECT ColumnID, SomeColumn1, SomeColumn2

FROM SourceTable

Posted 19-Sep-11 1:25am

member60

Muralikrishna8811 · Answer 3 · 2011-09-19T04:23:00

Hi,

You want to copy data from one table in DB1 to another table in DB2 .
we can do this by using sql command like...solution1

and another one is using c#.

like first retrieve data from one database and then insert that retrieced into another database.

If you clearly specify your table definitions I can easily solve your requirement.

I hope you understood what I said.