Visual Studio Team System Database Edition GDR September CTP
Visual Studio Team System Database Edition GDR : Incorporates many previously released Power Tools as well as several new featuresThe Microsof Visual Studio Team System 2008 Database Edition GDR implements support for SQL Server 2008.In addition to providing support for SQL Server 2008 database projects, this release incorporates many previously released Power Tools as well as several new features. The new features include distinct Build and Deploy phases, Static Code Analysis and improved integration with SQL CLR projects.Database Edition no longer requires a Design Database. Therefore, it is no longer necessary to install an instance of SQL Express or SQL Server prior to using Database Edition.
SQL Server Support
SQL Server 2008All new data types:- Intrinsic (date, datetime2, datetimeoffset, time)- Built-in SQL CLR types (geography, geometry, hierarchyid)New DML- Merge, table parameters,SQL Server Configuration Options- Server option settings will be verified prior to deployment or set during deployment- Additional 1st Class Object Type Support- Rules, defaults, Asymmetric keys, symmetric keys, certificates, ?Projects
Server Projects- Server objects and option settings may be implemented in a separate Server Project- This enables a team to define a standard a configuration for their SQL servers and reference it from their Database ProjectsPartial projects- Allowing code sharing between projects by including files from a different project, where the code is included as-is from the originating project and the source code control ownership remains with the originating project- This enables code reuse and single sourcing while having a single deployment unitComposite projects- References to other database projects or .dbschema files that contribute to the same deployment unit.- This enables the separation of development roles and responsibilities and composition of Databases using multiple projects.Single sourcing of external artifacts
SQL-CLR references allow the user to create a reference to a SQL-CLR project or SQL-CLR assembly. This automatically becomes an ASSEMBLY type in the Database ProjectBuild and Deploy
The Build process now produces a separate portable schema output that is fed in to a redistributable deployment engineA redistributable deployment engine. For example, to implement a setup application that deploys the Database Project.Refactoring
Preservation of Intent- Enables the deployment of refactoring changes as intended by the user (renames are deployed as renames not as drop/add statements for example)New Refactoring Operations
Wildcard ExpansionMove SchemaFully QualifyExtensibility point which enables the ability to develop and deploy custom refactoring types and targetsSchema Compare
Now supports comparing Projects, Databases or dbschema files in any combination. For example, Project to Project, which has not been possible until now.Object Type FilteringAdditional ignore filtering optionsT-SQL Static Code Analysis
Including the ability to develop and deploy custom rulesDependency Viewer
View the dependency relationship between objects in your schemaUnit testing
Supports execution with other ADO.NET providersData Generation
Design-time enhancements- Smaller .dgen file- Support for undo/redo- Foreign key replacement- Separation of population status into new display windowRuntime enhancements- By default uses SqlBulkCopy to populate target tables- Capability to register different outputs for generated data ? i.e. generate to Excel or to file so you can use BCP to load- By registering a custom output we have the capability to execute scripts at different points during data generation (i.e. before start/after completion or before/after a tableExtensibility
Data GeneratorsStatistical Data DistributionTest ConditionsStatic Code Analysis RulesRefactoring TypesRefactoring TargetRequirements:? Computer with a 2.0 GHz processor? 512 MB of RAM (1 gigabyte [GB] recommended)? 3 GB of available hard-disk space? DVD-ROM drive? 1024x768 resolution with 256 colors? Keyboard and mouse or compatible pointing device? Microsoft Visual Studio Team System 2008 Database Edition SP1 (English) or Microsoft Visual Studio Team System 2008 Suite SP1 (English)? Microsoft Visual Studio 2008 Service Pack 1Conclusion
To conclude Visual Studio Team System Database Edition GDR works on Windows operating system(s) and can be easily downloaded using the below download link according to Freeware license. Visual Studio Team System Database Edition GDR download file is only 12.7 MB in size.Visual Studio Team System Database Edition GDR was filed under the General category and was reviewed in softlookup.com and receive 4.8/5 Score.
Visual Studio Team System Database Edition GDR has been tested by our team against viruses, spyware, adware, trojan, backdoors and was found to be 100% clean. We will recheck Visual Studio Team System Database Edition GDR when updated to assure that it remains clean.
Visual Studio Team System Database Edition GDR user Review
Please review Visual Studio Team System Database Edition GDR application and submit your comments below. We will collect all comments in an effort to determine whether the Visual Studio Team System Database Edition GDR software is reliable, perform as expected and deliver the promised features and functionalities.Popularity 9.6/10 - Downloads - 83 - Score - 4.8/5
Softlookup.com 2023 - Privacy Policy
Category: | General |
Publisher: | Microsoft |
Last Updated: | 2/11/2023 |
Requirements: | Windows 2003 / Windows Vista / Windows XP |
License: | Freeware |
Operating system: | Windows |
Hits: | 483 |
File size: | 12.7 MB |
Price: | Not specified |
Name: * |
E-Mail: * |
Comment: * |