Node.js & SQL Modernization Move
Budget: $250 – $750 USD
I’m running a production script on Node.js 10.18.1 that pulls data from an on-prem SQL Server 2019 instance and pushes it to our cloud MySQL database every night. The time has come to refresh the stack: the code needs to compile and run under Node.js 22.19.0, and the SQL side has already been provisioned on SQL Server 2022.
There are no pain points in the current build, so the core objective is a clean, disruption-free migration. That said, if the switch gives us an opportunity to streamline or harden the data-synchronisation routine, I’m interested in your recommendations—especially around batching, retry logic or incremental change tracking.
Key points you’ll handle
• Update all dependencies, drivers and connection strings so the app runs on Node.js 22.
• Validate the nightly sync to the cloud MySQL target, then demonstrate identical row counts and checksums before and after the cut-over.
• Offer at least one concrete improvement to the sync workflow; I’m currently focused on reliability and speed.
Acceptance is simple: the job is complete when the scheduled task executes under Node 22, stores its results in SQL 2022, finishes without errors, and the MySQL cloud dataset matches source data on the first and subsequent runs.
Let me know your approach, timeline, and any tooling you’d like me to provision (SSMS, Azure Data Studio, Docker, etc.). I can grant you VPN access to the on-prem server or supply a sanitized backup if that speeds things up.
There are no pain points in the current build, so the core objective is a clean, disruption-free migration. That said, if the switch gives us an opportunity to streamline or harden the data-synchronisation routine, I’m interested in your recommendations—especially around batching, retry logic or incremental change tracking.
Key points you’ll handle
• Update all dependencies, drivers and connection strings so the app runs on Node.js 22.
• Validate the nightly sync to the cloud MySQL target, then demonstrate identical row counts and checksums before and after the cut-over.
• Offer at least one concrete improvement to the sync workflow; I’m currently focused on reliability and speed.
Acceptance is simple: the job is complete when the scheduled task executes under Node 22, stores its results in SQL 2022, finishes without errors, and the MySQL cloud dataset matches source data on the first and subsequent runs.
Let me know your approach, timeline, and any tooling you’d like me to provision (SSMS, Azure Data Studio, Docker, etc.). I can grant you VPN access to the on-prem server or supply a sanitized backup if that speeds things up.