truncate table dbo.cf_zz_DraftHtmlBlock;
truncate table dbo.cf_zz_DraftHtmlBlockContent;
truncate table dbo.cf_zz_DraftPage;
truncate table dbo.cf_zz_DraftPageContent;
truncate table dbo.cf_zz_DraftPageItem;
truncate table dbo.cf_zz_DraftPageItemConfig;
truncate table dbo.cf_zz_DraftPageOption;

truncate table dbo.cf_zz_HtmlBlock;
truncate table dbo.cf_zz_HtmlBlockContent;
truncate table dbo.cf_zz_Page;
truncate table dbo.cf_zz_PageContent;
truncate table dbo.cf_zz_PageItem;
truncate table dbo.cf_zz_PageItemConfig;
truncate table dbo.cf_zz_PageOption;

set identity_insert [cf_zz_HtmlBlock] on
GO

insert into [cf_zz_HtmlBlock] ([id], [added]) select [id], [added] from openquery(CARLEYF, 'select * from cf_zz_HtmlBlock');
GO

set identity_insert [cf_zz_HtmlBlock] off
GO


set identity_insert [cf_zz_HtmlBlockContent] on
GO

insert into [cf_zz_HtmlBlockContent] ([idBlock], [language], [content], [added], [changed]) select [idBlock], [language], [content], [added], [changed] from openquery(CARLEYF, 'select * from cf_zz_HtmlBlockContent');
GO

set identity_insert [cf_zz_HtmlBlockContent] off
GO


set identity_insert [cf_zz_Page] on
GO

insert into [cf_zz_Page] ([id], [idParent], [alias], [handler], [bodyTemplate], [showInSiteMap], [showInMenu], [allowDelete], [isSecure], [isIndexing], [isRoot], [hasBlocks], [final], [system], [redirect], [redirectType], [redirectPageId], [redirectStatus], [redirectAlias], [sorter], [added], [changed]) select [id], [idParent], [alias], [handler], [bodyTemplate], [showInSiteMap], [showInMenu], [allowDelete], [isSecure], [isIndexing], [isRoot], [hasBlocks], [final], [system], [redirect], [redirectType], [redirectPageId], [redirectStatus], [redirectAlias], [sorter], [added], [changed] from openquery(CARLEYF, 'select * from cf_zz_Page');
GO

set identity_insert [cf_zz_Page] off
GO

set identity_insert [cf_zz_PageContent] on
GO

insert into [cf_zz_PageContent] ([idPage], [language], [title], [menuTitle], [header], [keywords], [description]) select [idPage], [language], [title], [menuTitle], [header], [keywords], [description] from openquery(CARLEYF, 'select * from cf_zz_PageContent');
GO

set identity_insert [cf_zz_PageContent] off
GO

set identity_insert [cf_zz_PageItem] on
GO

insert into [cf_zz_PageItem] ([id], [idPage], [idGroup], [type], [number], [name], [title], [allowDelete], [sorter], [added], [changed]) select [id], [idPage], [idGroup], [type], [number], [name], [title], [allowDelete], [sorter], [added], [changed] from openquery(CARLEYF, 'select * from cf_zz_PageItem');
GO

set identity_insert [cf_zz_PageItem] off
GO

set identity_insert [cf_zz_PageItemConfig] on
GO

insert into [cf_zz_PageItemConfig] ([id], [idItem], [name], [value]) select [id], [idItem], [name], [value] from openquery(CARLEYF, 'select * from cf_zz_PageItemConfig');
GO

set identity_insert [cf_zz_PageItemConfig] off
GO


set identity_insert [cf_zz_PageOption] on
GO

insert into [cf_zz_PageOption] ([id], [idPage], [name], [show], [value]) select [id], [idPage], [name], [show], [value] from openquery(CARLEYF, 'select * from cf_zz_PageOption');
GO

set identity_insert [cf_zz_PageOption] off
GO