Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
nameArchiving
Easy html macro
theme{"label":"solarized_dark","value":"solarized_dark"}
contentByMode{"html":"<!doctype html>\r\n<link href=\"https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css\" rel=\"stylesheet\" integrity=\"sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC\" crossorigin=\"anonymous\">\r\n<link href=\"https://docs.empowerid.com/new_docs.css\" rel=\"stylesheet\">\r\n<script src=\"https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js\" integrity=\"sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM\" crossorigin=\"anonymous\"></script>\r\n <div class = \"bd-callout bd-callout-warning\">Be sure to replace the valueof value of the <b>DatabaseServerdName<<b>DatabaseServerName</b> \r\n parameter with the name of the SQL server hosting the database in your environment.\r\n <p class = \"bd-callout bd-callout-success\">As a best practice, the archive database should be hosted on the same SQL server \r\n as the EmpowerID Identity Warehouse.</p>\r\n <div class = \"bd-callout bd-callout-danger\">If you name the database something other than \r\n <b>EmpowerID_Archive</b>, be sure to do the following:\r\n <li>Replace the vaule value of the <b>DatabaseName</b> parameter as needed</li>\r\n <li>Update the name of the <b>ExtensionAttribute1</b> field in the <b>ExecutionRunTimeJob</b> table</li>\r\n <li>Perform an <b>iisreset</b> to ensure EmpowerID picks up the new archive database</li>\r\n </div>\r\n </div>","javascript":"","css":""}
Code Block
languagesql
EXEC dbo.Custom_ArchivingRule_CreateArchiveTables @DatabaseServerName=N'SQL2019',
                                                  @Owner='dbo',
                                                  @DatabaseName='EmpowerID_Archive'