upgrade from SQL 2008 SP3 to SQL server 2014 with SP1

hi all,

may I know any reserved keyword developer to take care of their application, any checklist on upgrading SQL 2008 Sp3 to SQL server 2014 with SP1 reserved keyword list so that they know what they need to test if application still ok ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Muzafar MominCommented:
SQL Server 2014 Software Requirements

SQL Server 2014 also has a few software requirements beyond the base operating system. The primary software requirements are:

The .NET Framework 3.5 SP1 is required when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SSMS. This is not installed by the SQL Server setup process.
The .NET Framework 4.0. This is installed by the SQL Server setup process.
PowerShell 2.0 or higher is required if you have installed the database engine or SSMS.
The Windows Installer service must be running.
For more information about the prerequisites for installing SQL Server 2014 you can refer to Hardware and Software Requirements for Installing SQL Server 2014.

Upgrading Using the SQL Server Installation Wizard

http://sqlmag.com/sql-server-2014/migrating-sql-server-2014
marrowyungSenior Technical architecture (Data)Author Commented:
noon.

reserve keyword means what application has to modify before it runs good on new SQL server.
Vitor MontalvãoMSSQL Senior EngineerCommented:
reserve keyword means what application has to modify before it runs good on new SQL server.
If things are done properly you should have all the code in the SQL Server side (mainly functions and stored procedures) so the MSSQL 2014 Upgrade Advisor can verify the code and warn you about things that won't work if you migrate.

If you have SQL code in your application I don't think there's an utility that can check it for you, so the best thing to do is to create a development environment with the application working with a copy of the database migrated to MSSQL 2014. Then a complete test should be performed to guarantee that the application works properly with the new database version.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

marrowyungSenior Technical architecture (Data)Author Commented:
"If things are done properly you should have all the code in the SQL Server side (mainly functions and stored procedures) so the MSSQL 2014 Upgrade Advisor can verify the code and warn you about things that won't work if you migrate."

but we want to do it earlier and our SQL server 2014 server not here yet.

"If you have SQL code in your application I don't think there's an utility that can check it for you, so the best thing to do is to create a development environment with the application working with a copy of the database migrated to MSSQL 2014."

yes, this is another option. by the experience of MySQL upgrade, we need to have reserve keyboard and a test platform for developer to deploy the same code to test it .

"Then a complete test should be performed to guarantee that the application works properly with the new database version. "

what complete test you mean by this ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
but we want to do it earlier and our SQL server 2014 server not here yet.
You don't need to have MSSQL 2014 to run the Upgrade Advisor. Download it from here and run it against you MSSQL 2008 instance.

what complete test you mean by this ?
Means that you need to go through ALL options in you application so you don't miss nothing.
marrowyungSenior Technical architecture (Data)Author Commented:
"You don't need to have MSSQL 2014 to run the Upgrade Advisor. Download it from here and run it against you MSSQL 2008 instance."

ah,,, I just recall that you are doing this project, very good.  

"Means that you need to go through ALL options in you application so you don't miss nothing. "

basically setup a test platform and let them test it is already that, just open that and let then test it.
marrowyungSenior Technical architecture (Data)Author Commented:
so reserved keyword you mean no necessary ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
basically setup a test platform and let them test it is already that, just open that and let then test it.
Absolutely correct.

so reserved keyword you mean no necessary ?
I'm not sure if I understood the question. Can you give me examples of reserved keyword?
marrowyungSenior Technical architecture (Data)Author Commented:
"I'm not sure if I understood the question. Can you give me examples of reserved keyword? "

like which T-SQL function still exists on new version of SQL server, etc, so that their SP is not going to fail because they used some function depreciated.
Vitor MontalvãoMSSQL Senior EngineerCommented:
There's not much changings in T-SQL. Mostly new commands but you can see in the What's new on MSSQL 2012 and share this article with developers.

I didn't referred What's new on MSSQL 2014 in purpose because there you can see only new things related to MSSQL 2012 and not MSSQL 2008. Anyway, there's almost no changes from MSSQL 2012 to MSSQL 2014 in T-SQL area.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
but that one is not SQL 2014, right?

"Anyway, there's almost no changes from MSSQL 2012 to MSSQL 2014 in T-SQL area. "


that's why ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes and yes. Don't forget that What's New section it's always related to the last version, so you'll need to check first in MSSQL 2012 to be aware what's new from MSSQL 2008.
marrowyungSenior Technical architecture (Data)Author Commented:
"Yes and yes. Don't forget that What's New section it's always related to the last version, so you'll need to check first in MSSQL 2012 to be aware what's new from MSSQL 2008."

I am confused but that link only show up to SQL 2012, so we can only see any thing change up to 2012 from 2008 ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
I am confused but that link only show up to SQL 2012, so we can only see any thing change up to 2012 from 2008 ?
Correct. I also added in the same comment the link for What's new in MSSQL 2014 so you can compare.
marrowyungSenior Technical architecture (Data)Author Commented:
"I didn't referred What's new on MSSQL 2014 in purpose because there you can see only new things related to MSSQL 2012 and not MSSQL 2008. Anyway, there's almost no changes from MSSQL 2012 to MSSQL 2014 in T-SQL area."

but that one more on DBA side other than programmer side.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.