Re: [firebird-support] Rename table

[Alain Bastien alainbast...@gmail.com [firebird-support]]

this was the solution I proposed in  first instance.

Else what's in a name ? , if not what the table contains ?

The VCL BATCHMOVE does it fast a seemlessly in one click, if field names
are the same or

if  different then use the EMS  components !!!




2017-07-17 11:48 GMT+04:00 liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] :

>
>
> Hi,
>
> This whole discussion is strange to me.
> Rename table while are pending inserts to it?
> How. If statment like rename table exsist then after name has changed all
> applications must be recompiled to take this new name into account. This
> looks to me that discussion is not about real problem. Only academic
> discusion that will be good to have this possibility in engine.
>
> If change is realy needed then i suppose simplest solusion is
> Create table with same structure and run simple command
>
> Insert into new_table
> Select * from old_table
> Commit and use it.
>
>
> Regards,
> Karol Bieniaszewsli
>
> 
>

Re: [firebird-support] Rename table

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
This whole discussion is strange to me.Rename table while are pending inserts 
to it?How. If statment like rename table exsist then after name has changed all 
applications must be recompiled to take this new name into account. This looks 
to me that discussion is not about real problem. Only academic discusion that 
will be good to have this possibility in engine. 
If change is realy needed then i suppose simplest solusion isCreate table with 
same structure and run simple command
Insert into new_tableSelect * from old_tableCommit and use it.

Regards,Karol Bieniaszewsli
null

Re: [firebird-support] Rename table

[Alain Bastien alainbast...@gmail.com [firebird-support]]

then just make a BATCHMOVE (keep source) to test the time taken.

surely less time.

test integrity of data in the Target Table

Drop the Old full table.

I think a backup and restore will been necessary if there are millions of
rows!!!

Cheers

2017-07-16 13:53 GMT+04:00 Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr
[firebird-support] :

>
>
>
> Sent from my iPhone
>
> On 16 Jul 2017, at 11:58, Alain Bastien alainbast...@gmail.com
> [firebird-support]  wrote:
>
>
>
> Else *"What's in a NAME?"
> *
>
>
>
>
>
>
>
> 2017-07-16 12:47 GMT+04:00 Alain Bastien :
>
>> Hi,
>>
>> Block data entrance ?
>>
>
> Hello,
>
> We do not know how busy table is. There may be new data entered and data
> moving application is already working on an executed query data which
> doesn't include those new rows.
>
> Because of that possible data loose I would strong suggest one should stop
> new data entrance while doing such operation on a production database.
>
> Regards,
> Ertan
>
>
>
>> 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
>>
>> 
>

Re: [firebird-support] Rename table

[Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]]

Sent from my iPhone

> On 16 Jul 2017, at 11:58, Alain Bastien alainbast...@gmail.com 
> [firebird-support]  wrote:
> 
> Else "What's in a NAME?" 
> 
> 
> 
> 
> 
> 
> 
> 2017-07-16 12:47 GMT+04:00 Alain Bastien :
>> Hi,
>> 
>> Block data entrance ?

Hello,

We do not know how busy table is. There may be new data entered and data moving 
application is already working on an executed query data which doesn't include 
those new rows. 

Because of that possible data loose I would strong suggest one should stop new 
data entrance while doing such operation on a production database.

Regards,
Ertan


>> 
>> 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
>> 
> 
> 

Re: [firebird-support] Rename table

[Alain Bastien alainbast...@gmail.com [firebird-support]]

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.kucuko...@1nar.com.tr
[firebird-support] :

>
>
>
> Sent from my iPhone
>
> On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com
> [firebird-support]  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
>
> 
>

Re: [firebird-support] Rename table

[Alain Bastien alainbast...@gmail.com [firebird-support]]

Else *"What's in a NAME?"
*







2017-07-16 12:47 GMT+04:00 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.kucuko...@1nar.com.tr
> [firebird-support] :
>
>>
>>
>>
>> Sent from my iPhone
>>
>> On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com
>> [firebird-support]  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
>>
>> 
>>
>
>

Re: [firebird-support] Rename table

[Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]]

Sent from my iPhone

> On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com 
> [firebird-support]  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
> 
> 
> 

[firebird-support] Rename table

[Alain Bastien alainbast...@gmail.com [firebird-support]]

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 

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