<div>
SQL Server 2014 Software Requirements<br />
<br />
SQL Server 2014 also has a few software requirements beyond the base operating system. The primary software requirements are:<br />
<br />
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.<br />
The .NET Framework 4.0. This is installed by the SQL Server setup process.<br />
PowerShell 2.0 or higher is required if you have installed the database engine or SSMS.<br />
The Windows Installer service must be running.<br />
For more information about the prerequisites for installing SQL Server 2014 you can refer to Hardware and Software Requirements for Installing SQL Server 2014.<br />
<br />
Upgrading Using the SQL Server Installation Wizard<br />
<br />
<a href="http://sqlmag.com/sql-server-2014/migrating-sql-server-2014" rel="ugc">http://sqlmag.com/sql-server-2014/migrating-sql-server-2014</a>
</div>


<div>
noon.<br />
<br />
reserve keyword means what application has to modify before it runs good on new SQL server.
</div>


<div>
<blockquote>
reserve keyword means what application has to modify before it runs good on new SQL server.
</blockquote>
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.<br />
<br />
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.
</div>


<div>
&quot;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.&quot;<br />
<br />
but we want to do it earlier and our SQL server 2014 server not here yet.<br />
<br />
&quot;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.&quot;<br />
<br />
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 .<br />
<br />
&quot;Then a complete test should be performed to guarantee that the application works properly with the new database version. &quot;<br />
<br />
what complete test you mean by this ?
</div>


<div>
<blockquote>
but we want to do it earlier and our SQL server 2014 server not here yet.
</blockquote>
You don't need to have MSSQL 2014 to run the Upgrade Advisor. Download it from <a href="https://www.microsoft.com/en-us/download/details.aspx?id=42295" rel="ugc">here</a> and run it against you MSSQL 2008 instance.<br />
<br />

<blockquote>
what complete test you mean by this ? 
</blockquote>
Means that you need to go through ALL options in you application so you don't miss nothing.
</div>


<div>
&quot;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.&quot;<br />
<br />
ah,,, I just recall that you are doing this project, very good. &nbsp; <br />
<br />
&quot;Means that you need to go through ALL options in you application so you don't miss nothing. &quot;<br />
<br />
basically setup a test platform and let them test it is already that, just open that and let then test it.
</div>


<div>
so reserved keyword you mean no necessary ?
</div>


<div>
<blockquote>
basically setup a test platform and let them test it is already that, just open that and let then test it. 
</blockquote>
Absolutely correct.<br />
<br />

<blockquote>
so reserved keyword you mean no necessary ? 
</blockquote>
I'm not sure if I understood the question. Can you give me examples of reserved keyword?
</div>


<div>
&quot;I'm not sure if I understood the question. Can you give me examples of reserved keyword? &quot;<br />
<br />
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.
</div>


<div>
but that one is not SQL 2014, right?<br />
<br />
&quot;Anyway, there's almost no changes from MSSQL 2012 to MSSQL 2014 in T-SQL area. &quot;<br />
<br />
<br />
that's why ?
</div>


<div>
Yes and yes. Don't forget that <i>What's New</i> 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.
</div>


<div>
&quot;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.&quot;<br />
<br />
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 ?
</div>


<div>
<blockquote>
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 ? 
</blockquote>
Correct. I also added in the same comment the link for What's new in MSSQL 2014 so you can compare.
</div>


<div>
&quot;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.&quot;<br />
<br />
but that one more on DBA side other than programmer side.
</div>


<div>
<div class="content wysiwyg-content">
hi all,<br />
<br />
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 ?
</div>
</div>


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 ?

upgrade from SQL 2008 SP3 to SQL server 2014 with SP1

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.