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


  • Julien A 12 posts 151 karma points
    Feb 06, 2017 @ 10:56
    Julien A
    0

    Reimport Contours forms&data by SQL

    Hi,

    I would like to reimport all Contour data (forms + entries) to a new Umbraco instance with a fresh install of Contour. I thought the SQL Server "Import/Expor"t wizard t would do the job, but many errors occur. Here is what i do :

    • Select all [dbo].[UFxxx] tables
    • Edit mappings to "Enable identity insert"
    • Tried all methods : drop/create, delete exiting rows or append..

    Each time I got an error about Foreign key conflicts (FKUFFieldUFFieldsSet in table UFFieldsSet for instance). I don't understand why considering I copy all tables in a clean database. It's like the wizard was'nt handling the copy in the right order.

    What am I missing, what is the best way to do that ?

    Thanks for your help.

    Copy Link
  • Julien A 12 posts 151 karma points
    Feb 06, 2017 @ 12:43
    Julien A
    100

    Ok, I had to edit all foreign keys in the destination tables to not enforce Foreign Key constraints. I did it manually but a better way must exists :

    • Right click on foregn key, Modify
    • Table Designer > Enforce Foreign Key Constraint > No

    Should be reset as default then.

    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