March 17, 2020 at 1:46 pm
Hi,
I got a requirement to downgrade Standard 2017 to SQL 2014.
What is the procedure to downgrade?
Thanks,
Jo
March 17, 2020 at 2:54 pm
may we ask the reason for downgrading ? - could it be something settled by a compatibility mode setting?
as far as I can see - a downgrade is a complete uninstall and re-install.. but there are other issues. you databases will be set to run on 2017 and if this is anything like when we moved from 2000 to 2005 then you can't restore to an older version (the database version has been upgraded)
the only thing i can see (if you absolutely must downgrade) is to build a new server and use a data transfer tool to move the data to the new server... but again, why?
MVDBA
March 17, 2020 at 3:20 pm
may we ask the reason for downgrading ? - could it be something settled by a compatibility mode setting?
as far as I can see - a downgrade is a complete uninstall and re-install.. but there are other issues. you databases will be set to run on 2017 and if this is anything like when we moved from 2000 to 2005 then you can't restore to an older version (the database version has been upgraded)
the only thing i can see (if you absolutely must downgrade) is to build a new server and use a data transfer tool to move the data to the new server... but again, why?
I must confess that I'm very curious here, why the downgrade requirement?
😎
Is it licensing, 3rd party requirements etc?
March 17, 2020 at 4:19 pm
I wonder if a .BACPAC export would be a possibility? According to https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/dac-support-for-sql-server-objects-and-versions?view=sql-server-2017 there are limitations on data types etc. The page says "A DAC package or export file built with one version of the DAC Framework cannot be processed by an earlier version of the DAC Framework." so you would presumably need to use the same version on both instances for export and import. You'd need to try it in a test environment and see if it works. Database size could be an issue.
HTH
PS This would only work with user databases. You would need to recreate logins https://support.microsoft.com/en-gb/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server and jobs etc. by scripting them out.
March 18, 2020 at 8:47 am
You cannot do an in-place downgrade, you'll have to:
One thing to keep in mind is that SQL Server 2014 is no longer in mainstream support.
Joie Andrew
"Since 1982"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply