Subject | Re: [ib-support] Renaming a table |
---|---|
Author | lester@lsces.globalnet.co.uk |
Post date | 2001-07-24T05:57:31Z |
I would make my usual suggestion.
Build a clean blank database and pump the data in.
Marathon can be used to extract the SQL of the current one,
which you can then edit. Then I use IB_WISQL, to run the SQL
script to create the new database and to pump data from
'old' to 'NEW' and tidy field names and domains up at the
same time.
Whilst the pump it's self can take time, in the long run it
makes life a lot easier, and you end up with a nice
documented database.
This even works nicely if you need to go back to an IB5.6
site ( they have all been updated to 5.6 haven't they).
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Build a clean blank database and pump the data in.
Marathon can be used to extract the SQL of the current one,
which you can then edit. Then I use IB_WISQL, to run the SQL
script to create the new database and to pump data from
'old' to 'NEW' and tidy field names and domains up at the
same time.
Whilst the pump it's self can take time, in the long run it
makes life a lot easier, and you end up with a nice
documented database.
This even works nicely if you need to go back to an IB5.6
site ( they have all been updated to 5.6 haven't they).
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services