Sign in Register
Copied to clipboard

Flag this post as spam?

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


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Kent 30 posts 54 karma points
    Jun 27, 2013 @ 05:05
    Kent
    0

    How to merge orders from different databases

    We have a client site that was in production. I took a snapshot of the production database and proceeded  to upgrade umbraco & uCommerce to the latest versions. In the meantime, there have been new orders submitted on the production site. So I need to be able to import those new orders from the current production database into the newly upgraded database (not to mention selectively delete the test orders I've submitted) and then re-deploy to prod. Can anybody point me in the right direction?

    Copy Link
  • Rich Green 2246 posts 4008 karma points
    Jun 27, 2013 @ 10:17
    Rich Green
    0

    Hey Kent,

    Not necessarily a uCommerce solution but maybe something like http://www.red-gate.com/products/sql-development/sql-data-compare/ ?

    Rich

    Copy Link
  • Kent 30 posts 54 karma points
    Jun 27, 2013 @ 17:29
    Kent
    0

    Yeah this is what I'm leaning towards. Convincing my boss to spend the money is the only challenge. I'm also going to look into using the uConnector for future issues likes this.

    Copy Link
  • Rich Green 2246 posts 4008 karma points
    Jun 27, 2013 @ 17:32
    Rich Green
    0

    Hey Kent,

    I think they have a 14 day trial, so you could get this task done at least for free :)

    Rich

    Copy Link
  • Morten Skjoldager 440 posts 1499 karma points
    Jun 28, 2013 @ 09:58
    Morten Skjoldager
    0
    Hi Kent,
    uConnector is now available for download here:
    And there's some samples here for you to look at:
    Also we have an introduction video here: 
    Last but not least we have a webinar comming up where one of the lead devs will do a little dive and introduction on how to use it:
    On thursday 11th. 
    If you want more info please contact Thomas at: tnj at ucommerce dot dk
    Regards
    Morten
    Copy Link
  • Kent 30 posts 54 karma points
    Jul 01, 2013 @ 17:15
    Kent
    2

    Just to follow up, I was able to use RedGate's SQL Data Compare to accomplish this. Luckily, there were no schema changes and the RedGate tool made merging the data a breeze. Highly recommend that tool!

    Copy Link
  • Søren Spelling Lund 1797 posts 2786 karma points
    Jul 05, 2013 @ 11:41
    Søren Spelling Lund
    0

    Hi Kent,

    Thanks for being awesome and following up with your finding on the forum. #h5yr!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft