Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy nowHello All,
We are converting from QB Accountant Desktop 2021 Release R10P to QB Online. The number of Total Targets is below the threshold but we have 180 DB File Fragments. A colleague thought she read something about DB File Fragments maximum being 100 or less. I haven't found this in my research but I'm wondering if this will cause an issue with the conversion and if so, how to fix it before we have issues.
Thanks for any input.
Sandy
Hi there. sjacoby.
Before you convert the data from your QuickBooks Desktop to QuickBooks Online, I'll go over some details about Database (DB) file fragments and how to fix them.
Your computer's performance may suffer if there are too many DB file fragments. Less than 100 DB fragments typically have no impact on QuickBooks performance. Being under the target limit of 750,000 is a good thing because if your file exceeds the target limit, it cannot be converted to QuickBooks Online.
Let's manually defragment your server/host hard drive to enhance the efficiency of your computer system. When the disk hasn't been defragmented in a while, the process can take a very long time to finish. It might be best to run it overnight or even on the weekend.
Here's how:
Once finished, QuickBooks Desktop users can see their DB file fragment count by pressing F2 or Ctrl + 1.
For your reference, you can read this article for more insights: Database (DB) file fragments.
I've also included this resource to help you transfer your data from QuickBooks Desktop to QuickBooks Online: Move your QuickBooks Desktop file to QuickBooks Online.
Please let me know if you have further questions before moving your data from QuickBooks Desktop to Online. I'll get back with more details to help you.
In our experience we didn't encounter any issue how big the DB File Fragment was. But keep in mind, if your Total Target is between 350K-750K, you can only convert data to QBO Advanced.
https:// quickbooks.grsm.io/US
https:// quickbooks.grsm.io/us-promo
Otherwise, you should consider purchasing a 3rd party conversion service.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here