Re: Distributed systems - a small query

If you did the reverse of what you are talking about then you would not need to bounce the production server but bounce the development server instead. You would then say "insert into dbname@newserv:table select * from table", it would be a push not a pull. --- malcolm weallans <malcolm.iiug@btopenworld.com> wrote: > I have a customer who has created two systems, one > for > development and one for production. They have used > the same instance names, database names, path names > for dbspaces, even the same TCP/IP service names. > They wanted the development system to be a carbon > copy > of the live system. > > Now they want to extract data from the live system > and > transfer some data to the development system. But > their difficulty is how to do that. > > Does anybody have any bright ideas as to what we can > so that they can do INSERT INTO devtable SELECT * > FROM > prodtable ? > > So far the nearest I have got is to add a new > onsoctcp > service to the live system and use that for a new > alias in DBSERVERALIASES. Then use this new service > on the development box by adding to sqlhosts. Then > we > can use the syntax > > SELECT * FROM dbname@newserv> > That works but the live system is virtually 24 by 7 > and they will have to take the system down to get > the > new onconfig settings recognised. > > Any other ideas welcomed. > > regards > > Malcolm > sending to informix-list > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail sending to informix-list