Re: [Emerald] import into emerald 2.5

Dale E. Reed Jr. ( (no email) )
Tue, 17 Aug 1999 09:26:45 -0700

Mourad Dahoumane wrote:
>
> This is all I need. I don't need any other information to be imported.

I know. :) The problem is that as I talked to the Engineer and was
looking more deeply into the import utility, it is focused on importing
user information from a single table into Emerald. This makes things
a little more complicated for the import utility when the source is a
two-table Emerald system.

Your case should not be that difficult, though. If you created an
Emerald25 database clean with the 2.5 admin, then you should be able
to do a query like:

Set Identity_INSERT MasterAccounts on
Go

Insert into MasterAccounts (CustomerID, a,b,c,...)
Select CustomerID,b,c,...