Using SynchronizationRecord how to find column ordinal?

Automate and integrate using the SQL comparison API

Using SynchronizationRecord how to find column ordinal?

Postby MarkLFT » Fri Apr 22, 2011 4:56 am

I want to compare two tables and usinf SyncronisationRecord, only update the tables where the values of a specific column are different. I can use the row.FieldDifferent, but for this I need the ordinal of the column. I don't like to use a number, as they have a habit of changing. Better to use the column name, less likely to change. Is there anyway to find what is the ordinal number of a column by it's name?

Posts: 10
Joined: Fri Apr 22, 2011 2:59 am
Location: Bali, Indonesia

Postby peter.peart » Mon Apr 25, 2011 1:43 pm

Hi there,

The example on the below page details how to get comparison results including column names:

With that in mind, once you have the column names you should then be able to sync based on them.


Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Site Admin
Posts: 362
Joined: Tue Sep 02, 2008 8:58 am
Location: Top floor, RG towers with the cool kids

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests