Database Transfer

Victor Alba ( victor@webjogger.net )
Tue, 30 Jun 1998 17:10:23 -0400

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