Migrating Data From MSSQL2016server to MSSQL2012server

1. Right click on Database and select Database > Tasks
2. Select Generate Scripts
3. Proceed with Next until it asks you to specify how the script should be saved or published
   1. Click Advanced to fine-tune your requirements
   2. Enable SQL Triggers, Indexes and Primary Key (Unique Key)
   3. Set script for Server version: SQL Server 2012
   4. Set types of data to script: Schema and Data
4. After fine-tuning, hit next to see a summary.
5. Click next to finish the job. Restore in the target database.