Replication

• SQL_Surfer

  SSCrazy Eights

  Points: 8318

  More actions

  July 29, 2014 at 2:38 pm

  #288590

  I've a database that comprises of about 50 tables. Some have PKs and some don't. Source is 2005 and Target is 2012. I'm in need of keeping both dbs up and in synch. Change could happen in either DBs. What replication methodology should I use? Or what would be my best bet?

• Mike Good

  SSCertifiable

  Points: 7415

  More actions

  July 30, 2014 at 12:11 am

  #1733462

  If the 2012 target can be unreadable, then you can log-ship. That is process we used to migrate from SQL 2005 to SQL 2012, was very straightforward.

  If you need to be able to read from the SQL 2012 target, I think replication is not terrible alternative, but you'd need PK on every table.