Sign in Register
Go to solution
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
Please Sign in or register to post replies

Write your reply to:

Draft