SETTING NEW STANDARDS FOR QUICKBOOKS® SYNCHRONIZATION.
Synchronize your QuickBooks data with Microsoft® SQL Server™.
Ridgefield Consulting Inc -
Intuit and QuickBooks are trademarks and service marks of Intuit Inc., registered in the United States and other countries.
QBSQL and QBBRIDGE are trademarks and service marks of Ridgefield Consulting, Inc.
Watch videos of QBSQL in action.
QBSQL .NET Controls are drag n drop .NET User Controls that allow your development team to rapidly produce in-
View our Quick Start Guide to see how to setup QuickBooks, SQL Server and Perform QuickBooks to SQL Synchronization.
QBSQL is a powerful application that utilizes the QODBC Driver for QuickBooks to extract your QuickBooks company file data and synchronize the QuickBooks data from your company file into one or more Microsoft SQL Server Databases.
Once your company data is stored within your Microsoft SQL Server Database, there are many things that you can do with the data -
For example, you can create Back Office applications for your staff or serve sales information to your website to support and provide feedback to your sales people in the field.
What you decide to do with this new capability will be driven by your business needs.
Now that QBSQL Version 2 also supports QuickBooks POS -
Let’s face it; QuickBooks export options have a lot to be desired. But with QBSQL you are no longer restricted to those limitations!
Discover what countless other businesses already have -
Easily synchronize an unlimited number of QuickBooks Company files with Microsoft SQL Server or Microsoft Azure Databases.
NEW! CIRCULAR SYNCHRONIZATION
QBSQL allows you to create a Circular synchronization schedule to automate daily synchronization runs against one or more company files.
When you create a Circular Synchronization Schedule, QBSQL automatically performs a sync on the tables in each company file. When it completes a Circular Sync, it starts Sync’ing again providing continuous updates to your SQL Server Databases.
QBSQL allows you to create a synchronization schedule to automate daily synchronization runs.
When you create a Synchronization Schedule for the Connection File for your QuickBooks Company File, QBSQL automatically performs a sync on the days and times you setup in the schedule.
SCHEDULED OPT FILE BACKUP
The QODBC Optimization file changes each time you synchronize your Company file data with SQL Server.
You can setup and change the Opt File Backup Schedule by going to the Settings Tab → Opt File Backup Schedule Tab.
Each Scheduled Backup can have a different Backup Location.
DEEP SCAN MODE
QBSQL has been tested against very large company files containing over 180,000 (InvoiceLine and SalesOrderLine) QuickBooks records.
If the QuickBooks company file has one or more years of data -
UNLIMITED COMPANY FILE SYNCHRONIZATION
Look no further -
FASTER THAN VERSION 2
QBSQL v3 is 5-
SUPPORT FOR MICROSOFT AZURE
QBSQL Synchronization can now be performed against your Microsoft Azure SQL database(s).
The QBSQL Synchronization Engine has been optimized to provide 100% accuracy on the data it extracts from your QuickBooks company files.
The QBSQL Synchronization Engine has been further optimized for speed, providing even greater performance.
DATABASE SCHEMA UPDATE IMPROVED
The QBSQL Engine detects changes to your QuickBooks company files and updates your SQL Database Schema with total accuracy to ensure you’re seeing all of the data you need to work with your QuickBooks company. Schema updates now occur in less than 2 minutes.
ENHANCED DATABASE OPTIMIZATION
The QBSQL Engine automatically creates the indexes on your SQL Databases to provide the best possible performance from your SQL Queries.
SCHEDULE MULTIPLE COMPANY FILES
If you’re an Accounting firm or a Company with multiple QuickBooks Company files, you can now schedule company file synchronization for each company file with the new Synchronization Scheduler. Version 3 no longer requires you to have QuickBooks open on your desktop!