topic Copying data from History database to DSArea database in Contact Pro https://community.sinch.com/t5/Contact-Pro/Copying-data-from-History-database-to-DSArea-database/m-p/12813#M486 <P><STRONG>Symptoms</STRONG></P><P><SPAN>There is data for a particular date/time in the XXX</SPAN><SPAN>_Monitoring_History database but the same data is not available in the XXX_DSArea database. To recollect it, you need to copy the data from the History database to the DSArea database. You do this with the <STRONG>CopyLogData</STRONG> tool. The tool is available via a support ticket.</SPAN></P><P>&nbsp;</P><P><STRONG>&nbsp;Solution</STRONG></P><OL><LI><SPAN>Run the <STRONG>CopyLogData.exe</STRONG> by double-clicking it.</SPAN></LI><LI><SPAN>Enter the server name </SPAN><FONT face="courier new,courier">\instance</FONT><SPAN> and the Monitoring History database name as the source. If this is not a trusted connection, enter the server credentials.</SPAN></LI><LI><SPAN>Click <STRONG>Next</STRONG>.<BR /></SPAN><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_source.png" style="width: 377px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3690iDE59E4603D1EBBEF/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_source.png" alt="copy_log_source.png" /></span><BR /></SPAN></LI><LI><SPAN>Select <STRONG>Database</STRONG> and click <STRONG>Next</STRONG>.<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_database.png" style="width: 374px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3691iBA2B2238F2F901A3/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_database.png" alt="copy_log_database.png" /></span><BR /></SPAN></LI><LI><SPAN>Enter the destination database information. In this case, copy to the DSArea database.<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_destination.png" style="width: 376px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3692i105608F9BD057D9F/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_destination.png" alt="copy_log_destination.png" /></span><BR /></SPAN></LI><LI><SPAN>Choose the date/time to be copied and click <STRONG>Finish</STRONG>.<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_time_limits.png" style="width: 374px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3693i593024B94CEC9990/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_time_limits.png" alt="copy_log_time_limits.png" /></span><BR /></SPAN></LI><LI><SPAN>To recollect the data, follow the procedure in <A href="https://community.sinch.com/t5/Contact-Pro/Recollecting-reporting-data/td-p/12814" target="_self">Recollecting reporting data</A>.</SPAN></LI></OL><P>&nbsp;</P> Wed, 18 Oct 2023 11:51:30 GMT Nina_Makkonen 2023-10-18T11:51:30Z Copying data from History database to DSArea database https://community.sinch.com/t5/Contact-Pro/Copying-data-from-History-database-to-DSArea-database/m-p/12813#M486 <P><STRONG>Symptoms</STRONG></P><P><SPAN>There is data for a particular date/time in the XXX</SPAN><SPAN>_Monitoring_History database but the same data is not available in the XXX_DSArea database. To recollect it, you need to copy the data from the History database to the DSArea database. You do this with the <STRONG>CopyLogData</STRONG> tool. The tool is available via a support ticket.</SPAN></P><P>&nbsp;</P><P><STRONG>&nbsp;Solution</STRONG></P><OL><LI><SPAN>Run the <STRONG>CopyLogData.exe</STRONG> by double-clicking it.</SPAN></LI><LI><SPAN>Enter the server name </SPAN><FONT face="courier new,courier">\instance</FONT><SPAN> and the Monitoring History database name as the source. If this is not a trusted connection, enter the server credentials.</SPAN></LI><LI><SPAN>Click <STRONG>Next</STRONG>.<BR /></SPAN><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_source.png" style="width: 377px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3690iDE59E4603D1EBBEF/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_source.png" alt="copy_log_source.png" /></span><BR /></SPAN></LI><LI><SPAN>Select <STRONG>Database</STRONG> and click <STRONG>Next</STRONG>.<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_database.png" style="width: 374px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3691iBA2B2238F2F901A3/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_database.png" alt="copy_log_database.png" /></span><BR /></SPAN></LI><LI><SPAN>Enter the destination database information. In this case, copy to the DSArea database.<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_destination.png" style="width: 376px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3692i105608F9BD057D9F/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_destination.png" alt="copy_log_destination.png" /></span><BR /></SPAN></LI><LI><SPAN>Choose the date/time to be copied and click <STRONG>Finish</STRONG>.<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="copy_log_time_limits.png" style="width: 374px;"><img src="https://community.sinch.com/t5/image/serverpage/image-id/3693i593024B94CEC9990/image-size/large?v=v2&amp;px=999" role="button" title="copy_log_time_limits.png" alt="copy_log_time_limits.png" /></span><BR /></SPAN></LI><LI><SPAN>To recollect the data, follow the procedure in <A href="https://community.sinch.com/t5/Contact-Pro/Recollecting-reporting-data/td-p/12814" target="_self">Recollecting reporting data</A>.</SPAN></LI></OL><P>&nbsp;</P> Wed, 18 Oct 2023 11:51:30 GMT https://community.sinch.com/t5/Contact-Pro/Copying-data-from-History-database-to-DSArea-database/m-p/12813#M486 Nina_Makkonen 2023-10-18T11:51:30Z