Install SQL 2005 Full over 2005 Express (other instances)
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.