From Hrvoje Hudo @hhrvoje via Twitter

Why are my attempts to export DB from stand-alone SQL server into Azure SQL failing?

Original Tweet:

Exporting db from stand-alone SQL Server into @Azure Sql is much much more challenging than I expected to be, so far all attempts failed

• Edited by Jillian Folks Microsoft (MSFT CSG) Saturday, July 04, 2015 1:07 PM
• Merged by Lydia ZhangMicrosoft contingent staff, Moderator Monday, July 06, 2015 2:40 AM duplicate post

From Hrvoje Hudo @hhrvoje via Twitter

Why are my attempts to export DB from stand-alone SQL server into Azure SQL failing?

Original Tweet:

Exporting db from stand-alone SQL Server into @Azure Sql is much much more challenging than I expected to be, so far all attempts failed

Little bit of background:

- current db is stand-alone sql server 2014. Created by EF 6 migrations. No SPs, Views, just simple tables with data
- SQL pub wizard can't script data, reports "cyclic redundancy check error". But if I script schema+data, then it works. Generated file is around 200Mb, and VS2013 (all latest updates) just hangs if I try to execute it against Azure db
- Azure migration wizard tool stops on one table, reports this error from screenshot.

I was able to find an error with this Sql line:

CREATE TABLE [dbo].[Offers](
 [UniqueIntId] [bigint]  NOT NULL CONSTRAINT [SQ_OfferUniqueIntIdSequence]  DEFAULT (NEXT VALUE FOR [OfferUniqueIntIdSequence]),

it fails with message: Invalid object name 'OfferUniqueIntIdSequence'.

This CREATE script is generated with sql pub wiz, configured for azure db.

• Edited by Jillian Folks Microsoft (MSFT CSG) Saturday, July 04, 2015 1:43 PM adding more details

hhrvoje,

As Ron said,  CREATE SEQUENCE is supported for V12 databases.

You can find an overview of resource management https://msdn.microsoft.com/en-us/library/azure/dn338083.aspx

and you can also find an overview of the database editions https://msdn.microsoft.com/en-us/library/azure/dn741336.aspx

If you could email me at cakarst at Microsoft dot com with your subscriptionGUID and servername, I will be able to help get the portal metrics issue resolved.

Thanks,

Casey

• Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Friday, July 10, 2015 9:12 AM