Restore Database To Lower Version in MSSQL

Description: Restore database from Higher Version of MSSQL to Lower Version
Procedure:

• Open SQL server management studio in 2014 [source Database Server]
• Right Click on Database > Tasks > Generate Script

• Click on Advanced

• Make 2 Changes
• Script for server Version : SQL Server 2008
• Types of data to script : Schema and data

• After completed open query in SQL management studio and change location of datadir and log file according destination database server and save file in .sql
• Open .sql file in destination server that will create database and migrate all data in new database server.