Solved

Migrate Goldmine Premium Edition 8.03 Databases and Application

Posted on 2011-03-22
4
1,036 Views
Last Modified: 2013-11-15
I am really hoping that someone will be able to assist me as I have exhausted the use of google and have used up all of my free support calls to the vendor.

I have a Goldmine Premium Edition 8.03 installation currently running on a Windows 2003 Server using a SQL 2000 server as the database backend.

What I need to do is 1. Move the Goldmine databases from the SQL 2000 Server to the new build SQL 2008 Server which is clustered (don't know if that makes a difference or not)

2. Move the Goldmine application to a new build Windows 2003 Server with a new name and also on a new domain.

3. I then need to verify that the migration has been successfull and that all attached documentation has been moved accross and that all users can access the system, etc.

If anyone has any experience doing this and can provided detailed instructions on how to complete this, it would be more than appreciated.
0
Comment
Question by:CharlieMShanks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 12

Expert Comment

by:GMGenius
ID: 35197588
You really need a GoldMine profesional to assist here, things often can and do go wrong.

 
0
 
LVL 11

Accepted Solution

by:
stevengraff earned 500 total points
ID: 35198601
In general:

1. Move the SQL db by performing a backup on your current system and restore to your new system.

2. Using your current GoldMine, go in to the alias manager (Tools | Databases | Alias Manager) and create a new temp alias pointing to the new server/database location. Make sure you can open it!

3. Edit your desktop shortcut as follows: x:\goldmine\gmw.exe /g:tempalias /c:tempalias and run GoldMine from this shortcut.

4. Be sure you're "seeing" GoldMine via your tempalias: Help | About | System

5. Use the Alias Manager now to edit your original alias.

6. Fix your shortcut so that it points to the original alias.

This completes the part for moving the db.

=======================

1. Copy/paste your GoldMine folder (and all subfolders)

2. Check the gm.ini file for references to unc paths, and fix as appropriate

3. Map the drive letter appropriately for end-user connections

4. You'll need to know where users have been linking their documents. GoldMine just passes the path into Windows, so if the paths are valid, the docs are linked, and will open.

Select contsupref,address1+address2 [Location] from contsupp where rectype = 'L'

is a query to give you some insight into where the links are being stored. There's a free link mover tool you can use to mass edit your links, if need be, from Prior Analytics web site.

Good luck. In case you have trouble, btw, I agree completely with GMGenius.
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 35938033
Hey Charlie, did you ever try this out?
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime is disastrous for companies and can lead to major hits on a brand, reputation, an…
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question