I am not able to restore database (or attach) created in the upper version into lower version. What should I do?
I am not able to restore database (or attach) created in the upper version into lower version. What should I do?

The only way is to create a script for all objects and use the script to generate database.

  1. Login into your SQL management studio.
  1. Right click on your database – Tasks and click on Generate Scripts.
  2. Click on Next.
  3. Click on Next.
  4. Click on Advance.
  5. Select your required database version in dropdown list under ‘Script for SQL version’ option.
  1. Click on Next.
  1. Click on Next.
  2. Click on Next.
  3. Once process is complete you can restore this file into lower version of SQL database.

Ask a question

"Hey couldn't find what you were looking for in our knowledgebase? Please enter your question here".

First Name *
Last Name *
Email Address *
Question *
Captcha *