Forums (Obsolete)

Old Forums

Portal Engine

Version 2.x > Portal Engine > Import/Export and Primary Keys

View modes:

Member

matt - 2/16/2007 8:57:08 PM

Import/Export and Primary Keys

It seems that when you export a site (from 2.0b) and import that site into 2.1a the primary keys are re-enumberated from the highest ID of the exported data set.

That is to say...

table1
------------
ID | Value
1 | value1
2 | value2
3 | value3

When I export a site that has a table like this and import into a new site that same table looks like this

table1
------------
ID | Value
4 | value1
5 | value2
6 | value3

Is this intended behavior?


Guest	kentico_martind - 2/20/2007 3:41:23 PM Re: Import/Export and Primary Keys Hello, When the site is imported, the data are inserted using standard INSERT command. It means the IDs should be assigned automatically by the SQL Server. Do you mean the table1 of the new site was empty before import and still IDs started with number 4? Best Regards, Martin Dobsicek

Top