…there are a few options that can help us to downgrade the database from a higher version of SQL Server to a lower version SQL Server. These options include:
- Generate Scripts wizard of SQL Server Management Studio
- SQL Server Integration Services
- Custom scripting and BCP
In this tip we will use the Generate Scripts wizard of SQL Server Management Studio.
Source: How to migrate a SQL Server database to a lower version