locked
Syncing two tables RRS feed

  • Question

  • I've created a .NET app that uses a very simple database with three tables.  It stores code snippets.  I want to use the app at home and also at contract office and want to be able to update at either place and then sync at least the one table with the data such that I have the same data at both the office and the home database table.

    I can write vb.net code to read and then insert to sync but wondered if there was a slicker way to do it in SQL Server that I don't know about....

    TIA

    Harry


    PS: SQL Server 2005
    • Edited by Mimosa Arts Thursday, January 5, 2012 9:44 PM
    Thursday, January 5, 2012 9:44 PM

Answers

  • Then use merge replication to sync data bi-directional

    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by Mimosa Arts Friday, January 6, 2012 9:26 PM
    Friday, January 6, 2012 3:36 PM

All replies

  • Do you have separate databases at home and office- best choice would be merge replications as your requred both databases active  and sync bi-directional which is not possible with db mirroring.
    http://uk.linkedin.com/in/ramjaddu
    • Edited by RamJaddu Friday, January 6, 2012 10:00 AM
    Friday, January 6, 2012 10:00 AM
  • They are named the same but on two seperate servers. 
    Friday, January 6, 2012 3:29 PM
  • Then use merge replication to sync data bi-directional

    http://uk.linkedin.com/in/ramjaddu
    • Marked as answer by Mimosa Arts Friday, January 6, 2012 9:26 PM
    Friday, January 6, 2012 3:36 PM
  • One database is an instance on my box at home and the other instance is behind a firewall here at work so i think replication would be hard to set up.

    Thanks

    Harry

    Friday, January 6, 2012 9:26 PM