Copied to clipboard

Flag this post as spam?

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


  • Paul Lagmark 65 posts 140 karma points
    Jul 23, 2015 @ 09:12
    Paul Lagmark
    0

    Upgrading database

    Hi guys,

    I have two databases. One that I develope against and one that is running a site on our webserver.

    I have now installed packages and added new datatypes and so on in the database I develope against. Now I want to upgrade the other database to be like the one i developed to. The markup and razor scripts etc is on the webserver but the data is not in the database.

    In my noobishness I thought that the solution would be easy by using SQL compare and then transfer all changes to the other database. This seems not to be quite as easy as I thought. The database structure is the same, but it differs in the data in different tables.

    Anyone who have done this before? How did you do to solve it?

  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Jul 23, 2015 @ 11:49
    Alex Skrypnyk
    0

    Hi Paul,

    Which version of Umbraco are you using?

    Try to use uSync - https://our.umbraco.org/projects/developer-tools/usync

    Great package for synchronisation datatypes between databases.

    Thanks, Alex

  • Paul Lagmark 65 posts 140 karma points
    Jul 23, 2015 @ 13:49
    Paul Lagmark
    0

    Hi Alex,

    Im using Umbraco 7.2 . I will check that package out, thanks for the tip! :)

  • Paul Lagmark 65 posts 140 karma points
    Jul 23, 2015 @ 14:07
    Paul Lagmark
    0

    I have installed uSync succesfully... but what do I do now? :)

  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Jul 23, 2015 @ 15:33
    Alex Skrypnyk
    100

    Open you dev site, go to the developers section, uSync tab, press Export button.

    http://screencast.com/t/AtQeTYZH

    Then upload uSync folder to the live server, and go to the developers section, uSync tab, press Import button.

    And you will have all you doctypes and other ))

    You can import css and templates in this way, but I like only docTypes.

    Thanks, Alex

Please Sign in or register to post replies

Write your reply to:

Draft