SET IDENTITY_INSERT [SubtextDB].[dbo].[subtext_Config] ON

INSERT INTO [SubtextDB].[dbo].[subtext_Config] 
( 
	BlogId
)
SELECT BlogId FROM [dbDotText].[haacked].[blog_Config]
GO

UPDATE [SubtextDB].[dbo].[subtext_Content] 
SET DateSyndicated = DateUpdated
WHERE PostConfig & 16 = 16 AND PostConfig & 1 = 1
GO

INSERT INTO [SubtextDB].[dbo].[subtext_EntryViewCount] 
( EntryID, BlogId, WebCount, AggCount, WebLastUpdated, AggLastUpdated )
    SELECT 
        EntryID, NotABlogId, WebCount, AggCount, WebLastUpdated, AggLastUpdated
    FROM [dbDotText].[haacked].[blog_EntryViewCount]
    WHERE 1=1
GO

