Re: [firebird-support] Blob write to Embedded on Linux performance

[Mike Ro miker...@gmail.com [firebird-support]]

Yes, of course, but I never felt the need to time the operations, we


are using a udf s.th. like:

void EXPORT fn_b_load ( char* s , BLOB b )
{
unsigned char *buffer;
if ( b->blob_handle )
{
int buffsize = 4096;
FILE *file;
unsigned char *fname = intern_recode(s);
file= fopen ( fname, "rb" );
if ( file )
{
buffer= ( unsigned char * ) malloc ( buffsize );
if ( buffer )
{
int readSize;
for ( ;; )
{
readSize = fread ( buffer,1,buffsize, file );
( *b->blob_put_segment ) ( b->blob_handle, buffer,readSize );
if ( readSize != buffsize )
break;
}
free ( buffer );
}
fclose ( file );
}
free( fname);
}
}

Unfortunately I haven't had any success in trying this because 
blob_put_segment() is causing Firebird embedded to throw an instance of 
"Firebird::status_exception" followed by a core dump that I really can't 
get to the bottom of. All the other blob functions work fine (such as 
blob_get_segment) and return correct results.

Re: [firebird-support] Firebird export/import tool

[Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]]

Hard to say, 'cause you're not pointing out what kind of problem you
encounter...

Cheers, Thomas

Am 03.06.2014 13:30, schrieb milossi...@yahoo.com [firebird-support]:
>  
> 
> Hello,
> 
>  
> 
> We are using a firebird database for our application programmed in .NET.
> We are using this tool for exporting database to sql
> (http://fbexport.sourceforge.net/)
> 
> The problem is, that it always has problems with importing the data
> back, when there are decimal number used (double precision). Is there
> some another solution how to export and import data, that is more stable ?
> 
>  
> 
> Thanks.
> 
> 
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckm...@assfinet.de 

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
i...@assfinet.de  • www.assfinet.de


Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

[firebird-support] Firebird export/import tool

[milossi...@yahoo.com [firebird-support]]

Hello,
  
 We are using a firebird database for our application programmed in .NET. We 
are using this tool for exporting database to sql 
(http://fbexport.sourceforge.net/ http://fbexport.sourceforge.net/)
 The problem is, that it always has problems with importing the data back, when 
there are decimal number used (double precision). Is there some another 
solution how to export and import data, that is more stable ?
  
 Thanks.
 

Re: [firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?

[Alexandre Benson Smith ibl...@thorsoftware.com.br [firebird-support]]

Em 30/5/2014 04:26, loris.lu...@gmail.com [firebird-support] escreveu:



I need your help and/or suggestions to solve a (maybe uncommon) task.

I searched a lot on the web and  I had some success using a tool 
called fbclone but
this is definitely not a solution (due to extreme slowness of the 
conversion, many days,

something must be wrong with this software)

I have a large Firebird 2.5 DB (a couple of tables have few millions 
records) to convert from WIN1251 charset to UTF8 charset.


Is there a way to do efficiently this kind of conversion? (preferably 
not using a intermediate text sql dump, that would not applicable 
because the size of the DB).


I'm using Firebird on a linux machine, and I really like to do the job 
using a bash script,

but I can fallback also using a remote Windows pc.

Thanks for any suggestions.

Best regards.



I don't know if there is a faster way... But this one would be a secure 
and very easy way:


1.) Extract metadata from the source database (isql -x)
2.) Change the definition of the domains and/or fields to the desired 
charset

3.) Create a new database with the corrected script
4.) Use IBDatapump (or any other datapump tool) to transfer the data

I don't know the size of your database, but I doubt it will take days to 
transfer it.


To speed up the process, turn forced writes off, try to keep the 
source/destination database on diferent disks and use local/embedded 
connection


see you !

RE: [firebird-support] FB database Replication

[Halim Boumedjirek halim1...@hotmail.com [firebird-support]]

Thanks Helen.I was looking for FB database replication tools in general.-Halim

To: firebird-support@yahoogroups.com
From: firebird-support@yahoogroups.com
Date: Mon, 2 Jun 2014 13:57:07 +1200
Subject: Re: [firebird-support] FB database Replication














 

 



  



  
  
  At 01:36 p.m. 2/06/2014, halim1...@hotmail.com [firebird-support] wrote:



>Hello All,

>I was looking for a good replication tool to replicate our FB database. I came 
>across FBReplicator from IBPhoenix. The tools is not that simple to setup but 
>it works good if setup properly.

>The only question I have regarding this tool is whether it allows metadata 
>replication or not.



No, it doesn't.



> If I change a field size in the master DB, is there a way to replicate the 
> same changes on the target DB?



Not within the IBPReplicator software.  But this is totally the wrong place to 
be asking tech support questions about third-party applications.  You should 
join the Replicator mailing list for help with that software.



List-Subscribe: , 

 



Helen Borrie, Support Consultant, IBPhoenix (Pacific)

Author of "The Firebird Book" and "The Firebird Book Second Edition"

http://www.firebird-books.net

__ 







 









  

Re: [firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?

[marcus mar...@antiphasis.net [firebird-support]]

loris.lu...@gmail.com [firebird-support] wrote:
> I need your help and/or suggestions to solve a (maybe uncommon) task.
>
> I searched a lot on the web and I had some success using a tool called
> fbclone but
> this is definitely not a solution (due to extreme slowness of the
> conversion, many days,
> something must be wrong with this software)
>
> I have a large Firebird 2.5 DB (a couple of tables have few millions
> records) to convert from WIN1251 charset to UTF8 charset.
>
> Is there a way to do efficiently this kind of conversion? (preferably
> not using a intermediate text sql dump, that would not applicable
> because the size of the DB).
>
> I'm using Firebird on a linux machine, and I really like to do the job
> using a bash script,
> but I can fallback also using a remote Windows pc.
>
> Thanks for any suggestions.
>
> Best regards.
Hej,

maybe this one is of help:
http://www.ibphoenix.com/resources/documents/design/doc_150

hth, Marcus

>
>
>