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.
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.
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).
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:
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:
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.
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:
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.