Re: Data migration (2)

From: jgmerritt@my-deja.com > >Do you have any references that I can read up on this and establish a >procedure for? Are you talking about a dbexport/dbinport? Nope, I'm saying set up both servers, create an empty schema without indexes and do the following for each table: insert into db@newserver:tablename select * from db@oldserver:tablename; Then create the indexes. >In article <907vfg$kdb$1@news.xmission.com>, > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > > > From: jimm@burton.com > > > > > >I am going to move a 300G+ Informix database from one system to >another, > > >and due to several constraints (that I am not pleased about but must > > >deal with), I am thinking of doing a dd copy from one set of disks to > > >another. Has anyone ever done this before and survived? > > > > Why not set the two machines up and do remote inserts across a network > > connection? > > > > >_____________________________________________________________________________________ > > Get more from the Web. FREE MSN Explorer download : >http://explorer.msn.com > > > > > > >Sent via Deja.com http://www.deja.com/ >Before you buy. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com