Primary and Secondary database model

• jamesmario

  SSC Veteran

  Points: 254

  More actions

  May 2, 2013 at 1:54 pm

  #277071

  Our current application is running on asp.net and sql server 2008.

  Due to business decision, the application will be using a new database as of July 1st, basically it is a copy of the old database but no data restored from the previous database. However, the application may still need to contact the old database for few months.

  The one option would be setting up two different systems one will be pointing to the old and the other one will be pointing to the new db. So, we can flip the switch to the new db on July 1st. No issues.

  I am wondering, is there any feature in SQL server two DB can be used as primary (new DB) and secondary (old DB) model so our operations first goes to primary DB else secondary without changing any code in SP / application.