Hey Andrei,
I am sure you have a quick answer for this one, but will ask anyways.
After writing some custom import/exports for categories, and specifications... looking back, it would have been a far easier of a task if the primary keys of the base classes/ tables were of type uniqueidentity (guid) instead of an integer (auto incrementing). If it were possible to changeover, when migrating databases, etc. it would be a very simple export process as the guids would always be correct...we literally could export the products, then all the specifications, etc and import them in a new database without having any foreign key issues.
Thanks