I have a Win 2012 R2 server which has a local SQLite db file. I want to sync some records to a remote Mysql db.
It should be synced trough a powershell script (that I can run every 5 minutes)
The powershell script should have a config section where I can configure the following things:
- Local SQLite file path
- Local SQLite table
- Remote MySQL server
- Remote MySQL port
- Remote MySQL username
- Remote MySQL password
- Remote MySQL DB
- Remote MySQL table
The script should select the records on the local sqlite DB Session table:
SELECT Name, GuestInfoUpdateTime
WHERE SessionType LIKE 2 AND name LIKE "TESTKIOSK%"
ORDER BY Name ASC;
For each record, the field 'GuestInfoUpdateTime' should be copied to `xxx_portprd`.`ci_kiosks` on the MySQL server, for the corresponding kioskname (name = kioskname)
SET `kiosklastseen` = '2015-10-05 09:25:30'
WHERE `ci_kiosks`.`kioskname` = 'TESTKIOSK004';
Please note that I'm unable to provide test databases. I'll need a complete script that I can adapt with the actual database locations. We release the milestone after we received the working script and it works on our server.
PLEASE, ONLY BID IF YOU UNDERSTAND THE PROJECT SCOPE FOR 100%. PLEASE BID YOUR ALL-IN PRICE.
If you place your bid, you agree that you can do the work as described here for that price. If you place a bid, and via chat you quote a higher price, your bid is false and will be reported to [url removed, login to view] (see art 23 of Freelancer User Agreement).
We release the milestone payment once we have the product working on our own server.
DO NOT BID IF:
- YOU ARE NOT 100% SURE YOU CAN HANDLE THIS
- YOU CAN NOT FINISH IN TIME.
- YOU DID NOT UNDERSTAND THE PROJECT FOR 100%
- YOUR BID IS HIGHER THAN THE STATED BUDGET.
- YOU ARE GOIING TO ASK A HIGHER PRICE VIA CHAT.
- YOU WANT THE MILESTONE (OR PREPAYMENT) TO BE RELEASED BEFORE END OF PROJECT.
- YOU NEED ANY MORE INFO (send me a chat or use public board to clarify anything).