Exclude a field for compare but get it in the script
Here is the situation I've the following table in 2 dbs:
CodeID - Null Not Allowed
CodeName - Null Not Allowed
CodeDescription - Null Not Allowed
CodeActive - Null Not Allowed
I need to compare data in the 2 db regardless the CodeActive value. So I can remove CodeActive from the mapping. But if a code is not present, the system need to add it.
The problem is the GetMigrationSQL give the insert command without the CodeActive (because excluded in the mapping I guess).
My question is: How can I ignore a field in the compare process but getting it in the insert command ?
(Hope I'm clear )
Thanks a lot