Re: Bulk Table copy.

Ian Pizey ( )
Wed, 15 Jul 1998 15:55:36 -0500

Thanks, that's looks like the ticket.

Let you know how it works out...

At 12:48 PM 7/15/98 -0700, you wrote:
>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 |
Ian Pizey
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8
Ph 807-468-8900
Fx 807-468-7700