Instructions for exporting SQL Server databases to .sql files to import on lower SQL Server versions

Currently when you want to import the .sql file exported from SQL server higher version will lead to an error so how to export .sql file from SQL server to a lower version, today BKNS will guide you to handle it. this problem.

Step 1: Open Microsoft SQL Server Management Studio 2014.

Step 2: Go to the correct DB of hosting.

Right click on your database -> Task -> Generate Scripts…

At tab Generate and Publish Scripts choose Next

You tick the box Script entire database and all database objects and press Next

At tab Set Scripting Options you click the button Advanced

At frame Advanced Scripting Options You set up as follows:

– Script for Server Version => Select the version of SQL Server you want to import

– Types of data to script => Scema and data

After setting, you press OK to close the window Advanced Scripting Options . At the window Set Scripting Options part File name You can fill in the location where you want to save the scripts file after exporting.