Issues with using SQL Server Management Studio 2012 local with SSMS2014 remote?
Posted on 2014-12-02
Would there be any issues or uncooperative behavior between a 2012 sql management studio (local) and the 2014 sql server?
For instance, locally I have SSMS2012 installed. Remotely, on my new Rackspace cloud server I have SSMS2014 installed.
If locally, I use my SSMS2012 to copy databases and create tables, etc. will that keep the sql server database version as 2014, or will it downgrade it to 2012?
What problems might I have and how can I resolve that? I also have SQL Server 2008 and 2012 versions to support on other servers, so I don't want to break my ability to manage 2012 databases, but do want the ability to manage my 2014 database also.
Or do I just install SSMS2014 locally and be done with it?