Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [deprecation]

Use this tag for questions about features that are being deprecated (superseded) and how to replace those features.

Deprecated features are discouraged from use, typically because they will be removed from some future version of the product.

Wikipedia contains a great article on deprecation here.

6 questions
5
votes
3 answers

Is findOne() in mongoDB deprecated

Is findOne() in MongoDB deprecated? I am asking this because when I use findOne() in WebStorm the IDE puts a line through findOne() and gives a message saying findOne() is deprecated and to find substitute. I looked in the MongoDB documentation to…
Tim
  • 153
  • 1
  • 5
3
votes
1 answer

List of deprecated features for PostgreSQL 8 to 13

I'm going to upgrade several PostgreSQL 8 databases to version 13. The people I work for come from SQL Server. I've been looking for a tool similar to "DMA", specifically the part that lists deprecated features and "breaking changes". They want a…
Jesús Reyes Landeros
  • 33
  • 1
  • 5
3
votes
2 answers

MySQL 8 - user variables within expressions is deprecated [UDF calls with lot of parameters]

I have this: SELECT @foo1 := UDF1(0, a, b, c, d) AS Foo1, @foo2 := UDF1(1, a, b, c, d) AS Foo2, @foo3 := UDF1(2, a, b, c, d) AS Foo3, @foo4 := UDF1(3, a, b, c, d) AS Foo4, @foo5 := UDF2( @foo1, @foo2, @foo3, @foo4) AS Foo5, @foo6…
Peter VARGA
  • 779
  • 1
  • 8
  • 16
2
votes
2 answers

SQL Server 2016 deprecation of DML keyword ROWGUIDCOL

I just found out that the DML keyword ROWGUIDCOL is deprecated, replacement is $rowguid; and that DML IDENTITYCOL keyword is deprecated, new name is $identity. I don't understand why a non-variable (no dollar sign symbol) DML can be replaced with…
Warren P
  • 1,087
  • 2
  • 14
  • 24
0
votes
2 answers

Do deprecated features matter when changing compatibility level?

On my SQL Server 2019 machine, I have a database that is running on the lowest supported compatibility level (I believe that's equivalent to SQL Server 2008). I want to switch it to the very highest. Do I need to check for deprecated features…
J. Mini
  • 1,161
  • 8
  • 32
0
votes
3 answers

Deprecated raiserror detection

I want to upgrade SQL server from 2008 to 2014 versiyon. I checked all of the deprecated features including raiserror syntax. But I have many stored procedures to check. Some of them use new syntax, some of them use old syntax and I need to alter…
Banu Akkus
  • 389
  • 1
  • 3
  • 11