Sync tables from Firebird SQL database with MySQL tables of website

$30-250 USD

Closed

Posted

almost 5 years ago

$30-250 USD

Paid on delivery

I have an existing Firebird 3.0 SQL database project written in Delphi. I need a tool (.exe and Delphi source code) which can do a two-way synchronization of data in certain tables on my website and on my local database. Functions needed: 1) Upload selected records from the local Firebird SQL database into a table of the MySQL database of my website. There are some related tables which need to be synchronized as well. 2) Download all records from the MySQL database on my website into the tables of my local database. (again there are some related tables which need to be synchronized as well.). Changes made online have precedence, i.e. overwrite data in the MySQL table (but only for the records which we are synchronizing). 3) One-way sync of a few helper tables on the MySQL database with data from some helper tables of the FIrebird database (overwriting all data online and deleting dropped fields) GUI: Simple GUIL Button "Sync helper table" to perform the upload mentioned in 3) above. Button "Download Data" to perform the download mentioned in 2) above. Button "Upload Data" to perform the upload mentioned in 1) above Combobox "Custom Tag", which displays [url removed, login to view] values (CUSTOM_TAGS is a table on my local database). Upload of all records which carry the selected tag through table PARTNERS_CUSTOM_TAGS (This table allows the user to link one PARTNERS record with several CUSTOM_TAGS records). Please use FireDAC (mandatory). I want to buy work directly from someone who has already done it

Delphi

Project ID: 19755016

About the project

10 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

10 freelancers are bidding on average $206 USD for this job

@gyk

I have more than 20 years experience with Delphi, C#, C++ and various rdmbs like Oracle, MsSql, MySql, PostgresSql, Sybase, Firebird, sqlite. I am preparing data synchronisation solutions on daily basis. I am happy to help you with your project. Please ask if you have any questions.

$222 USD in 4 days

5.0

(27 reviews)

6.1

@DeadC0der

Hello there , I'm delphi software developer , I used to deal with delphi since version 7 till the latest 10.3.1 RIO , I used to deal with dbEngines like FireDac,UNIDAc,ADO and so forth working with DBMS like FireDac,Mysql,Sqlserver ..etc check out my portfolio best regards

$250 USD in 3 days

4.9

(48 reviews)

5.6

@hshami1184

dear Im adelphi developer I read your job description, I understand your requirements, I need to share me more details about your project waiting your reply

$222 USD in 4 days

4.5

(8 reviews)

5.1

@tytus0d

I have more than 15 years experience of Delphi Developer. I started with Delphi 5 and working with XE10.2 Tokyo now. I have experience in Windows API, Network API, COM-Port, DataSnap, Client/Server, parsing big files, develop Multi-threaded application without any memory/resource leaks. Oracle Database (from 8i to 12c), SQL, T-SQL, MySQL, MSSQL. Also I have some experience in C++ and C# programming languages.

$200 USD in 7 days

4.9

(22 reviews)

4.1

@AntonBliznetc

Hello! You need sync firebird to mysql. I specialized of firebird (interbase) I have 20 year exp of sql. I can use Delphi or C# for that. For example my last work of this site: Transfer stored procedure form firebird to mssql. https://www.freelancer.com/projects/sql/Firebird-SQL-Server-Stored-Procedure/proposals What count of tables need sync? thanks

$230 USD in 7 days

4.9

(15 reviews)

3.6

@BlackEagle86

Hi, High talented Delphi, MatLab, Unity, VBA, Access, Microsoft Office, Java, Python and R, C#, C++, QT expert is here! I have graduated from National University of Singapore and received Master Degree there. As I am a professional Delphi, Python and C# developer, I can do your job perfectly Fast and Perfectly on time. I have 10+ years of experience for Delphi, Python, R, C#, C++ application Development. I have developed several dozens of applications such as OCR, AI, e-commerce, banking, UNESCO census. I understood what you want and want to like to discuss in more detail for your project. I sincerely hope to work with you. If you hire me and give me a chance to prove my abilities, I will give you the best results with my professional skills and will do my best to finish the project successfully. I am sure I can help you. Please see my profile. I am looking forward to your soon reply. Best regards.

$140 USD in 7 days

5.0

(1 review)

1.8

@alexpedroto

I have extensive experience with delphi, since version 7, and currently use delphi xe5 and delphi Rio. I can do a rest web service that will stay on your web server, either in Windows or Linux, using delphi firedac in the Windows version and Lazarus zeus in the Linux version. I use this strategy in my mobile applications. In this way the synchronization service would be quite fast and independent of operating system. It would also be database independent. In the case of using Linux I will use Lazarus to build the rest server. If this is a problem we can connect directly to the bank on the web, using Delphi and Firedac. In both cases we will have a local application made in Delphi. Zeus is a Delphi and Lazarus component with multi-database approach.

$222 USD in 10 days

0.0

(0 reviews)

0.0

@louisbarber2018

I graduated from the department of Mathematics and specialized in Computer applications. I am always searching for new solutions. Furthermore one of my key strengths is Oracle. I can do every type of job at resonable prices. I am eagerly waiting for offers. I have 25+ years experience in business-financial and other applications and complex information systems development In last 14+ years I developed many projects in Delphi with Mysql, Postgresql, Firebird for butchers, bakers and other production firms, for services, accountants, traders, agricultural… In which version of Delphi is Your project? Whose database connections are You using? Regards: Lajos

$150 USD in 7 days