Re: Bulk Table copy.

Dale E. Reed Jr. ( (no email) )
Wed, 15 Jul 1998 12:48:45 -0700

Ian Pizey wrote:
> It should look like this.
> OLD emerald database pre consolidation ----- into ----- new call details
> table

Create a Database Called EmeraldCallDetails. Restore your calls table
into that database and create the CallDetails table in there as well.
Then do the Insert into CallDetails from Calls to put the records you
want in. Finally, delete the CallsTable from the new database.

Now, just modify the trigger, so that its like this:

Insert into EmeraldCallDetails..CallDetails(field, field,)
VALUES (value, value)

You can just adding the "EmeraldCallDetails.." in front of
the table name in the Emerald database, Calls table trigger.

This has the advantage of keeping the data seperated.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |