October 17, 2018 at 3:58 am
Hey guys..
I have quick and urgent question.
I am wanting to upgrade our sql 2005 to 2008. In the sql 2005 we have encrypted stored procedures.
We don't have the source code for them. Can i just do an upgrade to sql 2008 without worrying about the encrypted sps and will still work fine and dandy.
Thanks
October 17, 2018 at 4:13 am
RinoaHeartily - Wednesday, October 17, 2018 3:58 AMHey guys..I have quick and urgent question.I am wanting to upgrade our sql 2005 to 2008. In the sql 2005 we have encrypted stored procedures.We don't have the source code for them. Can i just do an upgrade to sql 2008 without worrying about the encrypted sps and will still work fine and dandy.Thanks
Get Redgate's SQL Prompt - It will unencrypt them for you. Then you can save them in source control, and redeploy them to the new version.
But why upgrade to a 10-year old version of SQL, that is rapidly approaching End of Support - Jan 2020.
October 17, 2018 at 4:46 am
Thanks.. Without u encrypting them can the upgrade work? The reason it needs to be 2008 and. Not higher is because that's the last version it supports and we don't hvee the unencrypted sp because it's past of. Product
October 17, 2018 at 4:56 am
RinoaHeartily - Wednesday, October 17, 2018 4:46 AMThanks.. Without u encrypting them can the upgrade work? The reason it needs to be 2008 and. Not higher is because that's the last version it supports and we don't hvee the unencrypted sp because it's past of. Product
I'd suggest at least testing against a new version. SQL Server 2014+ developer edition are all available for free, and the evaluation copies are also free (for 180 days). If you have a product that only support SQL Server 2008 (or earlier) then you really need to start looking at updating that product too (for the same reason Des has already mentioned). Otherwise you're going to have to upgrade in a couple years again anyway; and then it just starts getting expensive.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 18, 2018 at 2:59 am
It'll work fine with the encrpyted procs, but you really need to be moving to something newer. 2008 is out of support, has been for a while now. Yell at the vendor and get them to support something released this decade.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2018 at 3:30 am
In fact, I said "a couple" of years earlier, but it's actually less that that. SQL Server 2008 is out of extended support in September of next year, which is less than a year away (I must have been thinking of Windows Server 2008, which is January 2020 (which still isn't far away)). If you were to "upgrade" to 2008, you'd still have to again in 10 months time.
Considering you are already completely out of support, and although it's not ideal, I would personally take a little longer to test against a much newer version of SQL Server. 2014 to 2017 introduced very few breaking changes. 2012 did introduce a few, though, however, the page in the documentation appear to have been removed (thanks Microsoft), so I can't find an official source on what was broken. You're not going to be able to go straight from 2005 to 2017 though; 2017 doesn't offer an upgrade path from 2005 as it was no longer supported. i think the latest version that does is 2014; so you might need to jump through a couple of hoops first.
What ever you choose, however, upgrading to 2008 is definitely the wrong choice here.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 18, 2018 at 3:35 am
Thom A - Thursday, October 18, 2018 3:30 AMIn fact, I said "a couple" of years earlier, but it's actually less that that. SQL Server 2008 is out of extended support in September of next year, which is less than a year away
Please note that extended support requires software assurance and additional payments made to MS for that support. It's not support for everyone.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2018 at 4:02 am
Thanks everyone for the valuable answers.
To cut things short. The product we have is running on windows 2003 with sql 2005. We need to exit 2003 by year end. That the reason why the 2008 upgrade we are buying time before we change the entire product to a modern one.
We need to do a quick one as time is running fast. I believe some of the sp are using deprecated functions or whatsnot and I really hope 2008 will work. That's one concern. The one other is the encrypted sp. I am glad I have the answer that we can simply dump and restore to a new version and it works.
Thanks everyone!!
October 18, 2018 at 4:12 am
GilaMonster - Thursday, October 18, 2018 3:35 AMThom A - Thursday, October 18, 2018 3:30 AMIn fact, I said "a couple" of years earlier, but it's actually less that that. SQL Server 2008 is out of extended support in September of next year, which is less than a year awayPlease note that extended support requires software assurance and additional payments made to MS for that support. It's not support for everyone.
True, but you do, at least, still get security updates.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply