I am trying to export data-tier application to create a bacpac file. When running the utility I get the following error:
Mostly clustered index errors. What does that mean and how do I resolve this issue to that I can create the file? If I create a clustered index, what does that do to my data? I am ultimately loading my SQL on prem to SQL Azure
TITLE: Microsoft SQL Server Management Studio
------------------------------
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71564: Table Table: [dbo].[tblSQLStrings] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblIVPAMonthly] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[frmUnregisteredEvent] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblKeyLeaders] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblBackupSummerYouthGrid] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblSYABGrid] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblCCRet] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[frmRegistrationCSW] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblIVPATA] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblOrgMonthlyProgressSetbacks] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblYAT2] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblYAT1] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblMonthlyReport3] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblOrgCurrentActivity] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblSummerYouthGrid] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblOrgCommunityAreas] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[frmRegistrationPITW] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblOrgProfile] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[AttendanceGrid] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[frmRegistrationBridges] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblOrgSubGroup] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblAttendanceSYAB] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblRegistrationSYAB] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblSummerYouthGridBackup2012] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[frmRegistrationSummerYouthEmploymentBackup2012] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblIVPAPlan] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblJJDP] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblOrgEvents] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblMonthlyReport1] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[frmRegistrationSummerYouthEmployment] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblIVPAActivities] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblIVPAStaff] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblDueDate] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblDailyLog] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[tblMonthlyReport4] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
(Microsoft.SqlServer.Dac)
------------------------------
BUTTONS:
OK
------------------------------
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.