Excluding Tables doesn't seem to work

faniedt · April 26, 2016 2:03AM

I'm trying to exclude a list of tables from the compare but it doesn't seem to work. Below is my code that loops through the mappings and the datatable that contains the tablenames to exclude.

RedGate rg = new RedGate();
                DataTable dtTableToExclude = rg.GetTablesToExclude();

                for (int i = 0; i &lt; dtTableToExclude.Rows.Count; i++)
                {
                    tableToExclude = "&#91;dbo&#93;.&#91;" + dtTableToExclude.Rows&#91;i&#93;&#91;"TableName"&#93;.ToString() + "&#93;";

                    foreach (TableMapping m in mappings)
                    {
                        try
                        {
                            if (m.Obj1.FullyQualifiedName != null)
                            {
                                if (m.Obj1.FullyQualifiedName == tableToExclude)
                                {
                                    m.Include = false;
                                    break;
                                }
                            }
                            m.RefreshMappingStatus();

                        }

Thanks in advance ...

Rob C · April 28, 2016 6:18AM

Hi,

Could you give me some info about what exactly it is that you're trying to do? Would you be able to get your code to ignore any differences relating to the tables that you're not interested in?

Excluding Tables doesn't seem to work

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk