Trying to export a database as a Data-Tier Application with SEO Checker installed (1.6.1) results in the following error message. Problem stems from SEOChecker_Robots not having a clustered index (possibly other tables as well):
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].[SEOChecker_Robots] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server. (Microsoft.SqlServer.Dac)
Exporting Data-Tier Application schema validation failure
Trying to export a database as a Data-Tier Application with SEO Checker installed (1.6.1) results in the following error message. Problem stems from SEOChecker_Robots not having a clustered index (possibly other tables as well):
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].[SEOChecker_Robots] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
(Microsoft.SqlServer.Dac)
HI Robert,
They didn't teach me anything about Clusterd Indexes at DBA School ;-) Is it a Azure special thing?
Thanks,
Richard
This is just on local SQL2012 server - although I will eventually be exporting this to Data-Tier with the aim of importing it to Azure...
The table in question has no indexes whatsoever - are the NodeId and UserAgent fields unique in each record?
Will add it to the list of things to fix
excellent... If you want to provide an sql patch script I volunteer to test it for you :)
Cool, first need to know what is exactly wrong since scripts got generated from sql server criate table dialog...
is working on a reply...