Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 128
  • Last Modified:

Issues with using SQL Server Management Studio 2012 local with SSMS2014 remote?

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?


thanks!
0
Starr Duskk
Asked:
Starr Duskk
1 Solution
 
RayCommented:
It's best to install SSMS 2014 locally to take advantage of the new functions/features in SQL 2014; they might not be available in SSMS2012.

We had SSMS 2008R2, 2012, 2014 installed on the same local machines without any issues.  Just remember to use the right SSMS to connect to the corresponding SQL Server.
0
 
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
thanks!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now