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.
| 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 |
|
|
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 |
 |
|
|
jellybean
Starting Member
15 Posts |
Posted - 2015-04-01 : 13:00:15
|
| Thank you jackv & Kristen for your comments and references.J. |
|
|
|
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] |
|
|
|
|
|
|
Sql Server 2005 --> 2014 upgrade. Risks/etc...