I have two difference database (Not Table) in SQL. and Now I want to connect/Transfer daily basis data from one database table to another database table. Please tell me How to connect and tranfer data using Visual Basic.

Interview Candidate
Oct 27th, 2006
2
2529

Showing Answers 1 - 2 of 2 Answers

Arun James

Nov 8th, 2006

You can use a single query to do it ...Use the ordinary INSERT INTO Table2 SELECT col1, col2 .. FROM Table1But only consideration should be done is the two different DataBases .. Suppose Say our application works on DB1 and the data to be inserted to DB2 and the Table to which the application inserts rows as Table1 and the table to which the row should be inserted in DB2 as table2, then the Following query .....INSERT INTO DB2.Dbo.Table2SELECT * FROM DB1.Dbo.Table1Use this in Trigger or execute this directly in Application