Community
Showing results for 
Search instead for 
Do you mean 
Reply

database merge to remote db?

New Member
Posts: 3
Country: USA

database merge to remote db?

One of our database users  created his own copy of the database on his laptop rather than using the remote db option.   What is the best way to incorporate his month or so updates?  We are using Act Pro 2011.  From what I gather from the forums, we

should

[backup both first]

a) create the remote DB,

b) move the RDB to the laptop,

c) import from his db with no cuplicate option to the laptop's RDB,

d) sync laptop to main db.   

 

Or is their a simpler way of just creating a RDB and then copying his db files under the RDB file structure and then syncing?

 

Appreciate your inputs.

Thanks,Dan

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: database merge to remote db?

Hello Dan,
Welcome to the Sage ACT! Community. Unfortunately, there is not a simpler way to do this. If the database is not a remote, then the only way to get the data in is to import it either into a proper remote database and sync or directly into the main database.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 3
Country: USA

Re: database merge to remote db?

Thanks Greig- we'll give it a go and import it...

Dan

Bronze Super Contributor
Posts: 1,679
Country: Australia

Re: database merge to remote db?

Hi Dan,

 your process you've listed will work.

 

However, sometimes I actually do a backup of the laptop users database,

restore that on the machine hosting the live database,

export the backup db into the live db,

create a new RDB for the laptop user,

copy the RDB to the laptop,

restore the RDB

 

What this accomplishes is that there is not a lot of data then needing to sync, it's all been done on the server.

If you only have 1 months data, then it may not be a problem. It's certainly easier to do it via your list above.

Just thought I'd give a different run through on how it could be done.

 

Ben.