Migrate your database to SQL Azure

1. Configure the SQL Azure firewall.
   To be able to access your SQL Azure database server from your local machine, add a firewall rule for your IP:
   1. Log to the Management Portal and click Database in the lower-left pane.
   2. In the tree on the left, expand your subscription and select your database server.
   3. In the right, expand the list of firewall rules and select Allow other Windows Azure services to access this server checkbox.
      This adds a special rule named MicrosoftServices.
   4. In the bottom of the list, click Add and enter a name for the rule.
   5. Copy Your current IP address (shown at the bottom of the dialog) and paste it in IP range start and IP range end input fields.
   6. Click OK.
2. Migrate your local database to SQL Azure.
   If you use SQL Express data file, you must first attach it to a running SQL Server instance.
   1. Download and run the SQL Azure Migration Wizard.
   2. On the Select Process  step, select Analyze and Migrate » SQL Database.
   3. Provide connection information to your local database.
      No changes to the default settings are required until the script generation is completed on Results Summary screen.
   4. On the next step, provide connection information for your SQL Azure database server.
      In Server, enter the SQL Azure Server fully qualified DNS name.
      The name must have the following format: <yourservername>.database.windows.net.

      You can find the fully qualified DNS name in the following way:

      1. In the Management Portal of Windows Azure Platform, click Database.
      2. Select your database instance and expand Properties pane in the right.
      3. The name appears in Fully Qualified DNS Name field.
   5. Select an empty database you have already created for this deployment or create a new one.
      To create a new database, click Create Database button, enter name and size, and confirm.
   6. Click Next and confirm the execution of the previously generated migration SQL script against this database.
   7. When you are finished, click Exit to close the Migration Wizard.
3. Change the connection string in the DataConfig.config file of your project to point to the SQL Azure instance, where you have migrated your database.
   The format of the connection string element is the following:

   <add dbType="SqlAzure" name="Sitefinity" connectionString="Server=<serverName>.database.windows.net;User ID=<userName>@<serverName>;Password=<password>;Database=<databaseName>; Trusted_Connection=False;Encrypt=True" providerName="System.Data.SqlClient" />

   NOTE: For Sitefinity CMS to function normally with SQL Azure, set the dbType attribute to SqlAzure.

   RECOMMENDATION: We recommend that you keep the Visual Studio solution for future purposes, such as upgrade.