Is it possible to tell Ready Roll to ignore certain tables when it's comparing databases?
For example, we are using a content management system which creates some tables that has its own deployment / upgrade mechanism in it. We are adding our own custom tables to the same database (for which we're using Ready Roll) but we want to leave the CMS to manage its own updates.
You can indeed exclude/ignore specific objects when using the DBSync tool to compare the database. It does require a certain amount of editing of the database project file, as unfortunately a GUI is not yet available.
You specify each rule as an Object Type/Object Name Pattern (regex) pair at the top of your .sqlproj file.<PropertyGroup> <ExcludeObjectsFromImport>
In this example, the cya, job and reporting schemas will be excluded, as well as the tables contained within these schemas.
After editing your project file, please ensure that you close and re-open your Visual Studio solution so that the change takes effect within the DBSync tool.
Here’s the full list of object types that you can add exclude rules for:
This question has received the maximum number of answers.