#1
  1. A Change of Season
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,534
    Rep Power
    221

    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. Impoverished Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,795
    Rep Power
    9646
    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 Expert (3500 - 3999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,534
    Rep Power
    221
    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
    45
    Rep Power
    45
    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