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] Does Firebird support geography and geometry?

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 16-7-2017 12:19, Andrea Raimondi andrea.raimo...@gmail.com 
[firebird-support] wrote:
> Just wondering if Firebird supports either :)
> 
> Anybody knows?

No, Firebird does not have data-types or indexes for - I assume - GIS 
purposes.

Mark

-- 
Mark Rotteveel

[firebird-support] Does Firebird support geography and geometry?

[Andrea Raimondi andrea.raimo...@gmail.com [firebird-support]]

Hello!

Just wondering if Firebird supports either :)

Anybody knows?

Thanks.

-- 
Mr. Andrea Raimondi
Senior Software Analyst

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