Subject Re: [firebird-support] Rename table
Author Alain Bastien
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 minutes

Hi,

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