Deprecated database functions in SQL 2016

Vote:
 

We ran Data Migration Assistant on a Episerver database (pretty much latest version, at least latest as of a month ago) and found that it is using a couple of things that are marked as deprecated in SQL Server 2016 and might be removed from SQL 2017.

The report looked like this:

Procedure

Object [dbo].[netConvertPropertyForPageType] uses the old style join syntax which can have poor performance at database compatibility level 90 and higher. For more details, please see: Line 287, Column 5.

An example of "Unqualified join" is

Select * from table1, table2
where table1.col1 = table2.col1

 

Use explicit JOIN syntax in all cases. SQL Server supports the below explicit joins:

  • LEFT OUTER JOIN or LEFT JOIN
  • RIGHT OUTER JOIN or RIGHT JOIN
  • FULL OUTER JOIN or FULL JOIN
  • INNER JOIN

 

Deprecated data types TEXT, IMAGE or NTEXT

 

Column

Object dbo.tblScheduledItem.InstanceData uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 15, Column 5.

#183334
Oct 11, 2017 13:57
Vote:
 

Thanks! I reported a bug to investigate this.

#183342
Oct 11, 2017 15:38
Vote:
 

This bug fix was released yesterday as part of EPiServer.CMS.Core 11.3.4 (update 203.)

#188660
Feb 28, 2018 15:55
Vote:
 

Great bob!

#188661
Feb 28, 2018 16:04
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.