How can we help you today? How can we help you today?

Compare bewteen different SQL server versions

Can I use the compare and sync tool in order to compare between a database that is on SQL Server 2008 R2 and a database that is on SQL Server 2014?
can I sync the structure in both directions?
limor
0

Comments

3 comments

Sort by
  • Rob C
    Hi!

    Yes, you can compare between different version of SQL Server. When you deploy, SQL Compare will create a deployment script to work with the version of SQL Server that it is deploying to. One issue you might have is when you have new objects that are incompatible with the older version of SQL Server - in that case, SQL Compare will try and filter them out where possible. Sometimes it can't, for example if the newer-type object is a dependency of another object, and in that case you would need some manual intervention.

    I hope this helps.
    Rob C
    0
  • JSommers
    We have SQL Compare 10.7 and we would like to compare a SQL 2008 database to a SQL 2016 database. Should we be able to do that with this version?
    JSommers
    0
  • Tianjiao_Li
    Hi, thanks for getting in touch! We've made a support ticket for this so you will be contacted shortly.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.