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.
Templates:
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.
How can once change the path of template to “My Documents” so its easy to manage?
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.