5

We are facing issues while moving an existing Sitecore master db from an on premise SQL Server instance to an Azure SQL Server. The BACPAC file is almost 5 GB.

enter image description here

The above error appears on - Enabling index 'ndxUnique' - importing database - importing package schema and data into database - updateing database - importing data - processing import - enabling indexes

enter image description here

Any ideas about moving such big db into azure sql would be appreciated. It's a Sitecore 8.2

Thanks

  • Give a shot and download a newer version of Management Studio - docs.microsoft.com/en-us/sql/ssms/… - as I do see the following error "A project which specifies SQL Server vNext CTP as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12" – Vinicius Deschamps Aug 6 '18 at 14:25
2

We regularly move our bacpacs between azure and onsite. It is not unusual for these bacpacs to be greater than 11G. If SSMS is timing out, you may want to try to upload the bacpac to a storage account (Blob storage), then use the portal to create the DB.

If that still bombs, then open a ticket w/Azure folks.

If that works, then it is probably not the bacpac or service level of the SQL Database you are creating. Updating SSMS may help, but I have not experience this as an issue so I couldn't tell you it will help.

As a sidebar, I've found that it doesn't matter whether the DB is a P1 or a P15 for an export. It takes the same amount of time +-5%.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.