Link to home
Start Free TrialLog in
Avatar of daiwhyte
daiwhyteFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Goldmine Setup Problems

Ive setup a goldmine instance to test our DR but their appears to be quite a bit of difference between the two setups in terms of what the user see's when they log in.

It looks like our live setup has been customised, the contact windows at the top are different for starters .

How can I copy over the customization from our live server to our DR test?

Thanks
Avatar of Steven Graff
Steven Graff
Flag of United States of America image

It's not enough to use the File | Open database command in GoldMine. You must use, in the icon's command line:

c:\goldmine\gmw7.exe /g:alias /c: alias

This will cause both sets of tables (gmbase and contacts) to both come from the same db. If your test db is using the production db for its gmbase tables... watch out!!!


Avatar of daiwhyte

ASKER

Hi Stephen, not sure that comment was meant for me?
ASKER CERTIFIED SOLUTION
Avatar of GMGenius
GMGenius
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ive created a backup of the live sql database, Im just in the process of uploading the file to my test server and then will restore and clear out the live data.

Keep you posted guys.
quickest way to clear down the data on a test system is to truncate the correct tables
truncate table contact1
contact2
contsupp
conthist
contgrps
cal
mailbox
opmgr
opmgrfld
gsserver
gssites
gsfilter
gmtlog
conttlog
syslog

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Im struggling to restore the database, Im getting the following error message


experts.jpg
Be sure to tick the overwrite database on the options page
Try the "from device" option, rather than "from database"
What version of SQL is it? 2005 or 2008?
Ensure you tick Overwrite and ensure the "Restore As" path is the test system MDF / LDF location
2005 leaves the restore as to the origincal path, 2008 tends to do it write :-)

ScreenHunter-01-Oct.-30-14.59.gif
ScreenHunter-02-Oct.-30-14.59.gif
Ok, got it chaps, I think it was a combination of your comments which got me there. Can we split?
no probs with me, your choice at the end of the day :-)
Thank you all.