Re: [firebird-support] Re: FB 3.0

[Ricardo Uzcategui ricardou...@cantv.net [firebird-support]]

try using backup transportable (-T) and then, restore with fix_fss_m
-fix_fss_d options, same as you was do.

On Mon, Apr 25, 2016 at 5:32 AM, david.edi...@yahoo.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:

>
>
> Hi,
>
> Can anyone help? I'm trying to upgrade to FB 3 from 2.5.2 (classic) on a
> Centos 6.3 virtual machine.
>
> Attempting to use gbak (FB 3) to restore the .gdb file (FB 2.5.2) but
> getting the following error:
>
> gbak: ERROR:Malformed string
> gbak: ERROR:Invalid data detected. Use -FIX_FSS_DATA option.
>
> Tried to fix this by doing
> /usr/bin/gbak -r -fix_fss_metadata ISO8859_1 -fix_fss_data ISO8859_1
> mis_FB2.gbk mis_fixed.gdb
>
> But ended up with the same "Malformed string" error.
>
> Have also tried to create a .gbk file using FB 3, but got the following:
> gbak: ERROR:unsupported on-disk structure for file /opt/db/mis.gdb; found
> 11.2, support 12.0
>
> How to I migrate our FB2 database to using FB3??
>
> Thanks,
> Dave
>
>
> 
>



-- 
Ricardo...

Re: [firebird-support] Re: Firebird 3 and Encryption

[Ricardo Uzcategui ricardou...@cantv.net [firebird-support]]

We are very happy with a major release of firebird..

Thanks for the update.

On Mon, Nov 2, 2015 at 6:02 PM, Russell Weetch russ...@smxi.com
[firebird-support]  wrote:

>
>
> Many thanks for the update
>
>
> *Russell Weetch*SMXi – *the heartbeat of your business*
>
> *T: *+44 (0)20 7100 6010  *M:* +44 (0)7879 816084  *W:* http://smxi.com
> *E:* russ...@smxi.com
>
> [image: Linked In] 
> 
> 
> 
> 
>
> Systematic Marketing, 429-433 Pinner Road, Harrow  HA1 4HN, United Kingdom
>
> SMX, SMXi, Masque® and Masque Arts are trading names and trade marks of
> Systematic Marketing Ltd
>
> Registration No. 2472380 England / VAT 541 2972 49
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error, please notify me immediately. If
> you are not the intended recipient of this email, you should not copy it
> for any purpose, or disclose its contents to any other person.
>
>
>
> On 2 November 2015 at 16:25, Dmitry Yemanov dim...@users.sourceforge.net
> [firebird-support]  wrote:
>
>>
>>
>> 02.11.2015 19:21, Russell Weetch russ...@smxi.com wrote:
>> >
>> > Not sure whether I have been looking in the right place, but is data
>> > encryption included in Firebird 3?
>>
>> Technology is built in, but the encryption plugin should be developed by
>> you or someone else. Firebird itself does not provide any default
>> implementation [yet].
>>
>> > Also, any estimate of when the release candidate will be available?
>>
>> This week.
>>
>> Dmitry
>>
>>
> 
>



-- 
Ricardo...

Re: [firebird-support] FB 3 protocol benchmark

[Ricardo Uzcategui ricardou...@cantv.net [firebird-support]]

GREATE NEWS!!!

On Wed, Sep 9, 2015 at 1:03 PM, 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support]  wrote:

>
>
> For those interested to know how FB 3 protocol was improved to work
> better over internet:
>
> http://www.firebirdnews.org/firebird-3-protocol-benchmark/
>
> Spoiler: Now you should think twice before saying that MySQL is faster ;-)
>
> []s
> Carlos
> Firebird Performance in Detail - http://videos.firebirddevelopersday.com
> www.firebirdnews.org - www.FireBase.com.br
>
> 
>



-- 
Ricardo...

Re: [firebird-support] Re: Differences when adding a Primary Key

[Ricardo Uzcategui ricardou...@cantv.net [firebird-support]]

hi. Maybe you post an ilegal name or this name are not unique for entery
database objects name's. every object in firebird database must be unique.
no matters if the same name is used on diferent tables.

On Fri, Aug 21, 2015 at 12:24 PM, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support] 
firebird-support@yahoogroups.com wrote:



 Nobody knows?

 Nobody has any idea?

 Greetings.

 Walter.


 On Thu, Aug 20, 2015 at 10:45 AM, Walter R. Ojeda Valiente 
 sistemas2000profesio...@gmail.com wrote:

 Hello everybody

 For add a Primary Key to a table we can write:

 ALTER TABLE MyTable ADD PRIMARY KEY (ID);

 or we can write:

 ALTER TABLE MyTable ADD CONSTRAINT MyPK PRIMARY KEY (ID);

 In the first case, the Firebird puts the name of the Primary Key, in the
 second case we choose that name, but...

 Why sometimes the first case fails and the second case always work?

 Of course that the table has not a Primary Key yet and the ID column has
 not nulls neither duplicated values.

 But (just sometimes) the first case fails.

 Greetings.

 Walter.


 




-- 
Ricardo...