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 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • September 2, 2015 at 12:48 pm #551 Score: 0
    Stephen West
    Moderator
    4 pts

    I have 2 sets of database one for Prod and other for reporting purpose

    1. marketing
    2. marketing_Report

    I want my reporting database (marketing_report) to be sync everynight with production (marketing) they both are on same server. I do not want to use replication. What is the best method to do. I want to automate this on daily basis.

    I can do backup and restore but is there any other way to do?

    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 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.