Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Sql Server 2005 --> 2014 upgrade. Risks/etc...

Author  Topic 

jellybean
Starting Member

15 Posts

Posted - 2015-03-30 : 09:44:23
Hi,

Can you help me please? I have an upgrade to do from Sql-Server 2005 to Sql Server 2014.
I am trying to do a bit of preliminary risk analysis.

Firstly I would like to know how I would do the upgrade. Should I install 2014 on another box or the same box (or do I just upgrade over the 2005 version - which seems risky)? How do I transfer all of the objects from 2005 to 2014? I'm referring to the tables/sprocs/views/etc already on 2005?

Anything else I should consider? I'm referring to risks and stuff like functions that have been deprecated - things like that?

I would appreciate any comments/experiences that you would like to share.

Thanks in advance,
Jelly.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-03-31 : 01:54:31
I'd recommend you install the SQL Server 2014 on another box. In fact , you may find the OS you install on doesn't support both versions simultaneously.
One option is to do a straight backup from sql server 2005 and restore onto 2014.

You may need to consider a) identify any DTS which need to be converted to SSIS b) There is some software from Microsoft sql server upgrade advisor
c)Once you've done the migration you can analyse deprecated features using - http://www.sqlserver-dba.com/2014/07/find-sql-deprecated-features-with-sysdm_os_performance_counters.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2015-04-01 : 05:24:36
There is a thread here about upgrading to SQL 2008. Many of the issues are relevant to upgrading between any versions and/or will give you ideas of the sort of things to include in the upgrade procedure.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230
Go to Top of Page

jellybean
Starting Member

15 Posts

Posted - 2015-04-01 : 13:00:15
Thank you jackv & Kristen for your comments and references.
J.
Go to Top of Page

chuantiaya
Starting Member

3 Posts

Posted - 2015-04-14 : 04:46:35

Thanks for you sharing, i had learnt a lot,i don't know how to reply to u,maybe i just give u some exciting games websites for you [url=http://www.runescapemart.com/]RS3 Gold[/url] and [url=http://www.runescapemart.com/]Buy Runescape Gold[/url]
Go to Top of Page
   

- Advertisement -