January 20, 2011 at 1:57 pm
Hi,
One of our clients is using SQL Server 2005 and we (as vendors) are using SQL Server 2008. The client is not interested in migrating to SQL Server 2005 as of now and will probably migrate by end of 2011. However when the current development is moved to Production we would need to migrate massiave amounts of data from the client's SQL Server 2005 box to our SQL Server 2008 box.
However after production the delta records will need to be updated from SQL Server 2008 to the client's SQL Server 2005 every night. The client is hinting at using Flat Files to migrate the delta records. I would like to know if we can have the data replicated from SQL Server 2008 to SQL Server 2005. or can we use the new feature in SQL 2008 to use Change Data Capture.
Would Change Data Capture work for moving data from SQL Server 2008 to SQL Server 2005. Are there any better alternatives to move/replicate/migrate Delta records from 2008 to 2005.
Please help me resolve my doubts as we need to suggest some flow other than just Flat Files to the client.
Thanking in Advance.
Arvind
January 20, 2011 at 3:17 pm
Yes, you can replicate SQL Server 2008 to 2005. For an extensive overview on the compatibility of versions check out THIS ARTICLE.
Read the section titled "Supported Versions of SQL Server".
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply