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 > > > > > > ------------------------------------ > Posted by: "checkmail" < <mailto:check_m...@satron.de> check_m...@satron.de> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > 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 > > > ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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