Post reply

Transfer row from table in 1 database to table in another database

  • December 23, 2009 at 5:39 am

    #214986

    Hi All,

    I have two similar tables in 2 databases. 1 of them is on local machine and the other is on web.

    The web database is updated and I want to write a query that simply transfers the row from 1 table to another.

    The simple query would have been: "Insert into table 1 select * from table 2 where Condition=true"

    But In my case the two tables are present in two different database. These 2 databases are in differnet location. And I am using VB.NET application to access the database.

    Please help.

    Thanks

    Regards,

    Vaibhav

  • December 23, 2009 at 6:19 am

    #1095881

    Hi Vaibhav

    SQL Server Compact does not support things like linked servers. If your table doesn't contain too many rows, load them into a DataTable, set the rows as modified and use another DataAdapter to update your destination table. If you have too many rows, use a source DataReader and a Command to update your destination table.

    Greets

    Flo

  • December 23, 2009 at 10:50 am

    #1096046

    OK..

    thanks.. i will use a data reader then..

    thanks anyways..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply