Solved

Upgrading Goldmine 6.7 dbase to Goldmine 8.5 SQL

Posted on 2009-07-09
5
2,082 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
  • 2
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
automationstation earned 250 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Used a different solution
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

GoldMine CRM has a fairly open database architecture , however in this case the email distribution list is stored in a quirky way and does not allow easy access for external use. This article will give details of this and provide a method to extr…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now