Database backup restore on lower version in SQL Server
How to restore a higher version SQL Server database
backup file onto a lower version SQL Server?
Script generation - Tasks -> Generate Scripts.
Make sure you set the desired target SQL Server version on the Set Scripting
Options -> Advanced page. You can also choose whether to copy schema,
data, or both.
select "Schema
and Data" - if you want to Take both the things into the Backup
script file
select
Schema Only - if the only schema is needed.
Note that in the generated script, you may need to
change the DATA folder for the mdf/ldf files if moving from non-express to
express or vice versa.
Database backup restore on lower version in SQL Server
Reviewed by NEERAJ SRIVASTAVA
on
2:21:00 PM
Rating:
No comments: