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?
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?
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
Hi Alex,
Im using Umbraco 7.2 . I will check that package out, thanks for the tip! :)
I have installed uSync succesfully... but what do I do now? :)
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
is working on a reply...