Richard Sensale
Network Administrator
VisitUs Internet, Inc.
5468 Schaefer Road
Dearborn, MI 48126 USA
(313) 945-5588
(313) 945-0202 fax
http://www.visitus.net
richards@visitus.net
-----Original Message-----
From: Victor Alba <victor@webjogger.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Tuesday, June 30, 1998 9:10 AM
Subject: Database Transfer
>I've searched the archives before daring to ask this question but all I
>could find were brief descriptions as to what to do in EM while trying to
>transfer the emerald database. I already know how to do that and actually
>this morning I did transfer the Emerald Database onto our new machine but
>when EM finished said "there were some errors that occured while
>transfering the database" then when I went and check emerald on the new
>machine I couldn't access any record at all, the names of the users are
>there but as soon as I try editing the record, everything is empty.
>
>SQL is showing these errors in it's log file:
>
>------------------------------------------------
>::Error::
>In file NS.Emerald.DR1 in statement on line 302
>Transfer Status: Creating DRI on destination database
>Attempting to define PRIMARY KEY constraint on nullable column in table
>'ServerAccess'.
>
>::Error::
>In file NS.Emerald.DR1 in statement on line 302
>Transfer Status: Creating DRI on destination database
>Unable to create constraint. See previous errors.
>
>::Error::
>In file NS.Emerald.FKY in statement on line 251
>Transfer Status: Creating Foreign Keys on destination database
>data exists in table 'dbo.Invoices', database 'Emerald', that violates
>FOREIGN KEY constraint 'FK__Invoices__Type__465D7A27' being added. ALTER
>command has been aborted.
>
>::Error::
>In file NS.Emerald.FKY in statement on line 251
>Transfer Status: Creating Foreign Keys on destination database
>Unable to create constraint. See previous errors.
>
>::Error::
>In file NS.Emerald.TRG in statement on line 1
>Transfer Status: Creating Triggers on destination database
>Invalid column name 'login'.
>---------------------------------------------
>
>
>Anyone knows the 'appropiate' steps to follow to transfer Emerald from one
>machine to another one?
>
>Regards,
>Victor
>
>