Home » Blog » Reply » Reply To: SQL Sever Database Sync

Reply To: SQL Sever Database Sync

Andrew Jackson ~ Modified: September 3rd, 2015 ~ ~ 1 Minute Reading

Home Forums SQL Sever Database Sync Reply To: SQL Sever Database Sync

#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