>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.
>
>Any suggestion?

You only option will be to script the whole database. If you don't have lots of data in the tables, you can script with data.