Home » Topic » SQL Sever Database Sync

SQL Sever Database Sync

Stephen West ~ Modified: September 3rd, 2015 ~ ~ 1 Minute Reading

Home › Forums › SQL Sever Database Sync

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • September 3, 2015 at 10:16 am #558 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    What version Of SQL Server are you ruinning? If you are using 2008 think about using the MERGE command and SSIS to move data from your one server to the other. MERGE is a new feature and will allow you to insert, update and delete all in one command as long as you have good primary keys

    September 3, 2015 at 11:47 am #559 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    I found two options

      -backup/restore
      -transactional replication

    What do you choose?

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.