Declare @SiteKeyNew As Integer Declare @SiteKeyOld As Integer Declare @LastDate As Date
SET @SiteKeyNew = !Enter new site key SET @SiteKeyOld = !Enter old site key
SET @LastDate = !Enter your date here
INSERT INTO [WhosOnV5].[dbo].[DaySummary] ([SiteKey] ,[Dated] ,[Visits] ,[FullDayFlag] ,[LastTime] ,[NewVisitors] ,[AlertsFree] ,[AlertsPaid] ,[Spiders] ,[Exceptions] ,[Downloads] ,[Invites] ,[Chats] ,[ChatsMissed] ,[Prospects] ,[Customers] ,[Hacks] ,[PaidListingAbuse] ,[Peak] ,[PeakTime] ,[BytesServed] ,[BytesReceived] ,[TimeTaken] ,[PageErrors] ,[PageViews] ,[Cost] ,[Revenue]) SELECT @SiteKeyNew ,[Dated] ,[Visits] ,[FullDayFlag] ,[LastTime] ,[NewVisitors] ,[AlertsFree] ,[AlertsPaid] ,[Spiders] ,[Exceptions] ,[Downloads] ,[Invites] ,[Chats] ,[ChatsMissed] ,[Prospects] ,[Customers] ,[Hacks] ,[PaidListingAbuse] ,[Peak] ,[PeakTime] ,[BytesServed] ,[BytesReceived] ,[TimeTaken] ,[PageErrors] ,[PageViews] ,[Cost] ,[Revenue] FROM LinkedServer.[WhosOnV5].[dbo].[DaySummary] WHERE SiteKey = @SiteKeyOld AND Dated <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[DaySummaryKeywords] ([SiteKey] ,[Dated] ,[KeywordID] ,[Visits] ,[NewVisitors] ,[Prospects] ,[Customers]) SELECT @SiteKeyNew ,[Dated] ,[KeywordID] ,[Visits] ,[NewVisitors] ,[Prospects] ,[Customers] FROM [LinkedServer].[WhosOnV5].[dbo].[DaySummaryKeywords] WHERE SiteKey = @SiteKeyOld AND Dated <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[DaySummaryAlerts] ([SiteKey] ,[Dated] ,[AlertNo] ,[Visits] ,[NewVisitors] ,[Prospects] ,[Customers] ,[PageViews] ,[Invites] ,[Chats] ,[Cost] ,[Revenue]) SELECT @SiteKeyNew ,[Dated] ,[AlertNo] ,[Visits] ,[NewVisitors] ,[Prospects] ,[Customers] ,[PageViews] ,[Invites] ,[Chats] ,[Cost] ,[Revenue] FROM [LinkedServer].[WhosOnV5].[dbo].[DaySummaryAlerts] WHERE SiteKey = @SiteKeyOld AND Dated <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[DaySummaryPages] ([SiteKey] ,[Dated] ,[PageID] ,[Visits] ,[NewVisitors] ,[PageViews] ,[Chats] ,[Errors] ,[TimeSpent]) SELECT @SiteKeyNew ,[Dated] ,[PageID] ,[Visits] ,[NewVisitors] ,[PageViews] ,[Chats] ,[Errors] ,[TimeSpent] FROM [LinkedServer].[WhosOnV5].[dbo].[DaySummaryPages] WHERE SiteKey = @SiteKeyOld AND Dated <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[DaySummaryReferrers] ([SiteKey] ,[Dated] ,[ReferrerID] ,[Visits] ,[NewVisitors] ,[Prospects] ,[Customers]) SELECT @SiteKeyNew ,[Dated] ,[ReferrerID] ,[Visits] ,[NewVisitors] ,[Prospects] ,[Customers] FROM [LinkedServer].[WhosOnV5].[dbo].[DaySummaryReferrers] WHERE SiteKey = @SiteKeyOld AND Dated <= @LastDate
ALTER INDEX keywords_key1 on WhosOnV5.dbo.keywords SET ( ignore_dup_key = ON );
INSERT INTO [WhosOnV5].[dbo].[Keywords] ([SiteKey] ,[SearchEngine] ,[Keywords]) SELECT @SiteKeyNew ,[SearchEngine] ,[Keywords] FROM [LinkedServer].[WhosOnV5].[dbo].[Keywords] WHERE SiteKey = @SiteKeyOld
INSERT INTO [WhosOnV5].[dbo].[PageViews] ([VisitID] ,[PageID] ,[VisitorID] ,[SiteKey] ,[PageDate] ,[PageNumber] ,[HTTPStatus] ,[HTTPSubStatus]) SELECT [VisitID] ,[PageID] ,[VisitorID] ,@SiteKeyNew ,[PageDate] ,[PageNumber] ,[HTTPStatus] ,[HTTPSubStatus] FROM [LinkedServer].[WhosOnV5].[dbo].[PageViews] WHERE SiteKey = @SiteKeyOld AND PageDate <= @LastDate
ALTER INDEX keywords_key1 on WhosOnV5.dbo.keywords SET ( ignore_dup_key = OFF );
ALTER INDEX PageHeader_key1 on WhosOnV5.dbo.PageHeader SET ( ignore_dup_key = ON );
INSERT INTO [WhosOnV5].[dbo].[PageHeader] ([SiteKey] ,[Page] ,[TitleTag] ,[DescriptionTag] ,[Keywords] ,[ContentGroup] ,[LastModified] ,[LastChecked]) SELECT @SiteKeyNew ,[Page] ,[TitleTag] ,[DescriptionTag] ,[Keywords] ,[ContentGroup] ,[LastModified] ,[LastChecked] FROM [LinkedServer].[WhosOnV5].[dbo].[PageHeader] WHERE SiteKey = @SiteKeyOld ALTER INDEX PageHeader_key1 on WhosOnV5.dbo.PageHeader SET ( ignore_dup_key = OFF );
ALTER INDEX referrers_key1 on WhosOnV5.dbo.referrers SET ( ignore_dup_key = ON );
INSERT INTO [WhosOnV5].[dbo].[Referrers] ([SiteKey] ,[SearchEngine] ,[Referrer]) SELECT @SiteKeyNew ,[SearchEngine] ,[Referrer] FROM [LinkedServer].[WhosOnV5].[dbo].[Referrers] WHERE SiteKey = @SiteKeyOld
ALTER INDEX referrers_key1 on WhosOnV5.dbo.referrers SET ( ignore_dup_key = OFF );
INSERT INTO [WhosOnV5].[dbo].[UserCallBacks] ([SiteKey] ,[CallUID] ,[VisitID] ,[VKey] ,[RequestTime] ,[RequestedUser] ,[RequestedDept] ,[TakenByUser] ,[TakenByDept] ,[Dated] ,[StartTime] ,[FinishTime] ,[TelephoneNo] ,[TelephoneType] ,[VisitorName] ,[VisitorCompany] ,[VisitorCountry] ,[VisitorEmail] ,[VisitorTimeZone] ,[VisitorIP] ,[VisitorUserName] ,[VisitorVisitNumber] ,[CallClosed] ,[Notes]) SELECT @SiteKeyNew ,[CallUID] ,[VisitID] ,[VKey] ,[RequestTime] ,[RequestedUser] ,[RequestedDept] ,[TakenByUser] ,[TakenByDept] ,[Dated] ,[StartTime] ,[FinishTime] ,[TelephoneNo] ,[TelephoneType] ,[VisitorName] ,[VisitorCompany] ,[VisitorCountry] ,[VisitorEmail] ,[VisitorTimeZone] ,[VisitorIP] ,[VisitorUserName] ,[VisitorVisitNumber] ,[CallClosed] ,[Notes] FROM [LinkedServer].[WhosOnV5].[dbo].[UserCallBacks] WHERE SiteKey = @SiteKeyOld AND Dated <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[UserChats] ([SiteKey] ,[ChatUID] ,[VisitID] ,[VKey] ,[TakenByUser] ,[TakenByDept] ,[Dated] ,[StartTime] ,[FinishTime] ,[VisitorName] ,[VisitorIP] ,[VisitorUserName] ,[VisitorVisitNumber] ,[VisitorPageID] ,[WaitedForSecs] ,[ChattedForSecs] ,[VisitorClosed] ,[Invited] ,[Rating] ,[MessageEmail] ,[MessageText]) SELECT @SiteKeyNew ,[ChatUID] ,[VisitID] ,[VKey] ,[TakenByUser] ,[TakenByDept] ,[Dated] ,[StartTime] ,[FinishTime] ,[VisitorName] ,[VisitorIP] ,[VisitorUserName] ,[VisitorVisitNumber] ,[VisitorPageID] ,[WaitedForSecs] ,[ChattedForSecs] ,[VisitorClosed] ,[Invited] ,[Rating] ,[MessageEmail] ,[MessageText] FROM [LinkedServer].[WhosOnV5].[dbo].[UserChats] WHERE SiteKey = @SiteKeyOld AND Dated <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[UserChatVars] ([SiteKey] ,[ChatUID] ,[VarKey] ,[PreOrPost] ,[VarData]) SELECT @SiteKeyNew ,[ChatUID] ,[VarKey] ,[PreOrPost] ,[VarData] FROM [LinkedServer].[WhosOnV5].[dbo].[UserChatVars] WHERE SiteKey = @SiteKeyOld
INSERT INTO [WhosOnV5].[dbo].[UserTranscript] ([SiteKey] ,[ChatUID] ,[LineNumber] ,[LineTime] ,[OperatorLine] ,[LineText]) SELECT @SiteKeyNew ,[ChatUID] ,[LineNumber] ,[LineTime] ,[OperatorLine] ,[LineText] FROM [LinkedServer].[WhosOnV5].[dbo].[UserTranscript] WHERE SiteKey = @SiteKeyOld
INSERT INTO [WhosOnV5].[dbo].[Visit] ([VKey] ,[SiteKey] ,[Alert] ,[AlertNo] ,[VisitNo] ,[VisitDate] ,[PagesSeen] ,[SecondsOnSite] ,[Invited] ,[Chatted] ,[Prospect] ,[Customer] ,[HackRaised] ,[PaidListingAbuse] ,[Spider] ,[Cost] ,[Revenue] ,[FirstPageID] ,[LastPageID] ,[OperatingSystemID] ,[BrowserID] ,[ReferrerID] ,[KeywordsID] ,[ReferrerQuery]) SELECT [VKey] ,@SiteKeyNew ,[Alert] ,[AlertNo] ,[VisitNo] ,[VisitDate] ,[PagesSeen] ,[SecondsOnSite] ,[Invited] ,[Chatted] ,[Prospect] ,[Customer] ,[HackRaised] ,[PaidListingAbuse] ,[Spider] ,[Cost] ,[Revenue] ,[FirstPageID] ,[LastPageID] ,[OperatingSystemID] ,[BrowserID] ,[ReferrerID] ,[KeywordsID] ,[ReferrerQuery] FROM [LinkedServer].[WhosOnV5].[dbo].[Visit] WHERE SiteKey = @SiteKeyOld AND VisitDate <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[VisitFormVars] ([VisitID] ,[SiteKey] ,[VarForm] ,[VarName] ,[VarData] ,[VarTime]) SELECT [VisitID] ,@SiteKeyNew ,[VarForm] ,[VarName] ,[VarData] ,[VarTime] FROM [LinkedServer].[WhosOnV5].[dbo].[VisitFormVars] WHERE SiteKey = @SiteKeyOld
INSERT INTO [WhosOnV5].[dbo].[VisitorContact] ([VKey] ,[SiteKey] ,[IP] ,[Name] ,[Email] ,[Company] ,[Telephone] ,[Fax] ,[Street] ,[City] ,[ZIP] ,[Country] ,[Web] ,[Organization] ,[CRMID] ,[DateAdded] ,[Notes]) SELECT [VKey] ,@SiteKeyNew ,[IP] ,[Name] ,[Email] ,[Company] ,[Telephone] ,[Fax] ,[Street] ,[City] ,[ZIP] ,[Country] ,[Web] ,[Organization] ,[CRMID] ,[DateAdded] ,[Notes] FROM [LinkedServer].[WhosOnV5].[dbo].[VisitorContact] WHERE SiteKey = @SiteKeyOld AND DateAdded <= @LastDate
INSERT INTO [WhosOnV5].[dbo].[Visitors] ([VKey] ,[SiteKey] ,[IP] ,[Visits] ,[FirstVisitID] ,[FirstDate] ,[LastDate] ,[Spider] ,[PaidListingAbuse] ,[HackCount] ,[ProspectVisitID] ,[CustomerVisitID] ,[TotalCost] ,[TotalRevenue] ,[Country] ,[Region]) SELECT [VKey] ,@SiteKeyNew ,[IP] ,[Visits] ,[FirstVisitID] ,[FirstDate] ,[LastDate] ,[Spider] ,[PaidListingAbuse] ,[HackCount] ,[ProspectVisitID] ,[CustomerVisitID] ,[TotalCost] ,[TotalRevenue] ,[Country] ,[Region] FROM [LinkedServer].[WhosOnV5].[dbo].[Visitors] WHERE SiteKey = @SiteKeyOld AND LastDate <= @LastDate
|