Difference between revisions of "Updating SQL and server migration"
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:
- 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
- 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.
- 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).
- 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.
- Restart SQL (right-click on the server name -> Start).
- Re-run the Service Controller and on the "Commit" tab. Click "Begin" to continue using your previous INSIGHT database.