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!
JharrisonsnbsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

yo_beeDirector of Information TechnologyCommented:
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/
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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.
0
JharrisonsnbsAuthor Commented:
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?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

yo_beeDirector of Information TechnologyCommented:
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.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
My point is that you do not need to use 2008 (or 2012) software, unless you have something working very tightly with the server software - which is not the case I'm sure. The db compatibility level for each specific DB is what you "downgrade". That is , you are running a running  a 2014 DB, but some settings are set so you seem to run it on 2008.

If above does not work for you, you won't install 2014 if you are not to use it. If you have the media, you can just install 2008. If you don't have 2008 media, you can't.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Aaron ShiloChief Database ArchitectCommented:
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.
0
D_VanteCommented:
You can run the database in a compatibility level of 2008
Properties ->options
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.