Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Preeti1
Starting Member
1 Post |
 Posted - 2009-09-10 : 07:12:53
|
| Hi,I am working on windows mobile application(c#) which is basically involved in synchronization of data between the client and server database.I have a requirement wherein I have to track the schema changes and propagate those changes to the client database.Can anyone suggest me the best and the efficient method by means of which :1)I can track the schema changes on server (sql server 2005)2)and then the way by means of which how can i propagate those changes to the client.Client been sql ce |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-10 : 07:17:46
|
| The easiest way to track the changes to schemas is via a server wide trigger, this can then write to a table and you would simply need to query the table to propogate the changes to the client. |
 |
|
|
|
|
|
Track Schema changes on a database