Difference between revisions of "Updating SQL and server migration"
Jump to navigation
Jump to search
(Created page with "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> #Update the local/shared connec...") |
|||
Line 1: | Line 1: | ||
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> | ||
− | #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 | + | #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 <br> <br> |
#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. <br> <br> | #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. <br> <br> | ||
#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). <br> <br> | #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). <br> <br> |
Revision as of 09:07, 11 August 2015
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.