Upgrading Goldmine 6.7 dbase to Goldmine 8.5 SQL

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