[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Upgrading Goldmine 6.7 dbase to Goldmine 8.5 SQL

Posted on 2009-07-09
5
Medium Priority
?
2,124 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 750 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 750 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

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…
Decide what contact details to include in email signatures with these top 10 email signature contact details DOs & DON'Ts.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

650 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