Peruttu

Powershell script for SQlite DB

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

FROM Session

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)

UPDATE `xxx_portprd`.`ci_kiosks`

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.

WARNING:

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

Thank you!

Taidot: MySQL, SQLite

Näytä lisää: work as freelancer remote, things you can do as freelancer, scope of the freelancer com, local freelancer com, in which field i can freelancer, freelancer win 10, freelancer where to send file, freelancer see if you win, freelancer remote work, freelancer in path, freelancer for higher, freelancer com received payment, freelancer com local, freelancer com agreement, db freelancer, asc it, a port freelancer, agreement for freelancer, 5 minutes works freelancer, login script powershell, php db migration script, batch script powershell coverter, create system dsn script powershell, sqlite script delete database, script powershell contact creation

About the Employer:
( 31 reviews ) Malle, Belgium

Projektin tunnus: #8654691

2 freelanceria on tarjonnut keskimäärin 37 € tähän työhön

iwebsynthesis

We have worked in various technology in php since last 8+ year like wordpress, joomla, drupal, codeigniter etc. I have good command to resolve the challenging issues in time. The company [url removed, login to view] is establi Lisää

44 € EUR 2 päivässä
(7 arvostelua)
3.3
jkatzwinkel

Hello, I'm a professional .NET developer. I don't know powershell too good BUT I can create a .NET application which gets called every [url removed, login to view] from the powershell script I'd need a maximum of 2 to 3 hours to accomp Lisää

30 € EUR 1 päivässä
(0 arvostelua)
0.0