A
A
Artem2014-10-03 09:44:40
PHP
Artem, 2014-10-03 09:44:40

How to migrate FireBird database to MySQL?

There is a program for realtors "Real Estate Agency" (that's what it's called). It stores applications for the delivery / sale of commercial / non-commercial housing. In addition to standard entries, such as address, apartment and floor, there are a lot of fields in the application parameters, up to the following: corner apartment or not? brick or concrete walls? how many minutes to metro? etc.
The base in this program is presented in the FireBird format.
What we need to do:
1. Convert the database and transfer it in MySQL format to a remote hosting.
2. Make an authorization for realtors.
3. Make different levels of access to applications for realtors.
4. Make a "New Application" button to add new applications to the online database.
5. Make it possible to export the database in excel format.
6. Make it possible to print multiple applications. For example, we filter applications by Leninsky district, select a few that we like, press the "Print" button at the top of the interface, another tab opens in the browser, press ctrl + p, send it to print.
7. Printed applications should not contain telephone numbers, the realtor must rewrite them manually.
Questions.
1. How to convert FireBird database to MySQL?
2. How to upload all this to the hosting and what is the best hosting to choose?
3. Is it possible to tie a real estate agency website to this database in the future?
4. How much money will it cost if you give it to a freelancer / web studio?
5. How long will it take?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Elena, 2014-10-07
@Nidora

1. To convert the database, the SQLWays program or by hand can help you. You expel the data into a script on one end with the help of IBExpert, on the other - you load it.
2. Depending on what kind of hosting you need. I would recommend SSD drives .
3. Of course you can.
4. If you give it to a web studio, it will be more expensive than a freelancer. Just look on exchanges (for example, fl.ru) for freelancers who understand and understand this.
5. A couple of days - maximum.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question