cravincreeks
Technical User
Hello all,
We're migrating a large volume of data from an ESRI personal geodatabase stored in MS Access to a ESRI ArcSDE geodatabase stored in Oracle. The actual migration process must use ESRI proprietary objects that are necessary to ensure the spatial data and the related spatial indexes are migrated correctly.
I'm looking for a tool that I can run after the migration to verify:
1) the row count in the original table (OT) = the row count in the target table (TT)
2) the OT and TT have the same number of fields
3) there are no fields that are completely null (the values didn't copy to the TT) or have a high percentage of null values (e.g. >80% of the values are null could be a problem)
I can hack this out myself, but why waste the time if somebody had already done it? Ideally, I'd be able to get my hands on the code so I can modify it for our needs if necessary.
Thanks
Alex
We're migrating a large volume of data from an ESRI personal geodatabase stored in MS Access to a ESRI ArcSDE geodatabase stored in Oracle. The actual migration process must use ESRI proprietary objects that are necessary to ensure the spatial data and the related spatial indexes are migrated correctly.
I'm looking for a tool that I can run after the migration to verify:
1) the row count in the original table (OT) = the row count in the target table (TT)
2) the OT and TT have the same number of fields
3) there are no fields that are completely null (the values didn't copy to the TT) or have a high percentage of null values (e.g. >80% of the values are null could be a problem)
I can hack this out myself, but why waste the time if somebody had already done it? Ideally, I'd be able to get my hands on the code so I can modify it for our needs if necessary.
Thanks
Alex