{"id":7093,"date":"2007-08-06T16:23:00","date_gmt":"2007-08-06T16:23:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2007\/08\/06\/available-now-team-edition-for-database-professionals-service-release-1\/"},"modified":"2019-02-14T17:52:23","modified_gmt":"2019-02-15T01:52:23","slug":"available-now-team-edition-for-database-professionals-service-release-1","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/available-now-team-edition-for-database-professionals-service-release-1\/","title":{"rendered":"Available Now: Team Edition for Database Professionals Service Release 1"},"content":{"rendered":"<p class=\"MsoNormal\"><font size=\"3\"><font face=\"Calibri\">In case you did not see an announcement on another forum or blog, Service Release 1 is now available for Visual Studio Team Edition for Database Professionals. This update not only addresses bugs that customers reported but also adds a modest number of new features. The new features include the following:<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpFirst\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">Significantly improved support for creating cross-database references. You can add references to other databases and servers, define variables that correspond to those references, and use those variables in the definitions of your database objects. By creating these references, your object definitions can work in different deployment configurations. You can also now use refactoring to change cross-database references. This approach might eliminate hundreds of warnings if your database contains many references to objects in other databases.<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">Improved support for defining files, log files, and filegroups for your database server. You can define these objects in the properties of your database project.<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpLast\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">Added support for defining SETVAR variables that you can reference in your pre-deployment and post-deployment scripts. For example, you might define a SETVAR variable for a service broker or service certificate.<\/p>\n<p><\/font><\/font><\/p>\n<p><span><font size=\"3\">You can find more information and a link to download the English version of the update at the <\/font><\/span><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96612\"><span><font color=\"#0000ff\" size=\"3\">Download Center<\/font><\/span><\/a><span><font size=\"3\"> on the Microsoft Web site. <\/p>\n<p><\/font><\/span><\/p>\n<p><span><font size=\"3\">To immediately download the update, you can click <\/font><\/span><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96611\"><span><font color=\"#0000ff\" size=\"3\">this link<\/font><\/span><\/a><font size=\"3\"><span> to the Microsoft Web site.<\/span><\/p>\n<p><\/font><\/p>\n<p class=\"MsoNormal\"><span><font face=\"Calibri\">You can find the <\/font><\/span><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96608\"><span><font face=\"Times New Roman\" color=\"#0000ff\">Knowledge Base<\/font><\/span><\/a><span><font face=\"Calibri\"> article for the update on the Microsoft Web site.<\/p>\n<p><\/font><\/span><\/p>\n<p class=\"MsoNormal\"><span><font face=\"Calibri\">You can install this update in nine languages from the following locations:<\/p>\n<p><\/font><\/span><\/p>\n<ul type=\"disc\">\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96613\"><span><font face=\"Times New Roman\" color=\"#0000ff\">Italian &#8211; Italy<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96614\"><span><font face=\"Times New Roman\" color=\"#0000ff\">Chinese &#8211; Taiwan<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96617\"><span><font face=\"Times New Roman\" color=\"#0000ff\">Korean &#8211; Korea<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96612\"><span><font face=\"Times New Roman\" color=\"#0000ff\">English &#8211; United States<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96618\"><span><font face=\"Times New Roman\" color=\"#0000ff\">Chinese &#8211; China<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96619\"><span><font face=\"Times New Roman\" color=\"#0000ff\">French &#8211; France<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96620\"><span><font face=\"Times New Roman\" color=\"#0000ff\">German &#8211; Germany<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96621\"><span><font face=\"Times New Roman\" color=\"#0000ff\">Spanish (Traditional Sort) &#8211; Spain <\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<li class=\"MsoNormal\"><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=96622\"><span><font face=\"Times New Roman\" color=\"#0000ff\">Japanese &#8211; Japan<\/font><\/span><\/a><span>\n<\/p>\n<p><\/span><\/li>\n<\/ul>\n<p class=\"MsoNormal\"><font size=\"3\"><font face=\"Calibri\">In addition, the first release of power tools for Team Edition for Database Professionals should become available within the next week. This release will include:<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpFirst\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">New types of database refactoring<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">MSBuild improvements to support comparing schemas and data at a command prompt<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">Data generator improvements to help you specify regular expressions and data bound columns<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">A new Sequential Data Bound Generator<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">New templates for database projects<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">A simple dependency viewer for database objects<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoListParagraphCxSpLast\"><span><span><font size=\"3\">&middot;<\/font><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/span><\/span><font size=\"3\"><font face=\"Calibri\">Static code analysis for Transact-SQL (T-SQL) code<\/p>\n<p><\/font><\/font><\/p>\n<p class=\"MsoNormal\"><font size=\"3\"><font face=\"Calibri\">I will post additional details about the power tools when they are released. They are scheduled to be available by Friday, August 10.<\/font><\/font><\/p>\n<p class=\"MsoNormal\"><font size=\"3\"><font face=\"Calibri\">&#8212; Steven Powell, lead writer for Team Edition for Database Professionals<\/font><\/font><\/p>\n<p class=\"MsoNormal\"><font face=\"Calibri\" size=\"3\"><\/font>&nbsp;<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In case you did not see an announcement on another forum or blog, Service Release 1 is now available for Visual Studio Team Edition for Database Professionals. This update not only addresses bugs that customers reported but also adds a modest number of new features. The new features include the following: &middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Significantly improved support [&hellip;]<\/p>\n","protected":false},"author":125,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops"],"acf":[],"blog_post_summary":"<p>In case you did not see an announcement on another forum or blog, Service Release 1 is now available for Visual Studio Team Edition for Database Professionals. This update not only addresses bugs that customers reported but also adds a modest number of new features. The new features include the following: &middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Significantly improved support [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/7093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/125"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=7093"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/7093\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=7093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=7093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=7093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}