>I have built a database that I need to deploy on a test server. My SQL Server is 2014. The test servers is 2008. So, of course, I get this message:
>
>"The database 'Something' cannot be opened because it is version 782. This server supports version 663 and earlier. A downgrade path is not supported."
>
>So, I went into my database and changed the compatibility level to 100. That did not help.
You can probably build the script to recreate the database, empty, on a lower level. If the new and old one can be connected somehow, you may insert into the new one from the old one, connecting to the 2014 server as a linked server, one table at a time.