asked
Database compatablilty
We have implemented our software in SQL server 2008 r2 Standard DB. Client has bought Sql server 2014 standard. I believe r2 will work on 2014. But I am not aware whats the difference between them and whether our application will work smoothly with out any issues. Please Assist me on this.
I would advice you to go through [What's new in SQL Server 2014][1] to understand the differences. [1]:
https://msdn.microsoft.com/en-us/library/bb500435(v=sql.120).aspx
There is no problem if you continue, in my opinion. But since client has already bought SQL server 2014, it shall be better to upgrade soon.
This web site runs by votes. For all the helpful answers below, please indicate this by clicking on the thumbs up next to each of those answers. If any one answer lead to a solution, please indicate this by clicking the check mark next to that answer.
Thank you'll for the assistance. I have few doubts on the above suggestions. We haven't used anything which is depricated in future versions. We are not using any advanced features of sql server. We are just manipulating the data and saving the data. Even if put the db on 2014 then we can generate the scripts from 2014 and run it on 2008 r2 incase of data issue and for testing. Please correct if we are still not recommended to follow this.
Compatibility forward from 2008R2 to 2014 for most database behaviors will be fine. You can back up a 2008R2 database and restore it to 2014. However, there are differences. Looking at the What's new documentation can help. It really depends on what you're implementing for your clients. Probably the best thing to do would be to upgrade yourself so that you can properly support them.
And - crucially - if your customer had a data-related issue, you wouldn't be able to restore a backup of their 2014 database onto your 2008R2 server. You could always use a Developer Edition for that but it's a consideration. You would want a solution ready for this situation, in my opinion.
16 People are following this question.
