#1
  1. A Change of Season
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,277
    Rep Power
    220

    Synch 2 databases


    Hi;

    I have 2 databases, 1 app and 1 dev.

    App has client data as in dev has dummy data but newer structure.

    How can I copy the structure of dev to app db without losing any app data?

    Thanks
  2. #2
  3. Maddening Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,549
    Rep Power
    9645
    There are some automated tools but I always do it manually: craft whatever ALTERs and UPDATEs and whatever are needed to replicate the changes.
  4. #3
  5. A Change of Season
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,277
    Rep Power
    220
    Thanks, Requnix.

    I came out with a good solution.

    I exported both structures, then checked them here.
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2017
    Location
    Worldwide
    Posts
    41
    Rep Power
    44
    Originally Posted by English Breakfast Tea
    Thanks, Requnix.

    I came out with a good solution.

    I exported both structures, then checked them here.
    I use Navicat. Very easy to Sync DB's as well as do any other DB tasks.

IMN logo majestic logo threadwatch logo seochat tools logo