SQL Server 2014 – Updates and Migrating Templates

SQL Server 2014 has been out for almost a month now. Some updates and additional tools for 2014 have become available since the release.

The Cumulative Update 1 For SQL Server 2014 has been reposted (The download had been temporarily been suspended but is now available).

SQL Server Data Tools for SQL Server 2014 is also available for Visual Studio 2012 and 2013 using the Extension Manager.

Finally the
SQL Server Data Tools – Business Intelligence for Visual Studio 2013 download was previously available, but it has been removed for now.

I make heavy use of Templates in SSMS (about 25 or so) for development, which needed to be migrated when I moved to SSMS 2014. Luckily, it was as easy as copying the templates to a directory. The directory for 2014 is at:
“C:\Users\{User}\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\Templates\Sql\CS\*.sql”
Where {User} is the Windows user name, and CS is the directory I created for the custom templates. SSMS needs to be closed and re-opened to pick up these changes.

3 Responses to SQL Server 2014 – Updates and Migrating Templates

  1. VickyWinner says:

    How can once change the path of template to “My Documents” so its easy to manage?

    • Rob says:

      Great question. I’m not aware of any way to change the template location for SSMS. I certainly didn’t see anything in SSMS options or settings to change this.

  2. […] starting point for several different things, such as creating a new stored procedure or a table. I wrote about templates in an earlier post. All that’s involved is copying the templates from the old installation to the 2016 […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: