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?
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
The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
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…