I am creating a FME script that will accept to databases (MDB file and SDE Database) and will update the SDE database if there are any changes to the MDB file. I have a CRCCalculator for both SDE and MDB file to determine if there are any changes and a UniqueIdentifier is present on both.
Its currently working but I'm noticing that when FME writes the features to the SDE database (e.g. FMEMultiArea), in some cases it changes the sequence of the parts therefore changing the area value. This will in turn change the CRC value calculated when i run the FME script again so everytime it thinks there is an update.
I'm wondering if i need to add something to prevent the writer from changing the sequence.
FME Workflow:
Sample MDB Feature:
Sample SDE Feature:
I am using SQL Server 2012 to store the data.