Skip to content

Instantly share code, notes, and snippets.

@skttl
Created July 11, 2019 09:18
Show Gist options
  • Save skttl/ec905a523af2a549f834d6ddbdde2ed2 to your computer and use it in GitHub Desktop.
Save skttl/ec905a523af2a549f834d6ddbdde2ed2 to your computer and use it in GitHub Desktop.
Migrate from Simple301 to SkybrudUmbracoRedirects
INSERT INTO [dbo].[SkybrudRedirects] (RedirectUniqueId, RootNodeId, Url, LinkMode, LinkId, LinkUrl, Created, Updated, IsPermanent, IsRegex, ForwardQueryString)
SELECT NEWID(), 0, OldUrl, 'url', 0, NewUrl, 1562836223, 1562836223, 1, IsRegex, 1 FROM [dbo].[Redirects];
SELECT TOP (1000) [RedirectId]
,[RedirectUniqueId]
,[RootNodeId]
,[Url]
,[QueryString]
,[LinkMode]
,[LinkId]
,[LinkUrl]
,[LinkName]
,[Created]
,[Updated]
,[IsPermanent]
,[IsRegex]
,[ForwardQueryString]
FROM [dbo].[SkybrudRedirects];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment