Home / Computer & Internet / Microsoft SQL Server / How to downgrade SQL Server 2017 database to SQL Server 2005/2008/2012/2014/2016
SQL Server Logo

How to downgrade SQL Server 2017 database to SQL Server 2005/2008/2012/2014/2016

Advanced Scripting Options let you select Server version for which you want to generate script. Select your destination Server’s version from “Script for Server Version” drop-down list. Make sure you also select ” Schema and data” from “Types of data to script” drop-down list. Click OK then Next button to proceed to next step.

Generate and Publish Scripts Wizard will now create T-SQL script for entire database objects and save at given location.Upon successful script generation, you will see “Success” written against all database objects.