+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
MIS Systems Thread, Backup SIMS database from SQL Server 2005 to SQL Server 2008 R2 in Technical; Originally Posted by dtakias That's good news. In that case do we stick with 2008 and upgrade to R2 in ...
  1. #16
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Quote Originally Posted by dtakias View Post
    That's good news. In that case do we stick with 2008 and upgrade to R2 in a few months?
    Only the school can make that decision. Your problem now is that SQL 2005 is no longer supported with the recent Autumn Release of SIMS v7.136. If you are still on the Summer Release v7.132 then I would assume that you are ok!

  2. #17

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    Ok cool, thanks everyone. I will have a go tomorrow, when I get back to school.

  3. #18

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    I've just run SOLUS but cannot find the SIMSSQLInfrastructureSetup.exe file, although I did enable "check for infrastructure updates"



    Am I missing something ?

  4. #19

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    By looking at the root of ..\SIMS\Setups the only close file is SIMSInfrastructureSetup.exe and SIMSDocumentServerSetup.exe

  5. #20

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,355
    Thank Post
    679
    Thanked 2,276 Times in 1,051 Posts
    Blog Entries
    23
    Rep Power
    674
    you may need to contact your support team to release the infrastructure update... i had to request it to do the migration because our support team prefer to copy the files the manually for a fee.

  6. #21

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    Quote Originally Posted by Dos_Box View Post
    you may need to contact your support team to release the infrastructure update... i had to request it to do the migration because our support team prefer to copy the files the manually for a fee.
    Ok thanks. I managed to get the file now. As we need to migrate to a new Server, I have setup a new Server with Server 2008 R2 x64 and SQL Express 2008 x64 with SP2.

    Will attempt to migrate today after 3pm.

    The way I see it is:
    Stop SQL Server 2005 on current Server
    Run Backup routine and backup all databases
    Run SIMS-FMS SQL2008(Advanced Mode)
    Select SQL 2005 Database
    Select SQL 2008 Database
    Choose Redirection Service(Will that depend if I run one already?)
    Click on Migrate and wait.

    Other than that, will I need to move any files to the new Server?
    Since this will be a new Host, I guess I need to change the location of the SIMS instance under connect.ini ?

  7. #22

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    So after backing up the databases we run the migration on the new Server but couldn't get the clients to login.

    At the end, the problem was found by someone. The SQL Server Browser Service on SQL 2008 wasn't running in the background, hence clients were not able to login. We also applied the latest update and all seems well now.



SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] SIMS SQL 2005 --> 2008 migration
    By cookie_monster in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 03:24 PM
  2. Moving from SQL Server 2005 to 2008
    By speckytecky in forum MIS Systems
    Replies: 19
    Last Post: 9th July 2009, 04:34 PM
  3. SIMS SQL Server 2005 re-install
    By philserre in forum MIS Systems
    Replies: 6
    Last Post: 14th October 2008, 09:44 PM
  4. sims.net sql server 2005
    By itgeek in forum MIS Systems
    Replies: 2
    Last Post: 14th March 2008, 07:02 PM
  5. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 09:46 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
  •