Subject AW: AW: [firebird-support] Architecture
Author checkmail
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" <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