I keep getting an error when i tried to refresh in ReadyRollDBSync
at the step "Ensuring Shadow Database is up-to-date".
My database uses Change tracking in for its tables.
Here is the error
"Change Tracking must be enabled on database '[MyDatabaseName_Administrator_SHADOW]' before it can be enabled on the table 'MyTableName'"
Here the table "MyTableName" is a table that will have a change tracking enabled to,and it have a sql script generated in Deploy-Once Folder.
I'm using Visual Studio 2012 and MS-SQLServer 2012
Sorry to hear you’ve run into a problem there building your Shadow database.
As unfortunately ReadyRoll doesn’t automatically script database-level properties, like whether Change Tracking is enabled, you’ll need to add this as a Pre-Deployment script action. To do so, add a new script under the projects Pre-Deployment folder, e.g.<ProjectRoot>\Pre-Deployment\02_Enable_ChangeTracking.sql
Great to hear, Ermias! Thanks for letting us know.
This question has received the maximum number of answers.