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

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,246
    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. Lazy Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,437
    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,246
    Rep Power
    220
    Thanks, Requnix.

    I came out with a good solution.

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

    Join Date
    May 2017
    Posts
    12
    Rep Power
    0
    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