ContactReview :: View topic - Replicating a complete GMPE instance to a remote server

cdohmen · Cuckoo for GoldMine Puffs

I haven't had to do this in quite sometime, so I wanted to solicit the advice of the experts.

I've created a new remote GMPE server and I wish to make a mirror copy of the database and maintain it through a server to server (IP to IP) connection using Goldsync.

What are the best practices (methods) to get the data initially to the remote server?.....
one big Goldsync transfer set or use SQL?

Thanks in advance.

CD

DougCastell · GoldMine Guru

You could start with a one-button-sync setup without linked docs.

cdohmen · Cuckoo for GoldMine Puffs

Doug:

I created a transfer set and unchecked the linked documents as you suggested but after it was applied to the new server I noticed that none of the user accounts had transferred. The User option was selected for both sending and receiving.

Chris

DougCastell · GoldMine Guru

making a transfer set and rolling out a one-button sync installation aren't the same thing

cdohmen · Cuckoo for GoldMine Puffs

Doug:

My One Button Sync is greyed out so is it safe to assume that Goldsync must run as a service on the server to get this option.

I've always run Goldsync from within the Goldmine app itself on the server.

DJ always recommended against Goldsync as a service so I've never done it that way. He also never covered setting up One Button Sync, so I'll have to look at the Goldmine Admin docs.

Thanks

Chris

DougCastell · GoldMine Guru

the option to execute a one-button sync that you see in the menu is only available if you are a one-button-sync remote user.

The process of creating a one-button sync installation requires more than one button. Refer to the admin guide (I think) on that.

cdohmen · Cuckoo for GoldMine Puffs

Doug:

Yes I'm going that route. You're too quick to reply here lol I had edited my previous reply to say just that.

Thanks

CD

DougCastell · GoldMine Guru

I have mixed feelings on Goldsync as a service, personally... It's much more stable that way, but linked docs can be problematic under that model...

So, you end up choosing whether you want to babysit it or let the users deal with sometimes inconsistent linked doc availability.

It's a debate for the ages.

cdohmen · Cuckoo for GoldMine Puffs

We do not synchronize linked documents in our environment and there's little tolerance for pain at the enduser level so I stayed with the babysitting. I like the fact that you can view the realtime logs to know for sure everything is healthy.

cdohmen · Cuckoo for GoldMine Puffs

I do not want to start from scratch since my remote server was already created and Goldmine was installed and synced with 200,000 records. Found an FRS support article that suggested editing each user account from the host and by doing so it would trigger a transfer of the User ID to the remote.

Seeing how that pans out. Last alternative is to recreate the User IDs and they will be pushed out to the remotes.

DougCastell · GoldMine Guru

so the users table is the only table you're having trouble with at this point? you could use SQL to copy/backup just that table. It'd be extra-simple if the two servers were connected as linked servers:

cdohmen · Cuckoo for GoldMine Puffs

Doug:

I can certainly connect hem but other than a mapped drive how would you suggest linking them. I'm certainly not as proficient at SQL as I was with dBase back in the day.

CD

DougCastell · GoldMine Guru

https://www.google.com/search?&q=creating+a+linked+server&sourceid=opera&ie=UTF-8&oe=UTF-8

cdohmen · Cuckoo for GoldMine Puffs

Thanks Doug I'll give it a try.

cdohmen · Cuckoo for GoldMine Puffs

Linked the servers easily but received this message executing the Query you gave me.

Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated

This is surprising since the table layouts are identical, but the field order is slightly different though. Made the field order the same and it still failed.