April 5, 2017 at 1:55 am
Dear All
We have installed SQL express 2008 R2 version in my system (with without key of express edition).Now we are goiing to install SQL 2014 standard wit key in same system..Because of software installation and running system,we can't uninstall or format system for fresh installation .
Please guide how we can upgrade from SQL express 2008 R2 (without licenese key) to SQL standard 2014 (with licnese key)..??
Regards
Sidra
April 5, 2017 at 2:31 am
I'm not completely sure I understand the set up or the question.
If you're asking how to upgrade your databases from 2008 to 2014, the best approach is to backup the database on the 2008 system and then restore it to the 2014 system.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 5, 2017 at 2:50 am
Sir
I have installed SQL express 2008 R2 two months prior in my system.
Now i need to update this version to SQL 2014 standard (as I purchased new CD of SQL 2014 standard version) now.
What should i do to install SQL 2014 standard on same system.
I hope ,question is clear now?
April 5, 2017 at 3:28 am
Do you want both versions of the software running on the system? If so, install 2014 and provide a named instance (which is generally considered a good practice anyway) and they can run side-by-side. If you want to replace the 2008 instance, then back up your databases and run the setup. You can upgrade the instance in place. I'm not crazy about this approach, but it can work. A third option would be to back up your databases, install 2014 and provide the named instance, restore all your databases to the new 2014 instance, then uninstall 2008. One of these three approaches should do what you're looking for.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 5, 2017 at 4:02 am
Thanks for your reply.
I want go for 1st idea you suggested (creating new name instance) as i have several software depending on current istalled named instance.
For this new instance installation, i need to follow some special steps ??
April 5, 2017 at 4:31 am
Follow the documentation is the single best advice I can offer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply