Project Description
A Windows console application that runs on a scheduled task to automatically migrate data from QuickBooks Desktop to the Azure cloud SQL database. Pulls data directly from QuickBooks Desktop, formats the data for SQL and inserts directly into the Azure cloud database.
Major Features
- Automatically sync entity data from QuickBooks Desktop to the Azure cloud SQL database on a nightly basis.
- Seamlessly transforms and formats data for the SQL database.
- Logs data warnings and errors to allow the end user to view the status of their data migration and address any potential data integrity issues.