How to migrate a MS SQL Server database to a lower version

Solution 1

Generate a script of schema and data using ssms "generate scipts" option

Solution 2

Generate a script of schema using ssms "generate scipts" option

Use data compare wizard is data is too big