+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Install SQL 2005 Full over 2005 Express (other instances) in Technical; Hi, I'm looking for a bit of advice and reassurance. I'm just wondering if there will be any problems upgrading ...
  1. #1
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,043
    Thank Post
    68
    Thanked 75 Times in 59 Posts
    Rep Power
    34

    Install SQL 2005 Full over 2005 Express (other instances)

    Hi,

    I'm looking for a bit of advice and reassurance.

    I'm just wondering if there will be any problems upgrading SQL 2005 Express to full SQL 2005 for our SIMS server if there is another piece of software using SQL Express as well. We have Schools Cash Office & Lettings software (BPR Solutions) that shares the same server. Both SIMS and the BPR Solutions packages show in the SQL Server Service Manager.

    Will they both move over or can I select just to migrate SIMS? I don't want to start on this in case it all goes pear shaped because of this and I get to a point of no return before I find out.

    Looking thorough the SIMS documentation for upgrading it suggests that you can move just the SIMS database over but doesn't say if full SQL and Express will work happily together. I suspect they will but would like confirmation.

    Cheers

    HBJB

  2. #2

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55
    The upgrade process should find all your current instances and ask you if you want to upgrade them. Run the SQL install from the command line and use the SKUUPGRADE=1 switch (e.g. d:\setup.exe SKUUPGRADE=1).

  3. Thanks to timzim from:

    Heebeejeebee (7th April 2009)

  4. #3
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,043
    Thank Post
    68
    Thanked 75 Times in 59 Posts
    Rep Power
    34
    Cheers,

    If I decline the update it'll still work with 2005 Express then (?). My main concern is that the one that I want left alone will be borked up.

    HBJB

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    Depends, I assume you have two instances of MSSQL, ie two copies. I think if you do it write it should be ok as they are independ. I'm not sure tho, so I would defo make a full system backup first.

    Maybe make a VM image of the server then try it on the VM first.

  6. #5

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55
    Quote Originally Posted by Heebeejeebee View Post
    If I decline the update it'll still work with 2005 Express then (?). My main concern is that the one that I want left alone will be borked up.
    Not sure you can have two different editions of SQL 2005 on the same machine. You'll get more functionality (and won't lose any) with Standard Edition than with Express so you might as well upgrade all your instances. See here for more details. As long as you do a thorough backup first (and/or run on a test server as suggested above) you shouldn't have a problem.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS SQL Server 2005 re-install
    By philserre in forum MIS Systems
    Replies: 6
    Last Post: 14th October 2008, 08:44 PM
  2. SQL Query Using Full Text Engine inSQL 2005
    By Phanikumar in forum Web Development
    Replies: 0
    Last Post: 22nd September 2008, 08:47 AM
  3. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 02:56 PM
  4. Not enough space for SQL server 2005 install
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 10th October 2007, 08:02 AM
  5. ...Install MS SQL 2005 and Veritas Backup Exec??
    By LordGrey in forum How do you do....it?
    Replies: 3
    Last Post: 27th September 2006, 05:44 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
  •