Re: Re: [firebird-support] Replication SW experience

[Sudheer Palaparambil sudheer....@gmail.com [firebird-support]]

Hi,

Please have a look at SymmetricDS (http://www.symmetricds.org/). I have
been using it for the past 4 years with Firebird.

Thanks and regards.

Sudheer Palaparambil

On Thu, Nov 26, 2015 at 9:05 PM, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support]  wrote:

>
>
> hi,
>
> modification datetime is not enaugh to replication. think about
>
> 1. transaction started and modify data
> 2. synchronization started and fetch data from last modifird datetime
> 3. synchronization end
> 4. transaction commit data from point 1 and store datetime before synch
> started
> 5. synchronization start and omit modification from point 1 because date
> is older
>
> regards,
> Karol Bieniaszewski
>
>
>
> Pozdrawiam
>
>
>  Oryginalna wiadomość 
> Od: "Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]" <
> firebird-support@yahoogroups.com>
> Data: 26.11.2015 12:46 (GMT+01:00)
> Do: firebird-support@yahoogroups.com
> Temat: Re: [firebird-support] Replication SW experience
>
>
>
> Hi Aldis,
> more info about situation.
>
> 1. Normal operation
> - Asynchronous replication will wait for DB Event and than
> immediately start transfer.
> All data changes will be logged by triggers into log table.
>
> 2. Disaster
> Local production will continue works because have production plan and
> records data into local DB.
> When connection will be back all data will be synchronized.
> There are no so much real possibilities to conflict.
>
> Each table has UTC time stamp of last modification. In most cases,
> latest wins.
> Rest of conflict we have to program manually.
>
> I have idea how to do it (it is nice work), but I don't want to invent
> "wheel".
>
> I'm looking on something like copycat, but web site is little bit
> confusing.
>
> Any experience?
>
> Slavek
>
> Ing. Slavomir Skopalik
> Executive Head
> Elekt Labs s.r.o.
> Collection and evaluation of data from machines and laboratories
> by means of system MASA (http://www.elektlabs.cz/m2demo)
> --
> Address:
> Elekt Labs s.r.o.
> Chaloupky 158
> 783 72 Velky Tynec
> Czech Republic
> --
> Mobile: +420 724 207 851
> icq:199 118 333
> skype:skopaliks
> e-mail:skopa...@elektlabs.cz
> http://www.elektlabs.cz
>
> On 26.11.2015 9:00, Alan J Davies alan.dav...@aldis-systems.co.uk
> [firebird-support] wrote:
> > Hi Slavek, there are a number of issues you need to resolve before
> > making a decision. If network performance is an issue then replication
> > is not the answer - unless you can send the changes back to head office
> > 'out of hours'. This means the different databases will be out of sync
> > for some time. Is this acceptable from your customer's point of view?
> > Are there different production plants making the same item? What happens
> > if plant 1 and plant 2 make the same item on the same day?
> >
> > I think you may have to generate your own version because replication is
> > not what you need (imho) but you could create a series of triggers and
> > tables to do what you want. e.g. if you have a table called PARTS,
> > create SYNC_PARTS and each time there is a change to PARTS you add a
> > record. You could then send your updates to HO via a scheduled update or
> > even within the same transaction if your network access allows for that.
> >
> > Alan J Davies
> > Aldis
> >
> >
> > On 25/11/2015 21:35, Slavomir Skopalik skopa...@elektlabs.cz
> > [firebird-support] wrote:
> >> Hi all,
> >> we are preparing new project with bidirectional replication.
> >>
> >> Customer idea is to have master database in head quoter
> >> and slave databases on production plant (to solve network performance
> >> and availability issues).
> >>
> >> Witch replication SW you can recommend for this bidirectional
> replication?
> >> What is typical issues and weakness of this SW.
> >>
> >> Thank you.
> >>
> >> Slavek
> >>
> >> --
> >> Ing. Slavomir Skopalik
> >> Executive Head
> >> Elekt Labs s.r.o.
> >> Collection and evaluation of data from machines and laboratories
> >> by means of system MASA (http://www.elektlabs.cz/m2demo)
> >> --
> >> Address:
> >> Elekt Labs s.r.o.
> >> Chaloupky 158
> >> 783 72 Velky Tynec
> >> Czech Republic
> >> --
> >> Mobile: +420 724 207 851
> >> icq:199 118 333
> >> skype:skopaliks
> >> e-mail:skopa...@elektlabs.cz
> >> http://www.elektlabs.cz
> >>
> >>
>
> 
>

[firebird-support] gbak asking for volume number 2 disk

[Sudheer Palaparambil sudheer....@gmail.com [firebird-support]]

Hi,

 What causes gbak to ask for volume 2 number disk?

  I am using Firebird-2.5.4.26856_0_Win32 on Windows 7. The following
command line is used for taking the backup.

gbak -t -v -b -user SYSDBA -password masterkey accounts.fdb J:\accounts.fbk

'J:\' is flash drive here.

After copying the fbk from flash drive to my application folder on the hard
disk, I tried the following command line to restore the fbk file. After
restoring a few tables it is asking
for volume number 2, but it is a single file.

gbak -v -c -p 4096 -user SYSDBA -password masterkey accounts.fbk
accounts.fdb

.
gbak:   123 records restored
gbak:   124 records restored
Done with volume #1, "accounts.fbk"  Press return to reopen that file, or
type a new
name followed by return to open a different file.  Name:

  Regards.

Sudheer P

Re: [firebird-support] gbak asking for volume number 2 disk

[Sudheer Palaparambil sudheer....@gmail.com [firebird-support]]

Thanks Norman. Thanks for the reply, I think somebody might have closed the
command window accidentally.

Regards.

Sudheer

On Tue, Oct 20, 2015 at 5:14 PM, Norman Dunbar nor...@dunbar-it.co.uk
[firebird-support]  wrote:

>
>
> PS. http://www.firebirdfaq.org/faq59/ might also apply.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
> 
>

Re: [firebird-support] Re: Firebird Android

[Sudheer Palaparambil sudheer....@gmail.com [firebird-support]]

Hi,

My RESTful web service has Apache + PHP + Slim + JSON + Firebird
(PDO) combination. I am using it for the last 2 years. Or you can opt for
Tomcat + Jersey + JSON + Firebird (Jaybird) combination also.

Regards.

Sudheer

On Fri, Jan 16, 2015 at 7:46 PM, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] firebird-support@yahoogroups.com wrote:



 Assuming you know how to develop webservices


 http://www.codeproject.com/Articles/304302/Calling-Asp-Net-Webservice-ASMX-From-an-Android-Ap

 From: firebird-support@yahoogroups.com [mailto:
 firebird-support@yahoogroups.com]
 Sent: 16 January 2015 04:10 PM
 To: firebird-support@yahoogroups.com
 Subject: [firebird-support] Re: Firebird  Android

 I am facing the exact same issue with an app I want to develop. Is there a
 place you can point me to to learn more about the options and how to
 implement them? I recognize the issues presented, just not sure what the
 best approach is to solving them .

 [Non-text portions of this message have been removed]