This is a mirror of official site: http://jasper-net.blogspot.com/

Visual Studio Gets Better SQL Server Tooling – ‘Juneau’

| Monday, August 1, 2011
SQL Server Development Tools (SSDT) - ‘Juneau’ - brings testing, debugging, version control, refactoring, dependency checking, and deployment to database development in Visual Studio. It was previewed recently along with SQL Server ‘Denali’ CTP.

Some of the features in the preview are - 

    New Testing and Debugging method which works with a local database that’s created automatically for each database project
    Schema Compare – for comparing a SQL Server Project Schema to a target database and highlight differences
    Publish Database feature, that supports both onsite SQL Server as well as SQL Azure
    Declarative database development through Power Buffer
    Enhanced TSQL editor with features like IntelliSense, Go To Definition and Find All References, Refactor contextual menu and more, similar to C# and VB editors in

Visual Studio

There is a blog post from the SSDT team that outlines all the planned features in SSDT - one major feature missing in the preview is the Application Project and Database Integration, which is meant to give build-time dependency checking between Application and Database tiers. The preview also misses quite a few features present in Visual Studio Database Projects as noted by Milo Hoffman. Some of these missing features might eventually get added before SSDT is actually released.

Read more: InfoQ
QR: sql-server-tools-juneau

Posted via email from Jasper-net

0 comments: