Difference between revisions of "Updating SQL and server migration"

From InsightWiki
Jump to navigation Jump to search
Line 1: Line 1:
 +
=Migrating the Insight Database=
 +
 
You will have moved your SIMS database to a new location. The Insight database needs to sit alongside the SIMS database. To do this: <br> <br>
 
You will have moved your SIMS database to a new location. The Insight database needs to sit alongside the SIMS database. To do this: <br> <br>
  

Revision as of 09:47, 4 January 2018

Migrating the Insight Database

You will have moved your SIMS database to a new location. The Insight database needs to sit alongside the SIMS database. To do this:

  1. Update the local/shared connect.ini files (usually c:\program files\sims\sims. net\connect.ini and s:\sims\connect.ini) on the IIS server

  2. Download and install the latest Insight service pack from http://www.tascsoftware.co.uk A new, empty INSIGHT database will be created next to the new SIMS database. There will be no users or settings in the new empty database.

  3. Use SQL Management Studio on the new SQL Server instance to locate the physical paths to the new, empty database using: Right-click -> Properties -> Files (scroll nearly all the way to the right to see the "Path" column).

  4. Stop the SQL service using SQL Management Studio (right-click on the server name -> Stop), and replace the new, empty SIMS_INSIGHT.MDF and SIMS_INSIGHT.LDF files with your backed-up "filled" versions from the old server.

  5. Restart SQL (right-click on the server name -> Start).

  6. Re-run the Service Controller and on the "Commit" tab. Click "Begin" to continue using your previous INSIGHT database.