https://www.tascsoftware.co.uk/wiki/PARS/index.php?action=history&feed=atom&title=Datatable_migration_toolDatatable migration tool - Revision history2026-06-09T21:30:55ZRevision history for this page on the wikiMediaWiki 1.34.2https://www.tascsoftware.co.uk/wiki/PARS/index.php?title=Datatable_migration_tool&diff=41071&oldid=prevAdmin at 08:36, 7 October 20162016-10-07T08:36:39Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 08:36, 7 October 2016</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5" >Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The DMT tool is only available on request. Requests can be made using our [[help|online helpdesk]]. <br> <br></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The DMT tool is only available on request. Requests can be made using our [[help|online helpdesk]]. <br> <br></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>=Running the DMT=</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">=</ins>=Running the DMT<ins class="diffchange diffchange-inline">=</ins>=</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The DMT should only be run on the IIS server that is hosting PARS. The SIMS database must be backed up before running the tool. <br> <br></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The DMT should only be run on the IIS server that is hosting PARS. The SIMS database must be backed up before running the tool. <br> <br></div></td></tr>
</table>Adminhttps://www.tascsoftware.co.uk/wiki/PARS/index.php?title=Datatable_migration_tool&diff=41070&oldid=prevAdmin: Created page with "Historically the datatables used by PARS were hosted in the SIMS database, but for a variety of reasons, this is no longer suitable. The Datatable Migration Tool (DMT) is will..."2016-10-07T08:36:31Z<p>Created page with "Historically the datatables used by PARS were hosted in the SIMS database, but for a variety of reasons, this is no longer suitable. The Datatable Migration Tool (DMT) is will..."</p>
<p><b>New page</b></p><div>Historically the datatables used by PARS were hosted in the SIMS database, but for a variety of reasons, this is no longer suitable. The Datatable Migration Tool (DMT) is will migrate these datatables out of the SIMS database and into a new separate PARS database on the SQL server. <br> <br><br />
<br />
'''This tool is not to be used when migrating servers.''' The process for migrating the SQL server is covered on the [[server migration]] page. <br> <br><br />
<br />
The DMT tool is only available on request. Requests can be made using our [[help|online helpdesk]]. <br> <br><br />
<br />
=Running the DMT=<br />
<br />
The DMT should only be run on the IIS server that is hosting PARS. The SIMS database must be backed up before running the tool. <br> <br><br />
<br />
To run the DMT simply double click on the .exe file. Several popup windows will appear. <br> <br><br />
<br />
[[Image:dmt01.jpg]] <br> <br><br />
<br />
[[Image:dmt02.jpg]] <br> <br><br />
<br />
The DMT will automatically detect the SQL instance and database name. These settings are taken from the connect.ini file used by the SIMS workstation installation on the server. The settings must be correct before proceeding. <br> <br><br />
<br />
[[Image:dmt03.jpg]] <br> <br><br />
<br />
[[Image:dmt04.jpg]] <br> <br><br />
<br />
When the tool runs it will display a log of its actions on screen. The tool can be closed using the door button at the bottom right of the application. Any error messages should be reported to our [[help|online helpdesk]]. <br> <br><br />
<br />
[[Image:dmt05.jpg]] <br> <br><br />
<br />
[[Category:Technical]]</div>Admin