Import backup ,upper version to lower version in SQL server

Hi Dipak,

 

You need to generate script for your latest version sql server and then you can run your back up script in lower version of sql.

Please find below link which will help you to resolve your query.

 

https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/

 

if you have latest version of SQL then first generate script in latest version with above link and create db in lower version. 

Scritig is the est way

https://www.sqlserverlogexplorer.com/migrating-database-to-lower-version/ 

This is not possible although you can generate script on the higher version and that script can be run in the lower version of SQL Server. Remeber, this will also not work 100% as expected in some situations.

 

You can read the following answer on SO

 

https://stackoverflow.com/questions/6183139/sql-server-database-backup-restore-on-lower-version