I have EAV/Property bag database structure which I want to load using GENERIC LOAD. The problem is, each property row also has ValidFrom and ValidTo colums, and including those in the load script produces huge amount of tables.
Database structure:
EntityID int
PropertyName string
PropertyValue string
ValidFrom date
ValidTo date
I tried to load it like this, which gives me tons of tables with numbering like 40123 (date I quess?):
GENERIC LOAD
AutoNumber(EntityID, 'Entity') AS Entity,
PropertyName,
PropertyValue,
ValidFrom,
ValidTo
This load will give the correct table structure, but I still need those two extra columns for each row:
GENERIC LOAD
AutoNumber(EntityID, 'Entity') AS Entity,
PropertyName,
PropertyValue