April 5, 2013 at 9:23 am
Greetings,
We are moving from our current sql server 2008 R2 to newer sql server 2008 R2.
We have about 10 databases and 1 of it is used for querying data for external customers. The external customers login and execute a procedure and read whatever data they want to copy . Every time it is done a record is added in the database for audit purposes.
As we move into newer server the external customers should be given time to point to the new DNS name of the sql server. During this time the 5 tables in the database should be in sync between the current and new sql server databases.
What is the right approach to keep the databases in sync (replication, mirrioring, etc.,). We use standard edition sql server 2008 R2 box on both the servers.
Thanks
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply