Data Sync between servers with different schema in SQL Server 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?
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 (http://technet.microsoft.com/en-us/library/ms143241(v=sql.105).aspx)

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.