don't touch/modify my schemas
I don't want the data sync or anything else for that matter to "touch" any of my databases.
Thank you for your suggestion! We would like to know what your concern is around schema modification – is it because you don’t always get granted schema modification rights? Are you concerned about administration/maintenance overhead of additional objects? Or are you concerned about additional overhead it places on the database?
Add back one comment after merge the similar suggestions:
Set up sync without altering on-premise database - Instead, the sync information could be held in a separate database on the same server. This would be great for syncing system critical databases like the SCCM database.
From: Joel Sanderi
Perhaps this idea could be merged with http://www.mygreatwindowsazureidea.com/forums/44459-sql-azure-data-sync-feature-voting/suggestions/2360724-don-t-touch-modify-my-schemas? Both ideas have the same result, pooling the votes would increase the chances of this being done.
I also think this would be a great idea. The simplest solution would be to give us the option to tell data sync to place all the tracking data in a separate database on the same server. This would keep the schemas clean but still keep all the necessary change information easily accessible to Data Sync.
Jason R. Craig commented
I fully agree, that is why Microsoft SQL Server 2008 has change tracking.