Skip to content

Instantly share code, notes, and snippets.

@alirobe

alirobe/export-umbraco-redirects-for-seochecker.sql

Last active May 19, 2022 21:10
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alirobe/a8de71c875a6c089cce0d7781897e2fb to your computer and use it in GitHub Desktop.
Save alirobe/a8de71c875a6c089cce0d7781897e2fb to your computer and use it in GitHub Desktop.
Download ZIP
How to Migrate Umbraco Redirects into SEOChecker
Raw
export-umbraco-redirects-for-seochecker.sql
SELECT replace(umbracoRedirectUrl.url, '1075/', '') as url
,umbracoNode.id
,umbracoRedirectUrl.contentKey
FROM umbracoRedirectUrl
INNER JOIN umbracoNode on umbracoRedirectUrl.contentKey = umbracoNode.uniqueID
# Run in SSMS, right click results and export to CSV. Import CSV to SEOChecker.
# NB replace 1075 with your root node ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment