Using SynchronizationRecord how to find column ordinal?

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Using SynchronizationRecord how to find column ordinal?

Postby MarkLFT » Fri Apr 22, 2011 5: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?

Thanks
MarkLFT
 
Posts: 10
Joined: Fri Apr 22, 2011 3:59 am
Location: Bali, Indonesia

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

Hi there,

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

http://sdk.red-gate.com/index.php/StoreExample

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

HTH!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9: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 1 guest