Posts

Showing posts from August, 2019

Why Generated SQL Scripts from SQL SERVER 2017 is not compatible with SQL SERVER 2014

Image
There are couple of cases might be possible for this issue.One of the approach to overcome from this issue is ,Too generate script using SQL SERVER >Task>Generate Script... Wizard and selection of correct target database. If you are generating script from SQL SERVER 2017 which to be compatible with SQL SERVER 2014 then make sure that in Advanced Scripting Options for Script for Server Version SQL SERVER 2014 by default it sets SQL SERVER 2017. Images of Script for Server Version in SQL SERVER 2014 and 2017 Script file generated for Script for Server Version 2014 and Script for Server Version 2017