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


  • Saied 349 posts 674 karma points
    Aug 31, 2016 @ 03:56
    Saied
    0

    Should the Umbraco database (schema and data) be regenerated for every deployment?

    I have 3 environments (local, stage, and prod). My environments are never in sync, so I was curious when I deploy my local code changes to stage, should I include the local Umbraco db changes as well. I use courier to transfer between environments, so I am not sure if I need to do this. Seems like Umbraco writes to a lot of tables and it would not be a good idea.

    Thoughts?

    Thanks, Saied

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Aug 31, 2016 @ 09:25
    Alex Skrypnyk
    0

    Hi Saied,

    We are using Umbraco as a Service and uSync, and we have no problems with transferring database changes over environments.

    Thanks,

    Alex

    Copy Link
  • Saied 349 posts 674 karma points
    Sep 01, 2016 @ 14:55
    Saied
    0

    Hi Alex,

    What if I am not using UAAS. Can I just use uSync by itself?

    Thanks, Saied

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Sep 01, 2016 @ 15:09
    Alex Skrypnyk
    0

    Yes, it's great way to deploy and share database changes between developers. Read more - https://our.umbraco.org/projects/developer-tools/usync/

    Copy Link
  • Saied 349 posts 674 karma points
    Sep 01, 2016 @ 15:15
    Saied
    0

    I just tried installing it and it gave me errors when trying to access doc types, etc. Is it compatible with 7.4.5

    Copy Link
  • Saied 349 posts 674 karma points
    Sep 01, 2016 @ 15:28
    Saied
    0

    I don't think the error is related to uSync, but let's say I make a change to local db. How can I view the sql script changes.

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Sep 01, 2016 @ 16:12
    Alex Skrypnyk
    0

    uSync generates xml files with changes to database, you need to move these files from local to dev environment.

    Also you have to instal usync on both - local and dev.

    Thanks,

    Alex

    Copy Link
  • Saied 349 posts 674 karma points
    Sep 01, 2016 @ 19:36
    Saied
    0

    Hi Alex,

    Thanks for pointing this out. I was curious if you use the other parts of uSync such as snapshots and ContentEdition. I use courier and it works great. I think I would prefer using uSync to sync databases rather than doing it via scripts (dropping and recreating the db). Seems like Ids would get out of whack.

    The other question I had was if I make changes locally and then deploy my changes to a stage server, does uSync import the changes automatically or do I control that?

    Saied

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Sep 01, 2016 @ 21:38
    Alex Skrypnyk
    0

    uSync can import changes automatically, and you can import manually. uSync is configured via /config/uSyncSettings.config this has all the settings in it. The main settings are on the usync node:

     <usync read="true" write="false" attach="true" folder="~/uSync/"
archive="~/uSync.Archive" versions="true" preserve="true">
 </usync>

    Thanks,

    Alex

    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