Solved

Upgrading Goldmine 6.7 dbase to Goldmine 8.5 SQL

Posted on 2009-07-09
5
2,112 Views
Last Modified: 2013-11-15
We are attempting to upgrade Goldmine 6.7 dbase to Goldmine 8.5 SQL on a new server. The problem that we are experiencing is that no users accounts are migrating over during the import. Below are the steps that we have performed.

"      We copied over the Goldmine 6.7 folder to a new server.
"      We have installed Goldmine 8.5 SQL and SQL successfully with Demo files.
"      We created an alias database in SQL.
"      Using the rehost Goldmine Database wizard we have the following choices.

1.      Create or copy data for contact set  tables
2.      Create or copy data for base Goldmine table

"      We picked number 2.
"      On the next screen we choose our alias database.
"      Under select source of data for the new database we picked (copy data for 6x dbase tables).
"      On the next screen it wants the paths to the dbase files.

For CONTACT1.DBF we picked the name of our database folder.

For CAL.DBF we picked the GMBase folder

For USERS.DBF we picked the root of the goldmine folder which we can see our user account listed.

The import is error free.

When we log back into Goldmine it appears that all the data has been carried over except the user accounts. We were told that we need to move mail attachment folder and templates over also.

Are we missing a step that would cause the user accounts from not to be available in the database?
Is there a better way to perform the import?
0
Comment
Question by:usspare
[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
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
automationstation earned 250 total points
ID: 24829161
That sometimes happens when you upgrade. FrontRange Solutions can provide you with a Transact SQL script that will recreate the user table with just one user... Master/Access. You can then just add back your users. This is the quickest fix, especially if everything else. upgraded.

I can post the script here as well:

+++
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USERS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[USERS]
GO

CREATE TABLE [dbo].[USERS] (
      [USERNAME] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
      [NAME] [varchar] (26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [USERGROUP] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [INGROUPS] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [LASTIND] [datetime] NULL ,
      [LASTINT] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [LASTOUTD] [datetime] NULL ,
      [LASTOUTT] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [SOUNDEFFCT] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [USECURITY] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [OPTIONS] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [LASTUSER] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [LASTDATE] [datetime] NULL ,
      [LASTTIME] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [U_USERGROUP] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
      [recid] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE
  INDEX [USERS] ON [dbo].[USERS] ([USERNAME])
ON [PRIMARY]

GO

CREATE
  INDEX [USERGRUP] ON [dbo].[USERS] ([U_USERGROUP])
ON [PRIMARY]

GO

CREATE UNIQUE
  INDEX [USRRECID] ON [dbo].[USERS] ([recid])
ON [PRIMARY]

GO

insert into users (username, [name], usergroup, lastind, lastint, lastoutd, lastoutt, soundeffct, usecurity, lastuser, lastdate, lasttime, U_usergroup, recid) values ('MASTER', 'FrontRange Solutions Emplo', 'ALL', '11/4/2005', '12:23', '11/4/2005', '12:51', '0_5 630 34', ':`R,) `$*)# !<U)R P;_BZ$ ]+CH$0Y_), 7W_28 IG5Z=$8N*<A!P*:\7 $,2YO$J@HJG##U\#<#DSFX, T!RW* &8FK0!1?WI0$557G!!1?WI0$557G!!1?WI0$557G!!1?WI0$557G!!1?WI0$557G!!W)ND@$N3AI,#HP,MU!K^5A{!./5-*#RL<84$FS%{.!.V8\3 <F=2^!!?0X$ X=LH]$<`1L$!', 'MASTER', '9/23/1997', '12:15', 'ALL', '3MJ2QBCY4+6 C._')
GO
+++

As far as linked documents you can physically move them to the new server... you will then need to correct the links in GoldMine to point to the new location. The best tool for that is from Prior Analytics... their Linked Doc Mover:

http://www.prior-analytics.com/support.aspx?page=61
0
 
LVL 6

Assisted Solution

by:automationstation
automationstation earned 250 total points
ID: 24829197
Version v8.5.1.12 should also be applied to your v8.5 upgraded version. Several bug fixes and enhancements.
0
 

Author Comment

by:usspare
ID: 25203482
We were able to perform a 6.7 dbase to Goldmine 8.5 SQL in place upgrade.

Thanks for everyones suggestions.

0
 

Author Closing Comment

by:usspare
ID: 31601700
Used a different solution
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Goldmine data 8 683
Contact Management Solution 2 394
Resolving error message when trying to connect Access 2007 to Outlook 2007 10 1,146
Inventory Management 6 106
The need for Texting We all wear many hats. Part of this article's focus is the marketing hat... and another part is the consumer hat. Those of us who are consumers frequently are either ambivalent toward, or hiding from... those of us who are mark…
Decide what contact details to include in email signatures with these top 10 email signature contact details DOs & DON'Ts.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Suggested Courses

738 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