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

Now, copy newly generated script to destination Server. If script is small (less then < 20MB), you can directly open it in SQL Server Management Studio and execute it. However, if script size is large, you must use sqlcmd utility to execute it. SQLCMD is a utility which allows us to execute T-SQL statements, script files, stored procedures from the command line.

Open Command Prompt (cmd) with Administrator Privileges (Or right click at cmd and select ‘Run As Administrator’). Run following command:

You can also specify database username and password.