If it were only SQL Server you could do this easily with the DTS applet. You can set up a transfer profile and sve it allowing you to run it manually or on a schedule. DTS is simple, but not automatic (beyond scheduling).
Also DTS doesn't allow for true synchronization - it's purely an import or export. You can add rows or overwrite everything, but can't really combine things. To do real replication between the machine you'll want to set up a "Subscription" (take a look in Books online about it). It's quite powerful and can work in both "push" and "pull" modes. I've not used it outside an enteprise environment however so I'm not sure how it would handle something like you're talking about. You'll most likely want to designate one machine as the "publisher" and set up the subscriptions there. The other machine would be the "subscriber" and copy data to itself (a "pull" subscription). This is simplest. You can also set up a "merge" subscription where both machines would be both publishers and subscribers - but I've never done this. I've played quite a bit with DTS, but only toyed with the publication model personally. I'm not sure if the equivelant exists for mySQL, but I would guess that there's something out there. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:143229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
