In VSTS Database Edition, objects (such as tables, stored procedures, and views) that make up your schema are managed in a Visual Studio database project as CREATE scripts. This approach does not provide any way to track and merge changes to database objects, which makes moving changes from one environment to another a very manual process.
Historically, database schema development has required writing code against a shared development server and then writing update scripts to migrate changes from one environment to another. Test data generation-You can use this tool to generate pseudo-random realistic test data that can be used when you run unit tests.Īlong with descriptions of the capabilities these features provide, you'll find some hands-on examples that show them in action.Database unit testing-You can use a designer that enables development of T-SQL-oriented tests to exercise and verify your schema prior to checking in your code.Automated differencing engine-When you deploy a project, it generates a Transact-SQL (T-SQL) script that contains only the necessary changes to make the target database match the source.
Refactoring-By using VSTS Database Edition, you can change the name of an object (such as a table or column), and that change will update all references to the new name.Offline processing enables developers to catch syntax and reference errors prior to deployment. Interpretation and evaluation of your project's schema and interdependencies.In addition to these process improvements, VSTS Database Edition GDR also provides the following capabilities: In this article, we focus specifically on highlighting new features in the GDR, including its support for offline schema development, tools that support new processes that you can use when you develop a database schema, and features that support database administration. The GDR adds support for SQL Server 2008, incorporates improvements to existing features, includes many new features and extensibility points, and incorporates features that were previously released as power tools. The GDR installs on top of the initial release of VSTS 2008 Database Edition, but it is more than a minor version upgrade. In November 2008, the General Distribution Release (GDR) for Microsoft Visual Studio Team System 2008 (VSTS) Database Edition was released.
Referencing for Shared Server-Level Objects This article uses the following technologies:
Volume 24 Number 03 Database Development - Introducing New Features In The VSTS Database Edition GDR
0 kommentar(er)
