Community
Showing results for 
Search instead for 
Do you mean 
Reply

How to Sync two different databases one way in Act 2012 Premium

New Member
Posts: 2
Country: USA

How to Sync two different databases one way in Act 2012 Premium

We have two Act 2012 Premium databases (Sales& Support) on the same server .Support guys want their database to sync only one way (from support to sales).What ever changes they make everyday should sync with the sales db at the end of the day. So there is a need to establish one way sync from support db to sales db .Is this possible? If yes, I would appreciate if anyone let me know how to do it.

 

 

Nickel Elite Contributor
Posts: 508
Country: USA

Re: How to Sync two different databases one way in Act 2012 Premium

Sync is two-way by design and default.  What you might want to search on is an automated import tool that will periodically run a script to "update" the other database...

Richard Brust
ACT! Certified Consultant
richard@rbrDataSolutions.com
Silver Contributor
Posts: 1,813
Country: USA

Re: How to Sync two different databases one way in Act 2012 Premium

Highly reccomended to just have one database and use database permissions to delimit who sees what.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

New Member
Posts: 2
Country: USA

Re: How to Sync two different databases one way in Act 2012 Premium

Thanks for your advice guys .I`ll do as suggested .

Thanks a bunch.