Sign in Register
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 440 posts 1684 karma points MVP 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)



    Copy Link
  • Richard Soeteman 3875 posts 12037 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

    Copy Link
  • Robert Foster 440 posts 1684 karma points MVP 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?

    Copy Link
  • Richard Soeteman 3875 posts 12037 karma points MVP
    Sep 02, 2014 @ 09:08
    Richard Soeteman
    0

    Will add it to the list of things to fix

    Copy Link
  • Robert Foster 440 posts 1684 karma points MVP 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 :)

    Copy Link
  • Richard Soeteman 3875 posts 12037 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...

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies