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 (Azure) 17 hours 58 minutes ago

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 hhrvojeMVP 17 hours 27 minutes ago

Hi Hrvoje,

We posted this on our Azure SQL Forum as well and added your last update. http://aka.ms/hch33g.  You will receive a response there shortly.