Ignoring Database Tables / Objects

priyasinha · February 29, 2016 10:12AM

Note: This issues has been migrated from ReadyRoll support forum

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.

priyasinha · February 29, 2016 10:13AM

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.

&lt;PropertyGroup&gt; 
  &lt;ExcludeObjectsFromImport&gt;
    Schema=&#91;cya&#93;;
    Table=&#91;cya&#93;.&#91;(.?)&#93;;
    Schema=&#91;job&#93;;
    Table=&#91;job&#93;.&#91;(.?)&#93;;
    Schema=&#91;reporting&#93;;
    Table=&#91;reporting&#93;.&#91;(.*?)&#93;;
  &lt;/ExcludeObjectsFromImport&gt;
&lt;/PropertyGroup&gt;

In this example, the cya, job and reporting schemas will be excluded, as well as the tables contained within these schemas.

For more information on configuring exclude rules, see this article in the documentation:
https://documentation.red-gate.com/disp ... se+Objects

ledrop · November 8, 2017 11:05AM

Hi, I am trying this out but my PropertyGroup "ExcludeObjectsFromImport" always dissapear from the project section. Only the ExcludeObjectsFromSync stays in the file but does not hide to selected objects

dnlnln · November 8, 2017 10:26PM

Please note that the ExcludeObjectsFromImport setting is a feature of ReadyRoll Pro. If you already have ReadyRoll Pro and are continuing to see the removal behaviour, please let us know so we can investigate further.

Ignoring Database Tables / Objects

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk