Move from Enterprise Desktop to On-line - using 3rd party data table exports to local Sql server

A warm welcome to you, and thank you for choosing QuickBooks, @AdmTJ. We hope you find everything you need and that you enjoy your experience!

You can consider using a third-party app from QBO. Here are the steps if you wish to browse for a third-party app:

1. Access your QuickBooks Online company.
2. On the left navigational bar, go to the Apps tab.
3. In the search bar, type a relevant name as your keyword.
4. Once you find the app that best suits your business needs, click the app.
5. Click the Get app now button.

You can visit the Intuit App store should you want to import data using third-party applications.

Moreover, I'll also share this link where you can search articles that can serve as your reference to guide you in managing your QBO account: QuickBooks Online Help Articles.

For additional QuickBooks-related concerns, don't hesitate to post them here in the Community. We're always available and willing to lend a hand to your queries. Have a great day ahead.

@AdmTJ 

Explore this solution to set up a private cloud in your location and compare the quality to your existing environment.

https://app.myquickcloud.com/#/register?pc=fiatlux

If you decide to switch to QBO, explore this connector to mirror data.

https://www.make.com/en/register?pc=quickbooks

You can use Skyvia's pre-built connectors for QB Online and Desktop, which can automate data export to SQL Server on a schedule. It eliminates the need for a VPN-based connection and significantly reduces access latency issues.
https://skyvia.com/data-integration/replicate-quickbooksdesktop-to-sql-server