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!
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
D_Vante

8/22/2022 - Mon
yo_bee

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/
Qlemo

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.
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?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
yo_bee

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
Qlemo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Aaron Shilo

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
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.