Seed those Umbraco tables to aim content migration (amongst other benefits)

I really need to write a full post as to why you’d seed your Umbraco tables. The main reason is to split the content from the CMS setup/structure. This means you could release your changes via a custom toolset or move content between installations.

Remember for ease you must do this with a blank Umbraco database – that is just after install.

DBCC CHECKIDENT (cmsContent, reseed, 100000000)
DBCC CHECKIDENT (cmsContentVersion, reseed, 100000000)
DBCC CHECKIDENT (cmsPropertyData, reseed, 100000000)
DBCC CHECKIDENT (umbracoNode, reseed, 100000000)

Then you may want to select on those tables just to check.

SELECT 
IDENT_SEED(TABLE_NAME) AS Seed,
IDENT_INCR(TABLE_NAME) AS Increment,
IDENT_CURRENT(TABLE_NAME) AS Current_Identity,
TABLE_NAME
FROM 
INFORMATION_SCHEMA.TABLES
WHERE 
OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'TableHasIdentity') = 1
AND TABLE_TYPE = 'BASE TABLE'