Data Generation Plans with Windows Azure SQL

Visual Studio cannot create Data Generation Plans for Windows Azure because the schemas aren’t compatible.

These are the steps you need to take if you want to generate data for an Azure database.

  1. Import your Azure database to your local SQL / SQL Express instance on your development machine
  2. Create the data generation plan using the local database
    data generation complete
  3. Use the SQL Database Migration Wizard to create your migration backups
    SQL Migration Wizard - Script Wizard
  4. Continue with the SQL Database Migration Wizard to publish to a database in Azure
    Target Server Response

Useful links