Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Robert Foster 411 posts 1507 karma points admin c-trib
    Sep 02, 2014 @ 08:25
    Robert Foster
    0

    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)



  • Richard Soeteman 3722 posts 11521 karma points MVP
    Sep 02, 2014 @ 08:53
    Richard Soeteman
    0

    HI Robert,

    They didn't teach me anything about Clusterd Indexes at DBA School ;-) Is it a Azure special thing?

    Thanks,

    Richard

  • Robert Foster 411 posts 1507 karma points admin c-trib
    Sep 02, 2014 @ 08:55
    Robert Foster
    0

    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?

  • Richard Soeteman 3722 posts 11521 karma points MVP
    Sep 02, 2014 @ 09:08
    Richard Soeteman
    0

    Will add it to the list of things to fix

  • Robert Foster 411 posts 1507 karma points admin c-trib
    Sep 02, 2014 @ 16:18
    Robert Foster
    0

    excellent...  If you want to provide an sql patch script I volunteer to test it for you :)

  • Richard Soeteman 3722 posts 11521 karma points MVP
    Sep 02, 2014 @ 16:20
    Richard Soeteman
    0

    Cool, first need to know what is exactly wrong since scripts got generated from sql server criate table dialog...

Please Sign in or register to post replies

Write your reply to:

Draft