Hi Stephen,

I have emptied all the tables confirming the article in the knowledge base

->How to migrate product data.

All the tables are empty, except the "Tax" table.
This table is related to the "Shipping Method" table.
This is ok, because there is only 1 record in this table, and I want to keep the shipping table.

However, when I import the categories again, then the parent categories are accepted with the old categoryID, except the child categories.
Then I get a message "invalid parent categoryID".

When I check this manually in the SF interface, then I noticed that the numbering of the category ID's does not start with 0 after deleting the category table.

How to set the numbering of the ID's for this of other tables to 0?

Regards, Ton

Personally, i wouldn't worry about the ID values that continue to grow if that is what you are concerned with. They don't show up especially when using advanced URL format. For importing purposes, you can use Object keys to reference parent objects instead of by ID number that makes it easier. Take a look here under Object identifer and keys section.

http://www.revindex.com/R...port-export-overview

If you absolutely want to reset the ID so it starts the next insert from 1, take a look here using SQL (advanced topic, take backup first) :

https://docs.microsoft.co...ckident-transact-sql

Hi Stephen,

Thanks for your answer.
It is clear to me that I have to leave the idea to get an exact mirror of the database.
I was presuming to upload my tables to 2 different databases.
I know know that this an almost impossible task.
the numbering of the id will be always different.

Regards, Ton