Find Jobs
Hire Freelancers

SQLite to MYSQL Regular Data Copy

$30-250 USD

Cancelled
Posted over 9 years ago

$30-250 USD

Paid on delivery
Very simple, I need to copy tables of SQLite data into MYSQL tables. If the UID already exists in the MYSQL tables, then they should update and not create a record. Assume field names are identical, except for the primary key field name, this needs to be specified in the ini file. There are x5 tables that require replicating and need to be updated every few seconds, all errors need to be logged. I would like to configure the script using an ini file like this example. [mysql] MYSQL Login Info: [sqlite] SQLite Login Info: [copyinfo] tbl_sqlite1 >> tbl_mysql >> primary_key_fieldname tbl_sqlite2 >> tbl_mysql_table2 >> primary_key_fieldname2 tbl_sqlite3 >> tbl_mysql_table3 >> primary_key_fieldname3 tbl_sqlite4 >> tbl_mysql_table4 >> primary_key_fieldname4 tbl_sqlite5 >> tbl_mysql_table5 >> primary_key_fieldname5
Project ID: 6491412

About the project

14 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

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

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
40
Payment method verified
Member since Mar 4, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.