Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Colin Bull — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.