| Replicating a complete GMPE instance to a remote server | |
Posted: Thu May 26, 2016 1:51 pm |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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 |
|
|
|
|
Posted: Fri May 27, 2016 10:02 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
You could start with a one-button-sync setup without linked docs. |
|
|
|
|
Posted: Fri May 27, 2016 10:29 am |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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 |
|
|
|
|
Posted: Fri May 27, 2016 10:31 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
making a transfer set and rolling out a one-button sync installation aren't the same thing |
|
|
|
|
Posted: Tue May 31, 2016 9:49 am |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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 |
|
Last edited by cdohmen on Tue May 31, 2016 9:51 am; edited 1 time in total |
|
|
|
Posted: Tue May 31, 2016 9:51 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
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. |
|
|
|
|
Posted: Tue May 31, 2016 9:52 am |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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 |
|
|
|
|
Posted: Tue May 31, 2016 9:56 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
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. |
|
|
|
|
Posted: Tue May 31, 2016 10:01 am |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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. |
|
|
|
|
Posted: Thu Jun 02, 2016 7:11 am |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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. |
|
|
|
|
Posted: Thu Jun 02, 2016 7:55 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
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:
Code: |
INSERT Into USERS select * from server2.goldmine.dbo.users |
|
|
|
|
|
Posted: Fri Jun 03, 2016 6:52 am |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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 |
|
|
|
|
Posted: Fri Jun 03, 2016 8:56 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
|
|
|
|
Posted: Fri Jun 03, 2016 12:31 pm |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
Thanks Doug I'll give it a try. |
|
|
|
|
Posted: Fri Jun 03, 2016 12:42 pm |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
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. |
|
Last edited by cdohmen on Fri Jun 03, 2016 1:21 pm; edited 4 times in total |
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|