<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p>The guide will detail how you can refresh your Halo On-Prem instance with that of another On-Prem instance, such as a production instance to a UAT / Dev instance.</p><p><br></p><p>Throughout this guide I will reference the two instances as below:</p><ul><li><strong>Source:</strong> The instance you are copying from</li><li><strong>Destination:</strong> The instance you are copying to</li></ul><p><br></p><p><strong><span style="font-size: 12pt;">Information Gathering</span></strong></p><p>To begin, you need to run the below queries on the database of the <strong>destination </strong>instance:</p><p><br></p><p style="margin-left: 20px;">SELECT rdbid, rdbkey FROM CONTROL;</p><p style="margin-left: 20px;">SELECT rdbsecret FROM CONTROL4;</p><p style="margin-left: 20px;"><br></p><p>and make a note of the results, as you will need them later.</p><p><br></p><p>It is now advised to take a backup of the <strong>source </strong>instances database, which can be used to restore it into the <strong>destination</strong> database.</p><p><br></p><p><br></p><p><strong><span style="font-size: 12pt;">Restoring the Database</span></strong></p><p>Before restoring the database, you need to ensure that the <strong>destination </strong>instance is stopped in IIS.</p><p><br></p><p>Once it is, you can restore the <strong>destination </strong>database to the backup we exported for the <strong>source </strong>instance. A guide on how to do this is listed here: <a data-fr-linked="true" href="https://support.haloservicedesk.com/kb?id=2448" id="isPasted">https://support.haloservicedesk.com/kb?id=2448</a></p><p><br></p><p><br></p><p><strong><span style="font-size: 12pt;">Setting the Keys</span></strong></p><p>Once the restore is successful, you need to run the below queries on the <strong>destination </strong>instances database filling the <variables> with the information we obtained earlier.</p><p><br></p><p>UPDATE CONTROL SET rdbid = '<rdbid >';</p><p>UPDATE CONTROL SET rdbkey = '<rdbkey>';</p><p>UPDATE CONTROL4 SET rdbsecret = '<rdbsecret>';</p><p><br></p><p><br></p><p><strong><span style="font-size: 12pt;">Setting the URLs</span></strong></p><p>For the <strong>destination</strong> instance, you need to navigate to the root folders of Halo and run the 'Config.exe' application.</p><p><br></p><p>Provided none of your database connection details have changed, you just need to select save:</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjE5NDRjY2E0LWQ5MGEtNDIyNS1hNDlkLTU1ZjE3ZDk2ZmZlZCJ9.Uw-PtTAYemBqA_dmELxCuErN_BnUz2jA3a9FuFZgj08" class="fr-fic fr-fil fr-dib" width="1042" height="684"></p><p><br></p><p>This will then populate the URLs in the database.</p><p><br></p><p><br></p><p><strong><span style="font-size: 12pt;">Upgrading the DB</span></strong></p><p>If the source instance was an older version than the destination, you will need to upgrade the database. This is done by running the 'Upgrader.exe'.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU0NTMyODhmLTgzYTItNDE5OC1iM2E5LWM2Nzc5Y2UzYjk5ZSJ9.0OLb0-FrE_Y257fYnXLzBL4K450BlzXcOQca6czLdHI" class="fr-fic fr-fil fr-dib" width="1383" height="677"></p><p><br></p><p><br></p><p><strong><span style="font-size: 12pt;">Finishing Up</span></strong></p><p>You can now start the site in IIS.</p>
