| Subject | Re: [firebird-support] Rename table |
|---|---|
| Author | Alain Bastien |
| Post date | 2017-07-16T08:47:01Z |
Hi,
Block data entrance ?
I have never tested a situation where data is entering a database/ table
and I rename a single field , or column or table and even the Database itself
Can you please guest or anticipate the respond of the server's or the application's error handling and/or exceptions ?
Would there be ?
regards
2017-07-16 11:41 GMT+04:00 Ertan Küçükoğlu ertan.kucukoglu@... [firebird-support] <firebird-support@yahoogroups.com>:
Sent from my iPhone
On 16 Jul 2017, at 07:40, Alain Bastien alainbastien@... [firebird-support] <firebird-support@yahoogroups. com> wrote:Create a new table with same structure from METADATA
Use "Batchmove" (In Delphi VCL) with Delete Source enabled
Connect the two tables, MOVE DATA
Drop the empty table.
COMMIT!!!
This would take merely 15 minutesHi,If table is a big one with millions of rows, 15min cannot be enough moreover down time might not be possible as you should block data entrance while doing that.Regards,Ertan
Alain Bastien
34, Dr Ross Avenue
ROSE HILL 72102
MAURITIUS
Skype: alainbastien
Phone: 230 57 19 30 30
Res :230 464 68 30
Sent from iPhone