AW: AW: AW: AW: [firebird-support] Architecture

2016-01-08 Thread 'checkmail' check_m...@satron.de [firebird-support] 
-verbose :) I remember me. 

So I can see what table is he problematic one.

Have a nice weekend, Thomas, many Thanks :)

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 17:28
An: firebird-support@yahoogroups.com
Betreff: Re: AW: AW: AW: [firebird-support] Architecture

> Yes, Thomas,
>
> it woks with 2.1. In the release notes of 2.5.X is written:
>
> Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would 
> throw the error "value exceeds the range for valid timestamp".
>
> But where can I search 200 Tables...

Read Paul's blog on using -v for the restore etc ...


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.


> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 17:07
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: AW: [firebird-support] Architecture
>
>> now, the switches works fine, I had forget the Charset -fix_fss_d
>> ISO8859_1
>>
>> It works fine, but there is another problem to fix. Now I get the 
>> error, that value exceeds the range for valid timestamps. How can I 
>> fix
> this issue?
>
> * When does that happen during the restore?
> * Does a backup *AND* restore with Firebird 2.1 works?
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>> I have installed fb as cs without superclassic under 32 Bit Win7 the
>> 32 Bit Version
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com 
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:51
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: AW: [firebird-support] Architecture
>>
>>> Thanks. For some Years, we have had in use the superserver, but 
>>> since we have a quadcore CPU, we are using cs.
>>>
>>> UDFs can I replace with build in functions
>>
>> I guess you can imagine that you first need to do that before backing 
>> up and restoring?
>>
>>> Now, I have restored the database with 2.5, but.. Errors :( Now I 
>>> have seen the new switches -fix_fss_d and m, but now I get another 
>>> error, no character set were found.
>>
>> * What is the character set of your database used when you have 
>> created the database in the past?
>> * What is the exact error message?
>> * How did you install Firebird 2.5?
>>
>> Is there another way to migrate? With the scripts while
>>> running 2.1?
>>
>> backup/restore via gbak is the preferred solution, because it also 
>> moves data. Of course, you still can create an empty Firebird 2.5 
>> based database with a DDL script and then pump your data with a tool 
>> from your source into the destination database.
>>
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird FB TraceManager, IB 
>> LogManager, Database Health Check, Tuning etc.
>>
>>
>>
>>>
>>> thanks
>>>
>>> -Ursprüngliche Nachricht-
>>> Von: firebird-support@yahoogroups.com 
>>> [mailto:firebird-support@yahoogroups.com]
>>> Gesendet: Freitag, 8. Januar 2016 16:37
>>> An: firebird-support@yahoogroups.com
>>> Betreff: Re: [firebird-support] Architecture
>>>
>>> Hello Olaf,
>>>
>>>> Hello,
>>>>
>>>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
>>>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
>>>> installation of Firebird too?
>>>
>>> From an operational POV, a main factor with moving from 32-bit 
>>> to 64-bit is if you are using (third-party) UDF libraries. You need 
>>> them to be compiled with a 64-bit compiler if you want to run Firebird
64-bit.
>>>
>>> Other than that, I guess it depends on your planned load, especially 
>>> addressable RAM by the Firebird server process. If still intend to 
>>> run with ClassicServer, then each connection spawns its own process, 
>>> thus you probably won't hit the addressable RAM limit with Firebird
> 32-bit.
>>> That might be different with Firebird SuperCla

AW: AW: AW: [firebird-support] Architecture

2016-01-08 Thread 'checkmail' check_m...@satron.de [firebird-support] 
Yes, Thomas,

it woks with 2.1. In the release notes of 2.5.X is written:

Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw
the error "value exceeds the range for valid timestamp".

But where can I search 200 Tables...

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 17:07
An: firebird-support@yahoogroups.com
Betreff: Re: AW: AW: [firebird-support] Architecture

> now, the switches works fine, I had forget the Charset -fix_fss_d 
> ISO8859_1
>
> It works fine, but there is another problem to fix. Now I get the 
> error, that value exceeds the range for valid timestamps. How can I fix
this issue?

* When does that happen during the restore?
* Does a backup *AND* restore with Firebird 2.1 works?


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.

> I have installed fb as cs without superclassic under 32 Bit Win7 the 
> 32 Bit Version
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:51
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: [firebird-support] Architecture
>
>> Thanks. For some Years, we have had in use the superserver, but since 
>> we have a quadcore CPU, we are using cs.
>>
>> UDFs can I replace with build in functions
>
> I guess you can imagine that you first need to do that before backing 
> up and restoring?
>
>> Now, I have restored the database with 2.5, but.. Errors :( Now I 
>> have seen the new switches -fix_fss_d and m, but now I get another 
>> error, no character set were found.
>
> * What is the character set of your database used when you have 
> created the database in the past?
> * What is the exact error message?
> * How did you install Firebird 2.5?
>
> Is there another way to migrate? With the scripts while
>> running 2.1?
>
> backup/restore via gbak is the preferred solution, because it also 
> moves data. Of course, you still can create an empty Firebird 2.5 
> based database with a DDL script and then pump your data with a tool 
> from your source into the destination database.
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>
>
>>
>> thanks
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com 
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:37
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: [firebird-support] Architecture
>>
>> Hello Olaf,
>>
>>> Hello,
>>>
>>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
>>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
>>> installation of Firebird too?
>>
>>From an operational POV, a main factor with moving from 32-bit to 
>> 64-bit is if you are using (third-party) UDF libraries. You need them 
>> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>>
>> Other than that, I guess it depends on your planned load, especially 
>> addressable RAM by the Firebird server process. If still intend to 
>> run with ClassicServer, then each connection spawns its own process, 
>> thus you probably won't hit the addressable RAM limit with Firebird
32-bit.
>> That might be different with Firebird SuperClassic (32-bit), because 
>> this is a single process architecture.
>>
>> I connect with odbc. Known Issues while migration,
>>> metadata etc. ?
>>
>> The usual path is creating a gbak-based backup with Firebird 2.1 and 
>> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you 
>> can check with gstat -h afterwards).
>>
>> On the client side, make sure that you are using a version of the 
>> Firebird client library matching the server version. Bitness (32-bit vs.
>> 64-bit) of the client library is driven by your application and not 
>> by the Firebird server. So, if you are application is 32-bit (Delphi
>> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>>
>> Hope this helps.
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools

Re: AW: AW: AW: [firebird-support] Architecture

2016-01-08 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support] 
> Yes, Thomas,
>
> it woks with 2.1. In the release notes of 2.5.X is written:
>
> Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw
> the error "value exceeds the range for valid timestamp".
>
> But where can I search 200 Tables...

Read Paul's blog on using -v for the restore etc ...


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.


> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 17:07
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: AW: [firebird-support] Architecture
>
>> now, the switches works fine, I had forget the Charset -fix_fss_d
>> ISO8859_1
>>
>> It works fine, but there is another problem to fix. Now I get the
>> error, that value exceeds the range for valid timestamps. How can I fix
> this issue?
>
> * When does that happen during the restore?
> * Does a backup *AND* restore with Firebird 2.1 works?
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
> Database Health Check, Tuning etc.
>
>> I have installed fb as cs without superclassic under 32 Bit Win7 the
>> 32 Bit Version
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:51
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: AW: [firebird-support] Architecture
>>
>>> Thanks. For some Years, we have had in use the superserver, but since
>>> we have a quadcore CPU, we are using cs.
>>>
>>> UDFs can I replace with build in functions
>>
>> I guess you can imagine that you first need to do that before backing
>> up and restoring?
>>
>>> Now, I have restored the database with 2.5, but.. Errors :( Now I
>>> have seen the new switches -fix_fss_d and m, but now I get another
>>> error, no character set were found.
>>
>> * What is the character set of your database used when you have
>> created the database in the past?
>> * What is the exact error message?
>> * How did you install Firebird 2.5?
>>
>> Is there another way to migrate? With the scripts while
>>> running 2.1?
>>
>> backup/restore via gbak is the preferred solution, because it also
>> moves data. Of course, you still can create an empty Firebird 2.5
>> based database with a DDL script and then pump your data with a tool
>> from your source into the destination database.
>>
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird FB TraceManager, IB
>> LogManager, Database Health Check, Tuning etc.
>>
>>
>>
>>>
>>> thanks
>>>
>>> -Ursprüngliche Nachricht-
>>> Von: firebird-support@yahoogroups.com
>>> [mailto:firebird-support@yahoogroups.com]
>>> Gesendet: Freitag, 8. Januar 2016 16:37
>>> An: firebird-support@yahoogroups.com
>>> Betreff: Re: [firebird-support] Architecture
>>>
>>> Hello Olaf,
>>>
>>>> Hello,
>>>>
>>>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
>>>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit
>>>> installation of Firebird too?
>>>
>>> From an operational POV, a main factor with moving from 32-bit to
>>> 64-bit is if you are using (third-party) UDF libraries. You need them
>>> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>>>
>>> Other than that, I guess it depends on your planned load, especially
>>> addressable RAM by the Firebird server process. If still intend to
>>> run with ClassicServer, then each connection spawns its own process,
>>> thus you probably won't hit the addressable RAM limit with Firebird
> 32-bit.
>>> That might be different with Firebird SuperClassic (32-bit), because
>>> this is a single process architecture.
>>>
>>> I connect with odbc. Known Issues while migration,
>>>> metadata etc. ?
>>>
>>> The usual path is creating

AW: AW: [firebird-support] Architecture

2016-01-08 Thread 'checkmail' check_m...@satron.de [firebird-support] 
Hello,

now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1

It works fine, but there is another problem to fix. Now I get the error,
that value exceeds the range for valid timestamps. How can I fix this issue?

I have installed fb as cs without superclassic under 32 Bit Win7 the 32 Bit
Version

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 16:51
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] Architecture

> Thanks. For some Years, we have had in use the superserver, but since 
> we have a quadcore CPU, we are using cs.
>
> UDFs can I replace with build in functions

I guess you can imagine that you first need to do that before backing up and
restoring?

> Now, I have restored the database with 2.5, but.. Errors :( Now I have 
> seen the new switches -fix_fss_d and m, but now I get another error, 
> no character set were found.

* What is the character set of your database used when you have created the
database in the past?
* What is the exact error message?
* How did you install Firebird 2.5?

Is there another way to migrate? With the scripts while
> running 2.1?

backup/restore via gbak is the preferred solution, because it also moves
data. Of course, you still can create an empty Firebird 2.5 based database
with a DDL script and then pump your data with a tool from your source into
the destination database.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.



>
> thanks
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:37
> An: firebird-support@yahoogroups.com
> Betreff: Re: [firebird-support] Architecture
>
> Hello Olaf,
>
>> Hello,
>>
>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
>> installation of Firebird too?
>
>   From an operational POV, a main factor with moving from 32-bit to 
> 64-bit is if you are using (third-party) UDF libraries. You need them 
> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>
> Other than that, I guess it depends on your planned load, especially 
> addressable RAM by the Firebird server process. If still intend to run 
> with ClassicServer, then each connection spawns its own process, thus 
> you probably won't hit the addressable RAM limit with Firebird 32-bit.
> That might be different with Firebird SuperClassic (32-bit), because 
> this is a single process architecture.
>
> I connect with odbc. Known Issues while migration,
>> metadata etc. ?
>
> The usual path is creating a gbak-based backup with Firebird 2.1 and 
> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you can 
> check with gstat -h afterwards).
>
> On the client side, make sure that you are using a version of the 
> Firebird client library matching the server version. Bitness (32-bit vs.
> 64-bit) of the client library is driven by your application and not by 
> the Firebird server. So, if you are application is 32-bit (Delphi
> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>
> Hope this helps.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item on 
> the main (top) menu.  Try FAQ and other links from the left-side menu
there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>
>
> 
> Posted by: "checkmail" 
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item on 
> the main (top) menu.  Try FAQ and other links from the left-side menu
there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>








++

Visit http://www.firebirdsql.org and click the Documentation item on the
main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the

Re: AW: AW: [firebird-support] Architecture

2016-01-08 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support] 
> now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1
>
> It works fine, but there is another problem to fix. Now I get the error,
> that value exceeds the range for valid timestamps. How can I fix this issue?

* When does that happen during the restore?
* Does a backup *AND* restore with Firebird 2.1 works?


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

> I have installed fb as cs without superclassic under 32 Bit Win7 the 32 Bit
> Version
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:51
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: [firebird-support] Architecture
>
>> Thanks. For some Years, we have had in use the superserver, but since
>> we have a quadcore CPU, we are using cs.
>>
>> UDFs can I replace with build in functions
>
> I guess you can imagine that you first need to do that before backing up and
> restoring?
>
>> Now, I have restored the database with 2.5, but.. Errors :( Now I have
>> seen the new switches -fix_fss_d and m, but now I get another error,
>> no character set were found.
>
> * What is the character set of your database used when you have created the
> database in the past?
> * What is the exact error message?
> * How did you install Firebird 2.5?
>
> Is there another way to migrate? With the scripts while
>> running 2.1?
>
> backup/restore via gbak is the preferred solution, because it also moves
> data. Of course, you still can create an empty Firebird 2.5 based database
> with a DDL script and then pump your data with a tool from your source into
> the destination database.
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
> Database Health Check, Tuning etc.
>
>
>
>>
>> thanks
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:37
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: [firebird-support] Architecture
>>
>> Hello Olaf,
>>
>>> Hello,
>>>
>>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
>>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit
>>> installation of Firebird too?
>>
>>From an operational POV, a main factor with moving from 32-bit to
>> 64-bit is if you are using (third-party) UDF libraries. You need them
>> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>>
>> Other than that, I guess it depends on your planned load, especially
>> addressable RAM by the Firebird server process. If still intend to run
>> with ClassicServer, then each connection spawns its own process, thus
>> you probably won't hit the addressable RAM limit with Firebird 32-bit.
>> That might be different with Firebird SuperClassic (32-bit), because
>> this is a single process architecture.
>>
>> I connect with odbc. Known Issues while migration,
>>> metadata etc. ?
>>
>> The usual path is creating a gbak-based backup with Firebird 2.1 and
>> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you can
>> check with gstat -h afterwards).
>>
>> On the client side, make sure that you are using a version of the
>> Firebird client library matching the server version. Bitness (32-bit vs.
>> 64-bit) of the client library is driven by your application and not by
>> the Firebird server. So, if you are application is 32-bit (Delphi
>> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>>
>> Hope this helps.
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird FB TraceManager, IB
>> LogManager, Database Health Check, Tuning etc.
>>
>>
>> 
>>
>> 
>>
>> ++
>>
>> Visit http://www.firebirdsql.org and click the Documentation item on
>> the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>>
>> Also search the knowledgebases at
>> http://www.ibphoenix.com/resources/documents/
>>
>> ++
>> 
>>
>> Yahoo Groups Links
>>
>>
>>
>>
>>
>> 
>> Posted by: "checkmail" 
>> 
>>
>> ++
>>
>> Visit http://www.firebirdsql.org and click the Documentation item on
>> the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>>
>> Also search the knowledgebases at
>> http://www.ibphoenix.com/resources/documents/
>>
>>

AW: AW: [firebird-support] Architecture

2016-01-08 Thread 'checkmail' check_m...@satron.de [firebird-support] 
200 Tables :( Looking for timestamps before '16.11.1858 00:00:01'

 

Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 17:01
An: firebird-support@yahoogroups.com
Betreff: AW: AW: [firebird-support] Architecture

 

  

Hello,

now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1

It works fine, but there is another problem to fix. Now I get the error,
that value exceeds the range for valid timestamps. How can I fix this issue?

I have installed fb as cs without superclassic under 32 Bit Win7 the 32 Bit
Version

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com> 
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 16:51
An:  <mailto:firebird-support@yahoogroups.com>
firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] Architecture

> Thanks. For some Years, we have had in use the superserver, but since 
> we have a quadcore CPU, we are using cs.
>
> UDFs can I replace with build in functions

I guess you can imagine that you first need to do that before backing up and
restoring?

> Now, I have restored the database with 2.5, but.. Errors :( Now I have 
> seen the new switches -fix_fss_d and m, but now I get another error, 
> no character set were found.

* What is the character set of your database used when you have created the
database in the past?
* What is the exact error message?
* How did you install Firebird 2.5?

Is there another way to migrate? With the scripts while
> running 2.1?

backup/restore via gbak is the preferred solution, because it also moves
data. Of course, you still can create an empty Firebird 2.5 based database
with a DDL script and then pump your data with a tool from your source into
the destination database.

--
With regards,
Thomas Steinmaurer
 <http://www.upscene.com/> http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.

>
> thanks
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com> 
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:37
> An:  <mailto:firebird-support@yahoogroups.com>
firebird-support@yahoogroups.com
> Betreff: Re: [firebird-support] Architecture
>
> Hello Olaf,
>
>> Hello,
>>
>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
>> installation of Firebird too?
>
> From an operational POV, a main factor with moving from 32-bit to 
> 64-bit is if you are using (third-party) UDF libraries. You need them 
> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>
> Other than that, I guess it depends on your planned load, especially 
> addressable RAM by the Firebird server process. If still intend to run 
> with ClassicServer, then each connection spawns its own process, thus 
> you probably won't hit the addressable RAM limit with Firebird 32-bit.
> That might be different with Firebird SuperClassic (32-bit), because 
> this is a single process architecture.
>
> I connect with odbc. Known Issues while migration,
>> metadata etc. ?
>
> The usual path is creating a gbak-based backup with Firebird 2.1 and 
> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you can 
> check with gstat -h afterwards).
>
> On the client side, make sure that you are using a version of the 
> Firebird client library matching the server version. Bitness (32-bit vs.
> 64-bit) of the client library is driven by your application and not by 
> the Firebird server. So, if you are application is 32-bit (Delphi
> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>
> Hope this helps.
>
> --
> With regards,
> Thomas Steinmaurer
>  <http://www.upscene.com/> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>
> 
>
> 
>
> ++
>
> Visit  <http://www.firebirdsql.org> http://www.firebirdsql.org and click
the Documentation item on 
> the main (top) menu. Try FAQ and other links from the left-side menu
there.
>
> Also search the knowledgebases at
>  <http://www.ibphoenix.com/resources/documents/>
http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
&g