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?