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 (Azure) 17 hours 23 minutes ago adding more details

I removed that CONSTRAINT and I was able to create db. Why it doesn't work with it?

Also, in Azure portal, I could see db card, and now it shows just this, or endless "Loading..." animation:

Old portal gives this error when opened "Monitor" tab of this database:

The server could not retrieve metrics (Internal Server Error).

• Edited by hhrvojeMVP 16 hours 1 minutes ago

Hi,

Thank you for reaching out to us.
I am currently researching to gather more information with regards to your request.
I shall revert back to you with an update at the earliest.

Sincerely appreciate your patience.

Regards,
Sunil