+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Migrating sims to new server in Technical; Hi I have looked through previous post but cannot find what i'm looking for. We are going to be moving ...
  1. #1
    rckngslnd's Avatar
    Join Date
    Nov 2010
    Location
    Margate
    Posts
    47
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Migrating sims to new server

    Hi

    I have looked through previous post but cannot find what i'm looking for. We are going to be moving to a new server 2008 with sql server 2008 64bit. Has anyone got a really good guide for installation, also i heard people talking about installing sim using an upto date iso, i looked on supportnet but could not find what i'm looking for.

    Any info would be great

    Richard

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Well we're waiting for the Spring 12 installable release at the moment, pretty much that would give you the new install, then you just backup\restore the databases and copy of the docstorage and the sims directories. Change the connect.ini and maybe the sims.ini on the workstations to point to the new server and your away.

    My advise would be to contact your local authority if you get support via them. Each LA has a slightly different way of doing things - Suffolk certain paths are needed to send stuff via AnyComms so it's worth asking rather then it you doing a non-LA standard way, ok SIMS may work, but the bills might not get paid this month - and more importantly the staff might not get paid!! If your independent or whatever, then yer, do whatever.

  3. #3
    maestromasada's Avatar
    Join Date
    Apr 2009
    Posts
    166
    Thank Post
    93
    Thanked 14 Times in 13 Posts
    Rep Power
    13
    get on a virtual machine your new server 2008 plus sql08 64-bit, so you can have a test enviroment to test the migration. Once you got the vm ready copy the mis folder and run the sims installation setup from the setups folder, then use dbattach to attach the .mdf database to the new system.

    Trickin long way, but it worked for us. Using VM machines you can test again and again how the migration will behave as close to the real envirionment as possible. Just be sure you don't touch the production server until you know exactly, exactly what you are doing. Alternatively, contact you support dealer as Matt suggested.

    Good luck!

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    There are many threads that cover it here, what exactly do you need or have you not been able to find? e.g. regarding a test install : SIMS Server Install Guide

    Go with a VM if possible.
    Clean install windows + SQL then fully patch.
    There are lists on here regarding which elements of SQL you need to install.
    Heed when SQL tells you to open up the right ports on server firewall.
    Ask for the installable ISO from support / Capita / SupportNet, or use the old one, KB110102 - and then use the latest Spring Upgrade iso to bring it up to date.
    restore data.
    configure.
    backup.
    test.


  5. #5


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,033 Times in 813 Posts
    Rep Power
    341
    I also need to get this done (over summer). What is the recommended space requirements, esp for document store?

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    For doc store It depends how much you use it.
    Mine is close to 7GB now over last 3/4 years but it has probably double in the last year.
    it's just a folder on a drive / share so you could move it of required. I would probably allow 20GB if you're starting out.
    system partition needs at lead 80gb these days.
    Data a couple of hundred at the least. I store my data (sims share, doc store and backups) in one drive. The more backups you want to keep handy the more space you'll need, even if you're using Matt's TidyBackups.

  7. #7

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 418 Times in 338 Posts
    Blog Entries
    8
    Rep Power
    191
    Quote Originally Posted by vikpaw View Post
    There are many threads that cover it here, what exactly do you need or have you not been able to find? e.g. regarding a test install : SIMS Server Install Guide

    Go with a VM if possible.
    Clean install windows + SQL then fully patch.
    There are lists on here regarding which elements of SQL you need to install.
    Heed when SQL tells you to open up the right ports on server firewall.
    Ask for the installable ISO from support / Capita / SupportNet, or use the old one, KB110102 - and then use the latest Spring Upgrade iso to bring it up to date.
    restore data.
    configure.
    backup.
    test.

    Vik, just interested to know if this document is born out of the one I sent you many many MANY moons ago?

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    We normally say 40gb for OS, 100gb+ for data, a page file drive (upto twice the size of ram) and ideally a drive for backups

    Graham I thought you were going to say how easy it is to move to another MIS

  9. #9


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,033 Times in 813 Posts
    Rep Power
    341
    Thanks both. When you say it's just a share - could I store on a different server? I'd like to de-dupe our shared drives so it would be good to add this one to the mix.

  10. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    @GREED - not so much anymore, the process is a little simplified now. Fundamentally, advocating a VM, using a clean install rather than the exisiting setups folder which tends to be messy. Restoring the backup, rather than detach/reattach and having to mess with logins or anything.
    Nonetheless, your document would still work.

  11. #11

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 418 Times in 338 Posts
    Blog Entries
    8
    Rep Power
    191
    Quote Originally Posted by vikpaw View Post
    @GREED - not so much anymore, the process is a little simplified now. Fundamentally, advocating a VM, using a clean install rather than the exisiting setups folder which tends to be messy. Restoring the backup, rather than detach/reattach and having to mess with logins or anything.
    Nonetheless, your document would still work.
    This was more a nostalgia thing! But interesting to know how things progress

  12. #12

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 418 Times in 338 Posts
    Blog Entries
    8
    Rep Power
    191
    Quote Originally Posted by matt40k View Post
    Graham I thought you were going to say how easy it is to move to another MIS
    Simply put, it is! For the customers. For most suppliers it is seamless from the data perspective



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Moving SIMS to new server
    By jasonb007 in forum MIS Systems
    Replies: 35
    Last Post: 10th June 2013, 01:27 PM
  2. [SIMS] Transfer SIMS to new Server
    By fiza in forum MIS Systems
    Replies: 12
    Last Post: 20th July 2011, 07:18 PM
  3. Migrating files to new server using DFS - is this correct?
    By iSteve in forum Windows Server 2008
    Replies: 2
    Last Post: 12th July 2011, 01:42 PM
  4. [SIMS] move sims to new server
    By ful56_uk in forum MIS Systems
    Replies: 11
    Last Post: 2nd March 2011, 10:03 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •