RE: A migration question

malcolm weallans wrote > I am working on a migration plan for a 24 by 7 site. > We are migrating from IDS 9.3 to IDS 9.4 and although it > would be possible to achieve this by a simple install of 9.4 > over 9.3 it is never that easy. > ...snipped > But last night in the bath I had a brainwave and I would like > your views. > > Could I create a 9.4 instance and migrate one table at a time > using synonyms to provide access to tables that are in the > other server? If I could do that then I can minimise the > duration of outages. I don't think I would save any time in > the long run but it might just be a little more feasible. > Do not forget if you are renaming tables to do an 'update statistics for procedure' Otherwise any SPLs will still be looking at the original tables. Bitten from Stevenage _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________ sending to informix-list