There is no proper method of restore the database from upper version to lower version. However we can use below techniques to perform this task:
• Script out the database Objects and create these on the target database
• Use SQL Server Import Export Wizard to copy data from source server to destination server (only Data)
• Copy data to destination tables using BCP (only Data)
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment