MIS Systems Thread, Migrating SIMS .net to new hardware in Technical; Before I ring our support people, I was wondering if anyone knew where there might be a guide to moving ...
15th July 2008, 05:02 PM #1
Migrating SIMS .net to new hardware
Before I ring our support people, I was wondering if anyone knew where there might be a guide to moving SISM .net onto new hardware... SupportNet is not proving very useful
I'm sure it's a case of just moving all the files across, moving the database across and then running DBAttach (or something).
IDG Tech News
15th July 2008, 07:06 PM #2
You're about right, our LEA did it in a couple of hours. - I don't think they did anything else apart from the usual service packs, sharing out the directories etc.
15th July 2008, 07:27 PM #3
15th July 2008, 07:36 PM #4
I'm doing this next week, instructions that I have (what has been posted) looks relatively straight forward if I come across any problems / issues when I am in the process of moving across I'll post here incase you haven't already started.
It would be interesting to hear how many others have happily moved SIMS from one server to another server either following CAPITA's instructions or via another method.
15th July 2008, 07:54 PM #5
Here are a couple of other guides i've got (possibly from here) and added to my ICT Support WIKI for reference. Thanks if these did come from here.
1. Run DbAttach.exe to detach the existing SIMS SQL database.
2. Make a copy the SIMS SQL database files eg SIMS.MDF and SIMS.LDF.
3. Make a copy of the DOCSTORAGE folder
1. Run CCSSQLExpressInst.exe to install SQL 2005 Express (or use your Microsoft SQL Sever 2005 installation cd)
2. Run S:\SIMS\SETUPS\SIMSINST.EXE
3. Tick the boxes for
'This computer will be used as a SIMS Workstation' 'This computer will be used as a SIMS Document Server'
This will automatically install the Document Server and a blank DOCSTORAGE folder.
3. Use DbAttach.exe to attach the copy of the SQL database taken from the Old Server. DbAttach.exe is located in e.g. C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\BINN
4. Edit the S:\SIMS\CONNECT.INI to reflect the New Server name
5. Copy the DOCSTORAGE folder to the new location on the New Server.
6. Change the directory structure of the DOCSTORAGE folder to match the settings on the new server - you would normally only need to change the SERVERNAME part of the path e.g.
Where SERVERNAME is the name of your new server Where INSTANCENAME is the name of the instance chosen when installing SQL. Where DATABASENAME is the name of the SQL database. Where REPORTFOLDERS are the folders named 2a, 3b etc and contain the physical report files.
ON THE CURRENT SERVER
1. Run FMS to confirm that you are connecting to the correct database and then exit FMS on all machines. 2. Copy the sims.db and sims.log to an external resource. To find the location of the database, go to Start | run and type odbcad32. Select System DSN tab, select SIMS32 and click configure. The database location is in the Database File path.
ON THE NEW SERVER
1. Create new folders through My Computer, and copy the sims.db and sims.log to this location on the New Server e.g C:\SIMS\FMS\SQL 2. Install FMS as a Server and Workstation on the New Server. Full details of this are covered in KB35095
If the Current server will continue to be part of the network, a unique service name is needed, or this will conflict with the New server.
E.g if the service name is SIMS_Server on the Current Server, this should be SIMSNEW_Server on the new server.
3. Go back into ODBCAD32, and change the Server Name on the configuration screen to SIMSNEW_Server
4. Go to Start | Run and type dbsvmn50 and select 'edit'. Edit the Parameters line to read SIMSNEW_Server. Note that the Server name must match exactly in the Service and ODBC
5. Start the FMS service to complete the set up. 6. Run FMS on the New Server machine to test and confirm the connection to the database 7. NOTE: If the service name has been altered to SIMSNEW_Server in the odbcad32 settings on the new server, this will also need to be altered on each workstation.
15th July 2008, 07:59 PM #6
I've done the new setup a few times and its pretty straight forward.
Give it a try on a virtual server, they are always handy to test the updates on.
The only difference to the instructions above is that FMS could now be running on MS SQL, not MYSQL
18th July 2008, 05:51 PM #7
Its pretty straightforward and if you're running FMS6.91+ it's a breeze.
18th July 2008, 06:14 PM #8
We moved/upgraded our SIMS install this time last year - SIMS server is now on its own dedicated server. I'm planning to make this physical server into a virtual one, then I can back up the whole server in one go and move it between bits of hardware if needed. Anyone done Windows-physical-to-virtual hosted on CentOS/Xen before? First question I have: do I need a GUI installed on my Xen server, or can I just log in to the virtual Windows server with remote desktop?
20th July 2008, 02:47 PM #9
I have succesfully moved my SIMS database to a new server and can log on succesfully by I am having issues with moving the FMS database. When I try to attach it on the new server I get the following error message (error.bmp).
When trying to logon to FMS I then receive the next error message (error2.bmp). Does anybody have any idea what the issue maybe?
The database reattaches fine on the old server with no error messages and I can log on fine.
20th July 2008, 02:51 PM #10
Are you using SQL express? I always got the first error message when attaching the SIMS database to an instance I setup using the MS install of SQL Express. As soon as I setup a blank sims database with the CCS release of SQLE and attached the SIMS databse it worked fine.
Originally Posted by Sylv3r
20th July 2008, 02:52 PM #11
For anybody else wanting to move SIMS / FMS I have found the following document quite useful also.
20th July 2008, 02:53 PM #12
Nope using Microsoft SQL Server 2005.
Originally Posted by Oops_my_bad
20th July 2008, 08:47 PM #13
- Rep Power
just what i was looking for thanks
9th August 2008, 04:30 PM #14
If the FMS database doesnt attach and produces that error, close dbattach on the new server and open it again. Detach the FMS database (probably ccsfms) and re-attach it. Should work fine the second time (same thing sometimes happens with the SIMS database too)
9th August 2008, 06:28 PM #15
Yes - boot off the CD and it will prompt you to convert an existing installation into a virtual machine. Of course you'll have taken a full backup first
Originally Posted by dhicks
No, you don't. The Xen server will be consoled and you'll do all the administration through the java management tool thing on another machine. From in that you can see what would be the console of the guest machine, and for most day-to-day stuff you'll use remote desktop anyway.
First question I have: do I need a GUI installed on my Xen server, or can I just log in to the virtual Windows server with remote desktop?
By Oops_my_bad in forum MIS Systems
Last Post: 26th October 2007, 09:18 PM
By tosca925 in forum Windows
Last Post: 16th September 2007, 02:16 PM
By broc in forum Hardware
Last Post: 2nd May 2007, 08:55 AM
By spc-rocket in forum Windows
Last Post: 5th November 2006, 04:35 PM
By ChrisH in forum Wireless Networks
Last Post: 5th December 2005, 12:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread