Change PKs from Int to UniqueIdentity

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
9 years ago
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
9 years ago
It's much easier to customize import/export process to support Int32 rather than moving to Guid. Furthermore, Int32 is much faster than Guid.
9 years ago
Thanks Andrei... performance reasons makes sense.
4 years ago
Hi,

We want primary key of few tables as GUID, is there any way we can achieve it in NopCommerce 4.20 version?
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.