Operating System: Windows 7, Windows 8.1, Windows Server 2008 or higher
Database: Microsoft SQL Server 2005 or Higher… SQL Server 2014 Recommended (Express to Enterprise Edition)
.Net Framework: 4.5
Applications: QuickBooks 2009 or higher, including 2015 & QODBC Driver
QBSQL accurately detects new, changed and deleted records within Quickbooks and synchronizes those changes - and ONLY those changes with your database instance.
This makes QBSQL not only accurate, but also fast since it only synchronizes those records that need to be inserted, updated or deleted.
Other methods, such as utilizing SSIS jobs that perform bulk deletions and bulk updates cause unnecessary stress on your system, not to mention tremendous disk IO (thrashing your hard drive) and causing a greater degree of database fragmentation in the process.
Plus, with QBSQL there is no need to perform exports or otherwise perform manual actions… QBSQL does everything for you.
In addition, QBSQL Professional Edition provides features that have firmly established QBSQL as the premier application to use for QuickBooks to SQL Server synchronization. (Refer to the QBSQL How To Section).
In fact, the QBSQL Professional Edition can send you detailed reports of the results of each Synchronization, allows you to limit the number of days back you want your sync to go as well as other features such as the ability to update multiple databases and more - that other synchronization applications or methods lack.
We recommend that you download our Trial Edition to see for yourself just how much QBSQL can empower your organization.
QBSQL handles successfully production environments involving 500,000 Invoice Line Items. Often, these tables can go back for many years and it becomes unnecessary to QBSQL to go back more than (for example) 160 days as any records prior to that will never be changed anymore.
QBSQL Professional allows you to specify a ‘rolling days back’ value to any tables that you want to limit your sync on. This increases the efficiency with which QBSQL updates your various databases and therefore allows you to optimize your synchronization processes.
Of course you may not have a half million records in your Invoice Line or Sales Order Line tables, but that doesn’t mean you shouldn’t be able to optimize your sync process to the finely tuned pitch that you desire. QBSQL Professional let’s you do that.
Depending on whether you have selected Manufacturing & Wholesale or some other QuickBooks data template, there will be certain tables or QuickBooks features that are not used or enabled.
When you perform your first sync using either QBSQL Standard or QBSQL Professional you’ll be notified of those tables that contain zero records and are likely not being used in your environment and the QuickBooks features that have not been enabled.
The Table Selection feature allows you to remove (un-check) the tables having zero records, further optimizing your synchronization process by removing unnecessary QODBC queries.
Should you later begin to utilize QuickBooks in such a manner that these previously un-used tables begin to contain records (or turn on QuickBooks features that utilize these previously un-used tables) you can of course re-select all tables and let QBSQL tell you which tables you need to select for your synchronization process.
QBSQL Professional also allows you to update multiple databases and you may want one database be populated with a few tables (for example when a database is being used for a website) while you may want another database (for example a database used for back office processes) to be fully populated.
QBSQL Professional allows you to create multiple connection files to update as many databases as you want providing you with the most versatile system available to date for synchronizing your QuickBooks data to your database(s).
Both the QBSQL Standard and Professional Edition allow you to update any Microsoft SQL Server database provided you have the proper credentials to login and proper permissions to create/update the databse whether it's a Cloud based database or a local database.
In fact, the data displayed on the Web Applications webpage is a Microsoft Azure SQL Server instance that has been populated with QBSQL.
The QBSQL Professional Edition automatically generates a report of the tables that had some of their records changed for each sync.
These reports are saved or preserved in a number of ways;
The report is saved to the “Reports” sub-directory that QBSQL was installed to. However, these reports can go missing for various reasons, such as; Someone deleted them; The machine QBSQL was installed on had to be rebuilt, or moved to another machine for whatever reason. It happens in production environments everywhere and that’s why QBSQL Professional also performs another backup measure…
QBSQL automatically saves all reports to its own Settings database allowing you to restore previously generated (but somehow lost) reports to your hard drive.
Reports can be emailed to you as well. In fact QBSQL Professional allows you to provide notifications via SMTP Email to as many recipients as required.
QBSQL will automatically discover newly added custom fields when it performs a sync. If your current SQL Server database instance does not have that field in the table(s) affected, you will receive a warning and will be prompted to use the "Detect Schema Changes" option in the QBSQL Wizard.
When you perform the "Detect Schema Changes" action, QBSQL will detect any fields missing from your SQL Server database instance and add them dynamically; there is no need for your to manually modify your database.
Once your database schema has been updated, you may continue to synchronize your QuickBooks data with your SQL Server database.
QBDQL Professional Edition allows you to update multiple databases with ease.
Simply create a connection to each database you want to update with QBSQL and select which tables each connection will update. For security purposes, each connection file is encrypted with very strong encryption so the login and password to your database(s) remain secure.
You may want to have one database for your Back Office staff that would be populated with all of your QuickBooks data.
Another database might be created to serve data to the Web and you may want to restrict some of the tables that are available on that database.
Yet another database might be necessary for your production staff and may contain another separate set of tables that are to be updated.
No matter how you slice it, QBSQL allows you the flexibility you need!
Provide phone number for faster reply. Check your ‘junk’ folder for email just in case… it happens sometimes