+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Moving SIMS to Server 2008 R2 from Server 2003 in Technical; I need to move to a new server (2008R2) and currently have SIMS installed on 2k3 with SQL 2008 R2. ...
  1. #1

    Join Date
    Jul 2013
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Moving SIMS to Server 2008 R2 from Server 2003

    I need to move to a new server (2008R2) and currently have SIMS installed on 2k3 with SQL 2008 R2. I've seen a few KB articles and grasp that i need to copy the SIMS folder then run SIMSINST (i've done it a while ago on a laptop for test purposes just using sql express) but what I would like is a step by step guide including the SQL 2008 R2 config followed by SIMS.

    I'm sure many of you will have done it before i was just hoping one of you had a good complete guide!

    Cheers

    Sam

  2. #2

    Join Date
    Nov 2011
    Location
    Rayleigh
    Posts
    122
    Thank Post
    23
    Thanked 21 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    9
    We are buying in the services of SBS as they have experience in performing this process and we don't. It also means it's one less thing to worry about...

  3. #3
    chazzy2501's Avatar
    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,806
    Thank Post
    215
    Thanked 266 Times in 216 Posts
    Rep Power
    68
    you build a new sims server then move the database. alter the connect.ini to point to the new server and on the clients alter their sims.ini with the new install path (for upgrades)

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    There are quite a lot of threads on the subject. Best to look at those .
    I would recommend asking for the installable ISO from your support team as setups folders can be very out of date, even if you update SIMS regularly.

  5. #5
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    952
    Thank Post
    37
    Thanked 167 Times in 134 Posts
    Rep Power
    95
    I have a doc I wrote for doing this if you want. Happy to send to you if you can PM me details.

  6. #6

    Join Date
    Jul 2013
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I think my problem may be with my setups folder as i,'m getting the error 'error assembly dznet does not exist, please run simssqlapplicationsetup.exe...' When I try to attach a DB. Even after running it I still great the error. Will try to get iso from support team if they'll give me it!!

  7. #7

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,224
    Thank Post
    374
    Thanked 380 Times in 338 Posts
    Rep Power
    148
    Is their any reason why your looking to move to Server 2008 rather than 2012? Is may save you a job in 2 to 3 years time if you needed to upgrade again.

  8. #8

    Join Date
    Jul 2013
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Not really just that most of my other servers are on 2008. Is sims supported on 2012 and can I use SQL 2008 r2?

  9. #9

    Join Date
    Jun 2009
    Location
    Kent
    Posts
    20
    Thank Post
    8
    Thanked 3 Times in 3 Posts
    Rep Power
    11
    Quote Originally Posted by Bigs1312 View Post
    Not really just that most of my other servers are on 2008. Is sims supported on 2012 and can I use SQL 2008 r2?
    I wouldn't bother with SQL2008 now as support will be ending and require a change to SQL2012 fairly shortly.

    The bad news is with SQL2012 that if you were using the per processor licensing model that Microsoft have now changed this to per core instead.

  10. #10
    wingmanatl's Avatar
    Join Date
    Jul 2013
    Location
    Grand Cayman, Cayman Islands
    Posts
    11
    Thank Post
    6
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Bigs1312 View Post
    Not really just that most of my other servers are on 2008. Is sims supported on 2012 and can I use SQL 2008 r2?

    SIMS is supported on 2012. Just completed an install this afternoon.

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    You can use SQL 2008 R2 and the latest release should have migration instructions to port to SQL 2012. I'd go for 2012 unless you want the backwards compatibility with the old system while you migrate.

SHARE:
+ Post New Thread

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
  •