Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sync Databases

Copper Contributor
Posts: 58
Country: USA

Sync Databases

Maybe someone can answer this. What is the difference between "save a copy" of a database vs. creating a remote database?

Isn't it possible to save a copy of a main database and then sync that copy back to the master database?

Does the remote database .RDB file contain more information than just a simple .pad copy? Just trying to find a simple and efficient way for our salesmen to have current contact information when away from the office and then be able to sync their changes back to our main database on the server. Thank you.

 

 

Silver Contributor
Posts: 1,813
Country: USA

Re: Sync Databases

Huge difference in functionality.  A sync database is a full copy (very little you can't do) but it is designed to stay up to date with the master at a touch of a button.  changes to the database structure, like new fields and layout, new and changed reports plus all your data and attachments stay "in sync" and up to date.  Its not terribly hard to setup, but very much worth it if you intend to work on your database in two places.

 

Save a copy ONLY if you never want to update the master.  It is much harder to get data back into the master if you are working off a copy of the original.  Although a sync database is slightly harder to setup, it works and is much easier to keep up than save a copy.

 

YOU SHOULD NEVER SAVE A COPY WITH THE INTENT OF WORKING ON IT AND THEN HOPING THAT EVERYTHING WILL GO BACK INTO HTE MASTER LATER.  IT MOST LIKELY WONT.

 

 

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

Copper Contributor
Posts: 58
Country: USA

Re: Sync Databases

Thanks for answering that, just one other thing. Is it true that ACT! 2012 Premium offers a "live" sync that operates in the cloud and can sync databases much like Outlook Exchange in the cloud updates changes? And is there a subscription for that service?

Silver Contributor
Posts: 1,813
Country: USA

Re: Sync Databases

ACT has a Hosting Provider program where your database can be hosted in a secure datacenter.  There is also a Sage branded but 3rd party hosting program that offers the same thing.

 

There is a monthly hosting fee that usually included datacenter hosting of your ACT database, updates, backups and much of your support needs.

 

Cost can vary depending on the level of service etc.  Please take a look at the hosting provider page.

http://na.sage.com/sage-act/partners/hosting-providers/directory/

 

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

Copper Contributor
Posts: 58
Country: USA

Re: Sync Databases

Great. Thank you for the information.