+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 36
MIS Systems Thread, Moving SIMS to new server in Technical; I want to move our SIMS to a new server as the old server is so old and slow. Also ...
  1. #1

    Join Date
    May 2007
    Location
    North Yorkshire
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Moving SIMS to new server

    I want to move our SIMS to a new server as the old server is so old and slow. Also will be replacing my SIMS workstations, so basically, starting from scratch. I've done this before when SQL version was 2005 following excellent instruction from | SiX | Somerset Internet Exchange |. The existing server has recently been upgraded to SQL2008 so can't use these notes. I've tried in a test enviroment to setup but getting errors on the DBattach phase - Error ASSEMBLY dznet Does not exist, Please Run SIMSSQLApplicationSetup.exe.

    I've started off by running the SIMS-FMS SQL2008.exe file, followed on screen prompts and changed the path to f:\program files\microsoft sql server etc.

    Anyone done a move to new server using sql2008 and can point me in the right direction.

    Thanks.

  2. #2

    Join Date
    May 2007
    Location
    North Yorkshire
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Jumped the gun a little, found the updated info !

    Here for anyone else who needs to do it !

    http://www.six.somerset.gov.uk/sixv3....asp?did=24645

  3. #3

    Join Date
    May 2007
    Location
    North Yorkshire
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Just confirming the above instructions do work ! Done a succesful migration today. Excellent guide !

  4. #4

    Join Date
    Jan 2010
    Location
    Slough
    Posts
    108
    Thank Post
    21
    Thanked 4 Times in 4 Posts
    Rep Power
    20
    Hi
    I am just moving SIMS to a SQL 2012 server and am getting a similar error.
    The link above doesnt work any more - does anyone have a clue?

    Cheers!

  5. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by mtillbrook View Post
    Hi
    I am just moving SIMS to a SQL 2012 server and am getting a similar error.
    The link above doesnt work any more - does anyone have a clue?

    Cheers!
    Nice to see that our documents were securely locked down back then!!!!

    @mtillbrook - I guess your migrating juts SIMS .net and FMS?

  6. #6
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,213
    Thank Post
    597
    Thanked 155 Times in 141 Posts
    Blog Entries
    78
    Rep Power
    80
    Not sure on the SQL version compat with current sims versions. I think there is a similar thread about this too... @vikpaw?

  7. #7
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    SIMS and FMS are now supported on SQL 2012 since the SIMS Autumn release if migrated across manually. However, both SIMS AND FMS HAVEto be on the same SQL version.

    SOLUS3 and Discover are not yet supported on SQL2012.

  8. Thanks to Rawns from:

    vikpaw (10th February 2013)

  9. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Quote Originally Posted by Rawns View Post
    SOLUS3 and Discover are not yet supported on SQL2012.
    Been told it's because the SOLUS3 and Discover use VSDBCMD to deploy\upgrade the SQL database, which doesn't support SQL 2012 and it's replacement, SSDT, doesn't work with XP\2003 - which explains why they've holding off till they drop xp\2003 support for servers. Shame they didn't do what they did with SIMS and keep the application and database logic separate.

  10. 2 Thanks to matt40k:

    Rawns (21st May 2013), zag (21st May 2013)

  11. #9

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We are just setting up a new SQL 2008 R2 Server I did a restore of the SIMS db but it does not show the security/roles within SQL how do I get this to be brought across as I want to test a workstation on the new test Server.

  12. #10
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Sounds like they were not transferred before the backup. When we do a backup, we run these commands first to make sure they are included in the backup:

    osql –S127.0.0.1\sims2008 -E -n -Q"exec sims.sims.db_p_transfer_login"

    osql –S127.0.0.1\sims2008 -E -n -Q"exec ccsfms.sims.db_p_transfer_login"

    Also, when we migrate SIMS to a new server, we run these commands, detach the database and copy it across, then re-attach it. We don't restore from a backup.

  13. #11

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    It comes up with osql does not support all features of SQL Server 2008 R2. Use sqlcmd instead.?
    Last edited by whitejames; 21st May 2013 at 01:12 PM.

  14. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,850
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    detaching and reattaching on the existing server, will copy the logins / credentials into the db (like those transfer logins scripts). you can then take a .bak file over elsewhere and restore it. restore then pushes them back and makes them usable. i hate detaching the live server though, just in case it doesn't reattach.
    Last edited by vikpaw; 21st May 2013 at 01:22 PM. Reason: add clarity on logins

  15. #13

    Join Date
    May 2013
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks @vikpaw I will try this later today will have to kick users off to do this.

  16. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,850
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I did have a CR that asked for command line options to run those stored procedures from dbattach, but it got spring cleaned!
    If you have sql management studio, you might be able to run it from there.

  17. #15

    Join Date
    Apr 2007
    Posts
    55
    Thank Post
    9
    Thanked 4 Times in 4 Posts
    Rep Power
    15
    Quote Originally Posted by vikpaw View Post
    detaching and reattaching on the existing server, will copy the logins / credentials into the db (like those transfer logins scripts). you can then take a .bak file over elsewhere and restore it. restore then pushes them back and makes them usable. i hate detaching the live server though, just in case it doesn't reattach.
    So you could just detach the database from the existing server, this will transfer the logins into the SIMS.mdf file, then attach the database on the new server and it will bring over all the SIMS logons? Does this work the same with the FMS database too?

SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. Moving SIMS Server to new machine
    By joshd in forum MIS Systems
    Replies: 8
    Last Post: 24th October 2010, 04:29 PM
  2. Moving sims from 32bit to 64bit server
    By ful56_uk in forum MIS Systems
    Replies: 6
    Last Post: 11th October 2010, 10:41 AM
  3. Moving to new SIMS 64bit server
    By mattstevenson2005 in forum MIS Systems
    Replies: 4
    Last Post: 16th July 2009, 02:05 PM
  4. Moving SIMS\FMS to a new server
    By matt40k in forum MIS Systems
    Replies: 2
    Last Post: 22nd August 2008, 07:58 PM
  5. Moving SIMS to a new server
    By jasonb007 in forum MIS Systems
    Replies: 3
    Last Post: 16th May 2007, 10:38 AM

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
  •