Visual Studio Team System Database Edition GDR September CTP Description:

The 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 2008
All 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 Projects

Partial 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 unit

Composite 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 Project

Build and Deploy

The Build process now produces a separate portable schema output that is fed in to a redistributable deployment engine

A 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 Expansion
Move Schema
Fully Qualify
Extensibility point which enables the ability to develop and deploy custom refactoring types and targets

Schema 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 Filtering
Additional ignore filtering options

T-SQL Static Code Analysis

Including the ability to develop and deploy custom rules

Dependency Viewer

View the dependency relationship between objects in your schema

Unit testing

Supports execution with other ADO.NET providers

Data Generation

Design-time enhancements

- Smaller .dgen file
- Support for undo/redo
- Foreign key replacement
- Separation of population status into new display window

Runtime 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 table

Extensibility

Data Generators
Statistical Data Distribution
Test Conditions
Static Code Analysis Rules
Refactoring Types
Refactoring Target

Visual Studio Team System Database Edition GDR September CTP Requirements:

· 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 1

Related:

system integrity checker

Related searches:

microsoft visual studio 2005 professiona - microsoft visual studio 2005 - myscript studio notes edition - microsoft visual studio 2005 professiona1 - microsoft visual studio 2005 professiona9 - microsoft visual studio 2010

Visual Studio Team System Database Edition GDR security information

You cannot download any crack or serial number for Visual Studio Team System Database Edition GDR on this page. Every software that you are able to download on our site is legal. There is no crack, serial number, hack or activation key for Visual Studio Team System Database Edition GDR present here. Our collection also doesn't contain any keygens, because keygen programs are being used in illegal ways which we do not support. All software that you can find here is freely downloadable and legal.

Visual Studio Team System Database Edition GDR installation package is prepared to be downloaded from our fast download servers. It is checked for possible viruses and is proven to be 100% clean and safe. Various leading antiviruses have been used to test Visual Studio Team System Database Edition GDR, if it contains any viruses. No infections have been found and downloading Visual Studio Team System Database Edition GDR is completelly problem free because of that reason. Our experts on malware detection tested Visual Studio Team System Database Edition GDR with various spyware and malware detection programs, including fyxm.net custom malware and spyware detection, and absolutelly no malware or spyware was found in Visual Studio Team System Database Edition GDR.

All software that you can find on our servers, including Visual Studio Team System Database Edition GDR, is either freeware, shareware or open-source, some of the software packages are demo, trial or patch versions and if possible (public domain licence), we also host official full versions of software.

Because we want to be one of the fastest download sites on the web, we host all the software including Visual Studio Team System Database Edition GDR on our servers. You cannot find here any torrents or download links that would lead you to dangerous sites.

Fyxm.net does support free software, however we do not support warez or illegal downloads. Warez is harming producers of the software.

Enjoy!