Re: Exchanging data between two instances

It should work unless the logging modes are incompatible. If it is a version thing between IDS7 and IDS8 you may be able to use my dbcopy.ec utility to do the copy. Since it maintains separate connections to each server it is not bothered by things like version and logging incompatibilities. As a bonus it inserts data about 3x faster than insert into...select .. from. WAIT JUST ONE COTTON PICKIN' CHICKEN FLICKIN MINUTE THERE! If that is not a typo the syntax is backwards. Make it: insert into ourtable select * from yourdb@yourserver:ourtable; My comments about dbcopy.ec's speed still hold if this is not a one-time thing. Art S. Kagel Rob Gale wrote: > > Please forgive my naivete, but is it at all possible to do something like: > > connect to mydb@myserver; > select * from yourdb@youserver:ourtable > insert into ourtable;> > It seems that this would be a logical thing to want to do. Obviously I have > tried this and failed, but is that because my approach is wrong ? What about > exchange between different instance versions, e.g. 7 and 8 > > Regards, > Rob Gale