Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two servers 2008 R2 and 2005. The e-commerce site has been running with 2005 Server. I have migrated 2005 server data with modified data schema to 2008 R2 from yesterday's date of data. My client wants to migrate the complete DB to 2005 R2 whenever he will gets the new site from developers but I need to update changes from 2005 to 2008 R2 with modified schema everyday.

How can I sync the data having different data schemas of different servers?

share|improve this question

closed as too broad by Jon Seigel, Mark Storey-Smith, RolandoMySQLDBA, Max Vernon, Michael - sqlbot Oct 23 '13 at 11:56

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 1 down vote accepted

It is not quite clear what you are asking. It seems you are looking for a solution that would replicate data changes as well as schema changes from the 2005 server to the 2008R2 server.

This can be achieved with SQL Server Replication. Transactional Replication is able to move all data changes as well as all schema changes from a single source system to one or more target systems. The systems do not need to be at the same version of sql server for this to work (

For an introduction to transactional replication check out my Replication Stairways article series.

If this does not answer your question, please try to clarify what you are looking for.

share|improve this answer
Thanq i will try it with Replication. – Gayathri L Oct 21 '13 at 9:43

Not the answer you're looking for? Browse other questions tagged or ask your own question.