Link to home
Avatar of Jharrisonsnbs
Jharrisonsnbs

asked on

Can I downgrade SQL 2014 to SQL 2008?

I have legacy software that will only run on SQL 2008/2012. When purchasing SQL from MS they would only sell me SQL 2014. Can I downgrade the 2014 version to 2008? If so, can you please detail the process or provide me a link? Thanks in advance!
Avatar of yo_bee
yo_bee
Flag of United States of America image

From what I have read when I was looking to downgrade from Enterprise to Stander on the same version was that you cannot downgrade SQL that are a higher version then the SQL you want to go to like your situation.

Here is an article that might help you accomplish this.  
https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/
Yes, you can. Just install the lower release. But you cannot reuse the DB files, so if the DBs where already created in 2014, bad luck.

But if the issue is only with the database compatibility level, you can change that freely to 2012 or even earlier. That will only restrict from using new features, and keep some compatibilty settings set as earlier.
Avatar of Jharrisonsnbs
Jharrisonsnbs

ASKER

So just to clarify if I would install SQL 2014, roll back to 2008, then import the database into the 2008 instance I should be ok? If I were to install 2014, import the database then try to roll back to 2008 is where I would encounter issues correct?
You will most likely have errors since the DB's are tagged with 2014 Metadata.  I personally have not tried the method in the link, but from reading it I seems to be a solution.  You can also try importing the DB's in to a test 2008 server or try using the method in the Hyperlink to see if you can get a DB's online.
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
One option is third party tools: Red Gate's SQL Compare and SQL Data compare are very good for this sort of thing, and what we use internally. They will let you handle the data table by table, so that might help keep size down. Not sure if they any upper limits on size.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.