-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 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" <check_mail@...>
>>> ------------------------------------
>>>
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>
>>> 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 knowledgebases at
>> http://www.ibphoenix.com/resources/documents/
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> ------------------------------------
>>
>> Yahoo Groups Links
>>
>>
>>
>>
>>
>> ------------------------------------
>> Posted by: "checkmail" <check_mail@...>
>> ------------------------------------
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> 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 knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>
>
> ------------------------------------
> Posted by: "checkmail" <check_mail@...>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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 knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links