Home > SQLAzure > SQL Azure Producer Overview

SQL Azure Producer Overview


As we announced in this post, starting with the build 579, CodeFluent Entities now provides an out-of-the-box SQL Azure Producer.

Using this producer you can generate SQL Azure scripts and automatically run them on your SQL Azure database. Moreover, you can also work on a local SQL Server instance, whilst ensuring you’re using SQL Azure supported features only, and then deploy online when ready. Not only this avoids transfer costs, but when generating over a SQL Server database, the producer’s Diff Engine is enabled which allows you to generate continuously without ever losing data.

Last but not least, the Modeler also ships a new feature known as the Model and Database Explorer which, as the name suggests, lets you explore databases (or XMI and Enterprise Architects models) directly from Visual Studio. Supported databases are: Access 2007/2010, Access / Jet, OLE DB, Oracle, SQL Server, SQL Azure, and SQL Server CE.

This way, once you generated and deployed your scripts on your online SQL Azure database, without leaving Visual Studio you can explore the generated database, including data. Talking about viewing data, unlike Microsoft’s SQL Azure Database Manager, Guids and Blobs can be viewed in the explorer Winking smile

 

Here’s a video showing it all:

SQL Azure Producer Overview
Categories: SQLAzure Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

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