Compare bewteen different SQL server versions

limorlimor Posts: 2
edited January 25, 2016 5:36AM in SQL Compare 11
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?
Tagged:
· Share on Twitter

Comments

  • Rob CRob C Posts: 419 Gold 2
    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.
    Software Engineer
    Redgate Software
    · Share on Twitter
  • JSommersJSommers Posts: 2
    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?
    · Share on Twitter
  • Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Hi, thanks for getting in touch! We've made a support ticket for this so you will be contacted shortly.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.