title: Using the same database on different versions of SQL Server
body: <p>We have several SQL Server databases at work and we plan to keep all of them in a Database Server. However, while we use SQL Server 2014 in some of the databases, there is also a database (let's say ABC) with the version of SQL Server 2008 R2. </p>
  
  <p>The problem is that; ABC is a database originated from another company and sometimes it is updated by them using scripts, etc. So, this means that we have to go together with the version they use. As far as I know, it is possible to restore a database of version 2008 R2 in the version of 2014 but the reverse operation is not possible (to restore a database of version 2014 in the version of 2008 R2). </p>
  
  <p>So, in that case what is the best way to solve this problem by using the single database (SQL Server 2014) on the same server? </p>