View source for Updating SQL and server migration

=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>

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

[[Category:Technical]]