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 freelancer remote, field freelancer, freelancer send file, freelancer see win, freelancer remote work, freelancer higher, db freelancer, asc it, port freelancer, agreement freelancer, minutes works freelancer, login script powershell, batch script powershell coverter, sqlite script delete database, script powershell contact creation, script paid complete offers, sqlite script

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 iwebsymthesis.com 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 5.minutes 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