>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?
A database as whole cannot be moved from higher version of SQL Server to lower. It's also a good idea to keep test server at the same version as production.
--sb--