October 19, 2011 at 8:28 am
I've had SQL Express installed for a little while and just got Developer edition. With everything closed I went for an upgrade and let the install run its course sticking with the default options it had chosen.
I've rebooted and connected to the local database which is where the SQL express DBs were and it seems they're still SQL express. Is there something I need to do to 'convert' this to a Developer instance or something? - I've got quite a few databases on the express server so to speak so it would be good if I didn't have to start from sratch and import all the DBs again!
Any help much appreciated 🙂 Thanks.
October 19, 2011 at 8:32 am
Were you upgrading from SQL Server Express 2005 to 2008 Dev? There is no upgrade path for 2005 Express to dev edition. Also, how are you determining that the "databases are still express?"
Thanks,
Jared
Jared
CE - Microsoft
October 19, 2011 at 8:35 am
Na, both are 2008, I installed Express about 4-5 months ago perhaps.
I right clicked on the database server (my local PC name) then properties. It said Product was MS SQL Server Express Edition with Advanced Services (64bit).
Bizarrely enough when writing a query in Management Studio on our main live database (nothing to do with the local install) Intellisense seems not to be working! gah!
October 19, 2011 at 8:44 am
Are the databases you are connecting to on your local machine, or on a server? Which machine has developer installed, the server or your local machine? i.e. The database engine hosting the databases needs to be upgraded, not your local machine unless the databases are on your local machine.
Thanks,
Jared
Jared
CE - Microsoft
October 19, 2011 at 8:46 am
jared-709193 (10/19/2011)
Are the databases you are connecting to on your local machine, or on a server? Which machine has developer installed, the server or your local machine? i.e. The database engine hosting the databases needs to be upgraded, not your local machine unless the databases are on your local machine.Thanks,
Jared
Also, after rereading your posts I assume they are ALL local. When you upgraded, did you select the proper instance or did you create a new one?
Thanks,
Jared
Jared
CE - Microsoft
October 19, 2011 at 8:50 am
My PC is acting as 'the server' in this situation and all of the databases are on my PC.
Via Management studio I also connect to an external SQL server with our live data on and an internal SQL server with some other databases on.
I don't recall selecting an instance, as I selected an upgrade I thought it would search everything available and if there were a choice of instances it would have asked which I'd want etc.
Do you think it's created a new one then rather than upgrading my current one?
October 19, 2011 at 8:53 am
That's what it sounds like to me. It should ask you which instance you want to upgrade during the installation/upgrade process.
Look at step 12 here. http://msdn.microsoft.com/en-us/library/ms144267.aspx
Thanks,
Jared
Jared
CE - Microsoft
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply