Try our conversational search powered by Generative AI!

[Azure] Cannot export Commerce database to .bacpac file

Found in

EPiServer.Commerce.Azure.8.6.0

Created

Dec 19, 2014

Updated

Jan 26, 2015

Area

Falcon/Commerce

State

Closed, Fixed and Tested


Steps to reproduce

Steps to reproduce

  1. Already has Commerce site created by VS Extension
  2. Install EPiServer.Commerce.Azure nuget package
  3. Run Update-epidatabase
  4. Execute scripts in packages\EPiServer.Commerce.Azure.8.6.0-pre-000414\tools\epiupdates_commerce\sql\manual\PrepareForSqlAzure.sql
  5. Using SQL Management Studio to connect to Commerce LocalDB in App_Data folder of the project folder
  6. Export Data-tier application

    Expected: Commerce database is exported to .bacpac file

    Actual: Error during exporting, .bacpac file isn't exported

Error SQL71564: Table Table: [dbo].[SchemaVersion_MetaDataSystem] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion_ReportingSystem] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[CatalogEntrySearchResults] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion_OrderSystem] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[AzureCompatible] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[McBlobStorage] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion_MarketingSystem] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SiteSecurity] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion_SecuritySystem] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[Affiliate] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[CatalogSecurity] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion_ApplicationSystem] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[CatalogNodeSearchResults] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion_BusinessFoundation] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[CatalogLanguageMap] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SiteCatalog] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SchemaVersion_CatalogSystem] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[SiteLanguage] does not have a clustered index.  Clustered indexes are required for inserting data in this version of SQL Server.