SiteMap convert

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
SET IDENTITY_INSERT [PTISys].[dbo].[map] ON
GO
INSERT INTO [PTISys].[dbo].[map] ([ID]
,[PID]
,[Name]
,[URL]
,[OP]
,[PermID]
,[IsValid]
,[LatestCheck]
,[status]
,[class]
,[SSID]
,[AParams]) SELECT ObjectID AS ID, ParentObjectID AS PID, FullName AS NAME, ContentPagePath AS URL,
NULL AS OP,
NULL AS PermID,
NULL AS IsValid,
NULL AS LatestCheck,
NULL AS status,
NULL AS class, 3 AS SSID,AParams from STZTRSys.Common.vPages WHERE PageViewID=9
SET IDENTITY_INSERT [PTISys].[dbo].[map] OFF
UPDATE map SET PID = NULL WHERE PID=0
UPDATE map SET URL = '',IsValid=1,status=200 WHERE URL = '/Environment/DocLib/MhtForm.aspx';