how to change version of sql that scripts are created for

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
jspano
Posts: 2
Joined: Thu 01 May 2014 18:34

how to change version of sql that scripts are created for

Post by jspano » Wed 19 Jun 2019 14:51

how do you change the version of sql that scripts are generated for?
In ssms you could specify the version of sql to script for.
For instance, this script:
DROP VIEW IF EXISTS dbo.myview
doesn't run in sql 2014, only 17.
a lot of our clients are still on 14 and it would fail. I need an option to make the scripts generated work in 14 (or 12 or 8 etc)

Thanks

alexa

Re: how to change version of sql that scripts are created for

Post by alexa » Thu 20 Jun 2019 14:24

There is no such a possibility in dbForge.

Post Reply