SQL SERVER – Generate Database Script for SQL Azure

When talking about SQL Azure the common complain I hear is that the script generated from stand-along SQL Server database is not compatible with SQL Azure. This was true for some time for sure but not any more. If you have SQL Server 2008 R2 installed you can follow the guideline below to generate script which is compatible with SQL Azure.

As above images are very clear I will not write more about them. SQL Azure does not support filegroups. Let us generate script for any table created on PRIMARY filegroup for standalong SQL Server and compare it with the script generated for SQL Azure.

You can clearly see that there is no filegroup in the code generated for SQL Azure. Give it a try and please your comment here about what do you think about the same.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

9 thoughts on “SQL SERVER – Generate Database Script for SQL Azure

  1. Hi Pinal,

    i follow your articles it’s very nice.

    do you have any article on Transaction isolation levels which
    will give me a brief explanation about isolation with example.

    READ UNCOMMITTED
    READ COMMITTED
    REPEATABLE READ
    SERIALIZABLE
    SNAPSHOT

    thanks in Advance
    Satish

  2. Hello,
    I have installed sql server 2008 R2 Express Edition. but I could not find “Script for SQL Azure Database” option. How can I do this?

  3. Hi

    It seems like azure is a trim down version of sql servers Can any one tell about because encryption and other basic restricting features are not supported in azure.

  4. Is this supposed to work for a “change” script, as opposed to scripting the entire DB? I’m trying to do a change script, and have changed my scripting options setting, but it’s not respecting what I changed it to. Seems like it may only work for scripting an entire DB. Anyone know how to get this working? Thanks.

  5. Pingback: SQL SERVER – Weekly Series – Memory Lane – #032 | Journey to SQL Authority with Pinal Dave

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