How to exclude column by code?

Automate and integrate using the SQL comparison API

How to exclude column by code?

Postby ampo » Thu May 21, 2009 6:32 am


How can I exclude column from beeing compared by code?

This is my current code:
Code: Select all
commonTables = Tables.CreateFromIntersection(dbSource.Tables, dbTarget.Tables);

TableComparisonSetting = new TableComparisonSetting(table.FullyQualifiedName, table.Fields, table.PrimaryKey.Fields);


m_session.CompareDatabases(dbSource, dbTarget, m_settings);

block = m_provider.GetMigrationSQL(m_session, true);

Is it somthing in the "table.Fields" parameter?

Posts: 8
Joined: Thu May 21, 2009 6:19 am

Postby Brian Donahue » Thu May 21, 2009 10:32 am

The following example shows how to exclude particular fields from the data comparison: ... ionExample

I hope this works for you.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests