December 1, 2010 at 3:21 pm
Hi all,
We have a couple of critical databases currently running on a SQL server 2005 database. While we're planning on an in-place upgrade of this server from SQL 2005 to SQL 2008 R2 and leave the databases in SQL Server 2005 backward compatibility mode, we were told by the application owners that they would like to have those databases synchronized on a SQL Server 2005 environment as a fallback shelter in case application performance significantly degrades in the SQL 2008 R2 environment.
Since we don't anticipate database schema changes on the databases, data content in the table level would be the only thing that we need to sync. Will database replication or mirroring work between a publisher/source that's running backward compatibility mode 9 on SQL 2008 R2 and a subscriber/target that's running SQL Server 2005)? If both works, which would be a better choice?
Many thanks in advance.
Winnie
December 1, 2010 at 5:08 pm
Mirroring will not work from SQL 2008R2 to SQL 2005 and neither will log shipping. However, replication could be the solution for you since it will work with a 2008R2 publisher and a 2005 subscriber. The link below should get you started.
December 1, 2010 at 5:25 pm
I would agree on the replication note already left.
An alternative is to use an SSIS package to sync data on a daily basis or some other interval.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2010 at 8:52 am
Thanks a bunch. I appreciate it. I think replication is probably the best option for us. The foreign key constraints and all would make the SSIS implementation very troublesome.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply