Copied to clipboard

Flag this post as spam?

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


  • philip knight 9 posts 30 karma points
    Oct 23, 2023 @ 21:19
    philip knight
    0

    Migrating SQLite to SQL server

    Hello all! I just built my first Umbraco site on v12. I'm wanting to deploy to IIS and local SQL server 2019. the problem I'm having is as I was building locally, I used SQLite and I'm not sure how to migrate the SQLite DB to SQL server.

    I've tried using SQLite3 using the .dump method to generate a SQL file, but I get tons of syntax errors. I've also tried ESF DB Migrator and I'm running into the same issues.

    Does anyone have any experience with this or have any pointers?

  • Marc Love (uSkinned.net) 447 posts 1789 karma points
    Oct 24, 2023 @ 11:39
    Marc Love (uSkinned.net)
    0

    Hi Philip,

    I would recommend using uSync to export your database settings. You will be able to export your Document Type, Data Type etc settings as well as content and then import this into an empty Umbraco database running on SQL Server.

    Cheers,

    Marc

  • philip knight 9 posts 30 karma points
    Oct 24, 2023 @ 17:47
    philip knight
    0

    Terrific, thank you!

Please Sign in or register to post replies

Write your reply to:

Draft