Click here to Skip to main content
15,389,430 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
How to get data from one server to another server database particular table in asp.net c#.
Posted
Updated 14-Nov-14 18:08pm
v2
Comments
   
Tomas Takac 15-Nov-14 2:32am
   
How would you imagine that to work? YOu press a button on a web page and the data is copied? You should definitely show us some of your code so we get a better idea of what you are trying to do. Use the "improve" button to edit your question.

1 solution

Hello Nirmal,

We can do it from sql,

INSERT INTO NEW_DB.NEW_TABLE VALUES(SELECT * FROM OLD_DB.OLD_TABLE)

Note: NEW_TABLE should not have primary key.
   
Comments
King Fisher 15-Nov-14 4:56am
   
Read the Question .Does he Ask for Database to Database ?
Senthil Sambandam 15-Nov-14 5:39am
   
yeah, he is not specific in its words. But in general the he speeks about database to database..
King Fisher 15-Nov-14 5:42am
   
he did " one server to another server database "

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