Is it possible to synchronize a mysql server with a local Firebird bank?

2

I'm new to web applications, and I have a MySql DBMS based site.

What is the best way to synchronize the web bank with a local bank (where the bank is in a fixed ip)? The local bank is firebird.

    
asked by anonymous 07.11.2015 / 15:42

1 answer

2

First I want you to understand that FireBird and Mysql does not have a "very good" compatibility and probably would not be able to import data from one to another, that a developer creates has no way to have something ready that works exactly for your need.

I can not say which is the best way, but I'll tell you about something that is widely used for this purpose, I mean sharing data from a server with other environments.

You should create a webservice (preferably using authentication on the server).

What is a webservice:

Webservice is a solution used in systems integration and communication between different applications. With this technology it is possible that new applications can interact with those that already exist and that systems developed in different platforms are compatible. Webservices are components that allow applications to send and receive data. Each application can have its own "language", which is translated into a universal language, an intermediate format such as XML, Json, CSV, etc.

I recommend you read this question and answers:

Creating a webservice

Having understood what REST is, understand that it will run on your web server, I assume your server uses PHP or ASP.NET:

  • PHP

    If the case is PHP and you do not have sufficient knowledge to develop the application from scratch or even need to deliver this webservice quickly, I recommend using a framework, here is a list of frameworks that support creating REST application:

  • Laravel (Supports multiple libraries and authentication)
  • Slim (Supports Crypto and Session)

    An example with Slim: How to create a REST service with PHP and MySQL and .htaccess

  • ASP.NET

    With ASP.NET you can quickly develop a REST application, in ASP.NET its name is Web API (the programming language is your choice C # or VB.NET).

    Learn a little about web api here: link

Note that this data passed by the webservice is not in SQL format, but in Json or XML format, which are file formats that you customize yourself.

Client Side

On the client side you will have to create a Desktop software that will access the webservice that you created previously and download the data then populate the Firebird database. For this you will have to develop software only to access the webservice, download the data and popular the local bank.

To develop this software you have the option to use:

  • (eg VisualStudio can make it easier for you in this, it has version Community and it is very used, containing an excellent documentation )
  • (Java does not just create apps for Android but can also develop applications Desktop)
  • delphi or lazarus, in which case Delphi is a heavily used IDE in Windows that facilitates the Desktop development, alternatively you have Lazarus, which can also be used in Linux.

Conclusion

As I said at the beginning, there is nothing ready that works for each specific case, you will have to develop both environments, however do not be afraid, this type of development is more common than you think nowadays.

    
07.11.2015 / 18:35