Community
Showing results for 
Search instead for 
Do you mean 
Reply

Integrating another database for Sync

New Member
Posts: 13
Country: Australia

Integrating another database for Sync

Hello Everyone,

 

I have a requirement to sync another database to my ACT. At present I have just created a new database for that purpsose which is working fine. However, while having two databases of contacts is manageable, having two calenders is a pain.

 

So, I want to integrate the new database into my existing database and sync only the data in the new database. That looks doable using Sync Sets. However, I'm having trouble getting my head around the mechanics of it as my ACT will be the remote database. The publishing database is the one offisite.

 

Can I create a remote database (for the new database) and then restore that within my existing database? Will sync sets then only sync the records related to the new database based on some criteria?

 

Cheers,

 

Kurt 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Integrating another database for Sync

You need to merge the data into the Publisher, then create a new RDB with a sync set defined around the new records.

Maybe adding a field to highlight the records from the 2nd database to make it easier to create the sync set is a suitable method?