Copied to clipboard

Flag this post as spam?

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


  • Frans de Jong 548 posts 1840 karma points MVP 3x c-trib
    Jan 15, 2019 @ 15:27
    Frans de Jong
    0

    Switch from SQL to SQLce

    After migrating a site to Cloud I'd like to generate a SQLce database in the project with all the new Cloud users. Is there a way to do that? I can't find it in the documentation.

  • Nicholas Westby 2054 posts 7100 karma points c-trib
    Jan 15, 2019 @ 17:26
    Nicholas Westby
    0

    So long as they were created with the "Add Member" functionality in Umbraco Cloud, users should exist as files in ~/data/backoffice/users/.

    When you pull, the database should be created for you, including the users.

    I sometimes run into issues, in which case I run echo > deploy from the command prompt in the data folder, as explained here: https://our.umbraco.com/documentation/Umbraco-Cloud/Deployment/Local-to-Cloud/

  • Frans de Jong 548 posts 1840 karma points MVP 3x c-trib
    Jan 15, 2019 @ 17:29
    Frans de Jong
    0

    So what I did was delete everything in my .web folder and remove it from sourcetree. Then I cloned the project from cloud and still the connectionstring to the old server was there and no database was created.

    Am I missing something here?

  • Frans de Jong 548 posts 1840 karma points MVP 3x c-trib
    Jan 16, 2019 @ 13:34
    Frans de Jong
    100

    After contacting support I found the way. So for future reference:

    I needed to look up the original database connectionstring in the .web repository (Cloud repository) and put that in the web.config instead of the connectionstring to my old database.

    Next go to the /data folder and rename deploy-complete to deploy.

    Run the site and it restores the database to SQLce in the project.

    Job done!

Please Sign in or register to post replies

Write your reply to:

Draft