I will be doing development work on a SQL Server 2008 database.
I am planning on buying a copy of SQL Server for this project. I am wanting to verify that the latest SQL Server version, 2014, won't cause any problems in the following scenario:
- Pull,(Backup) copy of database from 2008 (the source)
- Restore database to my local 2014
- Make changes
- Pull,(Backup) copy of database from 2014
- Restore over the existing 2008 database (which was the source) with the copy from 2014
I am aware that I won't be able to utilize any of the newer features that 2014 might offer that aren't available in 2008... I just want to know that it won't blow anything up.
NOTE: I don't have access to the SQL Server 2008 DB server right now... additionally I don't yet have the SQL Server 2014 software; I have SQL Server 2012 express.
I have an answer for this, just export as SQL statements (thanks to comments below). The better question is here