Post reply

connecting local database to SQL server database on the server

  • April 13, 2011 at 10:26 am

    #389271

    I have a SQL Server database running on the server. I have a desktop application that needs to pull data out of the server database and push it to the local database. The desktop application then works with the local database and after getting some tasks done, we need to update the server database with the data in the local database.

    The scenario is similar to how a SQL Server CE database works with the webservice to pull and push data.

    Any ideas how I can egt this to work?

  • April 13, 2011 at 10:36 am

    #1311173

    it sounds like a job suited for Merge Replication, this will allow you to work locally and then push the changes back to the server when required.

  • April 13, 2011 at 10:39 am

    #1311181

    I don't have much experience with SQL Server except for writing procedures.

    How does merge replication work... would I be able to do it via code as I need to do the transfer of data from within the application.

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

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