August 24, 2016 at 6:56 am
Can I use SQL Server Management Studio 2012 to manage a SQL Server 2014 database?
August 24, 2016 at 7:05 am
yes but you wont be able to access certain 2014 features like Managed Backups via the GUI
August 24, 2016 at 7:10 am
Thank you for the quick reply. Fortunately for me someone else manages the backups. What about SSIS and SSRS?
August 24, 2016 at 7:55 am
I am actually not sure on those components as I rarely use SSMS to connect to them. sorry.
August 24, 2016 at 10:45 am
Most of SSIS and SSRS management is through Visual Studio, not SSMS. And yeah, you'll probably have to upgrade to the latest database tools for those. SSMS can connect to versions greater than itself and you can do some basic management. However, you're dancing around asking for trouble because there's no way of knowing for sure what will not work. The better approach is to install the newer version of SSMS and then work backwards. Depending on how far back, 2012 from 2014 is not an issue, in fact, you can manage 2008R2 from the 2016 version and everything in between, you will be supported.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2016 at 11:04 am
Thank you. Very informative and helpful. I am new to using this forum and it has been a great time saver to have knowledgeable help available and the responses so quick. Thanks again.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply