endorsedCompleted

Data Migration and Client Modifications for Ship Emergency-Recording Application

Services Covered:

Custom Software Development

Industry

Information Technology

Duration

1 month

Budget

Less than 10K

Start Date

1 June 2020

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

76/100

Good

Project Capability Score (PCS) estimates how capable DreamzTech Solutions is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Palladium Technologies

Fort Lauderdale, United States of America

Project Summary

DreamzTech modified a client for a client/server application used to record emergencies on ships, handling data export and migration, UI modifications and reporting. The engagement included database synchronization and offline failover, delivered on schedule, and the client reported satisfaction and plans for future work.

Key Challenges

Modify the client of a ship emergency-recording client/server application
Migrate and synchronize data between Microsoft SQL and MySQL with offline failover to SQLite

Project Deliverables

Data export from Microsoft SQL Server
Periodic data import into MySQL
Modified user interfaces using Scaled Vector Graphics
Reports
Python startup scripts
Local SQLite failover with automatic MySQL updates

Project Solution

DreamzTech exported data from a Microsoft SQL database and implemented periodic imports to a MySQL server, modified client user interfaces using Scaled Vector Graphics, produced reporting, and added Python startup scripts. They implemented a local SQLite failover to handle network outages with automatic synchronization back to MySQL when connectivity was restored. Two team members (a developer and a project manager) supported the engagement.

Project Outcome

Project delivered on schedule and met expectations
Client intends to engage the vendor for additional projects
Vendor provided a 90-day warranty on the delivered product
Efficient communication and timely responses from the vendor

Platforms

Embedded System

Tech Stack

Python
MySQL
SQLite
SQL

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The finished product met the expectations of the internal team and was delivered according to the schedule. Dreamztech Solutions produces quality results through constant communication and updates. The team is reliable, driven, and knowledgeable.”
Daniel Summars
Director of Software Projects
Date: 10/10/2020