Take Control – Windows Azure SQL Database Application Life Cycle Management Made Easy!

July 20, 2013 — 3 Comments

Incredible-homer-simpson-HULK-psd9311Think back to projects where you had to maintain databases using update scripts. They’re usually applied using home grown solutions and can cause some major headaches. 

Microsoft has been developing the Microsoft SQL Server Data Tools for a while and I strongly recommend using them to develop and deploy your Windows Azure SQL Database.

As you may already know, Windows Azure SQL Database doesn’t support the full range of features available in SQL Server 2012. Using the Microsoft SQL Server Data Tools will help you identify issues early by validating your schema against the target platform. The tools will provide IntelliSense and make it possible to manage database versions by storing scripts in TFS. Furthermore, they simplify deployments by comparing the new schema against the destination database in order to generate an update script.

From personal experience, using the Microsoft SQL Server Data Tools makes it possible for teams to collaborate on databases. By splitting objects like tables, views and stored procedures into their own files, it makes it possible to maintain and evolve the database as we progress in the application’s elaboration.

That being said, I urge you to get acquainted with the Microsoft SQL Server Data Tools using the links found below. Make a difference on your projects by using the right tools! 

Microsoft SQL Server Data Tools

Developers will also appreciate the familiar VS tools we bring to database development, specifically; code navigation, IntelliSense, language support that parallels what is available for C# and VB, platform-specific validation, debugging and declarative editing in the TSQL Editor, as well as a visual Table Designer for both database projects and online database instances.

SQL Server Data-Tier Application Framework (June 2013) Available

What’s new? This feature release of the Data-Tier Application Framework (DACFx) brings with it a significant payload of both new functionality as well as 100+ bug fixes since the last release. The features included in this update center around a new

Announcing SQL Server Data Tools – June 2013

We are pleased to announce that SQL Server Data Tools – June 2013 is now available for download. This release introduces several new features that we have consistently received requests for via MSDN forums and Connect

Download SQL Server Data Tools – June 2013

The SSDT – June 2013 update contains several improvements:

  • Data Compare
  • Build and Deployment Contributors
  • Extensibility API
  • Updated Data-Tier Application Framework (DACFx)

This release is available for both Visual Studio 2012 and Visual Studio 2010

Trackbacks and Pingbacks:

  1. Reading Notes 2013-08-05 | Matricis - August 5, 2013

    […] Take Control – Windows Azure SQL Database Application Life Cycle Management Made Easy! (Alexandre Brisebois) – The SQL Server Data Tools (SSDT) is definitely a must for all projects with a database. […]

    Like

  2. Steps Towards Optimized Windows Azure SQL Databases | Alexandre Brisebois - November 30, 2013

    […] to making any changes to your application, you should look into taking control of your database’s life cycle management by employing tools like the Microsoft SQL Server Data Tools. These tools allow you to target […]

    Like

  3. Securing Production #Azure SQL Databases « Alexandre Brisebois ☁ - January 8, 2015

    […] Use SQL Database Projects to design, build, version and deploy […]

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s