LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
sjacoby
Level 1

QB Desktop to QB Online conversion

Hello 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 

2 Comments 2
Giovann_G
Moderator

QB Desktop to QB Online conversion

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:

 

  1. From your keyboard, press the Windows logo.
  2. Enter defrag.
  3. Select Defragment and Optimize Drives.
  4. Choose the disk drive you want to optimize.
  5. Hit the Optimize button.

 

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.

Fiat Lux - ASIA
Level 15

QB Desktop to QB Online conversion

@sjacoby 

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us