When migrating from Azure Database to Azure Database, the generated script has an error:
In CREATE TABLE statement is generated with "PAD_INDEX = OFF".
That doesn't work on Azure Databases
I Have analyzed the source with Reflector and found that:
if (so.TargetDatabaseEngineType != DatabaseEngineType.SqlAzureDatabase)
this.ScriptAlterPropBool("PadIndex", "PAD_INDEX", so, queries, ref optCount, false, false);
At the generation time, the wizard can't know that type of the target, because that is specified AFTER the generation.
I Think he decides because of the Source:
SQL-Server -> target = Azure
Azure -> target = SQL-Server.
==> In Migration mode, Source AND Target schould be specified before Script Generation.
Remove the PAD_INDEX Clauses manually after script generation.
Maybe copy the content to an Editor, replace all PAD_INDEX and copy it back to the wizard.