Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Downgrading from 2016 to 2014 with redgate?

SergiomSergiom Posts: 2
edited December 6, 2016 10:01AM in SQL Prompt
I'm sorry if this is miscategorized.

I have a large (45gb) database which is running on SQL 2016 Beta server which will soon expire. I also have SQL 2014 installed as a separate instance. The issue is that I cannot directly downgrade by detaching/attaching the db. Separately new features exist on 2016 such that generating the export creates errors upon import because SQL 2014 doesn't even know what some of those features mean.

Can any of redgate's tools help me to do this? I was told that this is the software to look into, but I'm not sure where to start.

Comments

  • Hi,

    If you're not using any of the new SQL 2016 features then you ought to be able to use our tools to copy the database to your SQL Server 2014 instance. Firstly, you'll need to use SQL Compare to create a new database on your 2014 instance and copy all of the database objects across. Then finally you'll need SQL Data Compare to copy the data across.

    If you are using some SQL Server 2016 features then copying the database across might require some manual intervention.
    Software Engineer
    Redgate Software
Sign In or Register to comment.