files

SOLVED

I have 2045360 total Kbytes of files. I am told this is way too much.

I am looking for a way to upgrade to Sage 100. Is there a way to avoid losing all my data if i migrate?

  • 0
    verified answer

    Anthony,

    Sage 100 is completely different than Sage 50 in case you were not aware. The conversion for Sage 50 to Sage 100 is not easy but can be done and should be discussed with your Sage 100 Certified Partner.

    I would like to suggest purging your Sage 50 data and only keeping as little as possible in the current company. The way it works is you make a backup of your current company then restore that same backup into a NEW company, so essentially you have 2 companies with the exact same data. When you restore the backup to the new company, let Sage open the new company, go to maintain company info and change the beginning of your company name to HISTORY, then save the screen and close that company. Now when you open Sage you can see your original company (which you are going to purge data) and the HISTORY company that you will use to look up, (you guessed it) History.  If you can purge a significant amount of data so your data size is 1 gig or hopefully less, then you know you can enter new transactions for a period of time until you reach the 2 gig mark you are at right now.  This way you can continue to use Sage without going to Sage 100.

    Purging large amount of data can be very time consuming and your Users will not be able to enter data while Sage is purging the records. For this reason, you should restore a backup as a "Test" company same as the process you would do for the History company and run the purge in the Test company.  Running the purge in the test company has no effect on the current company in that Users are still able to enter data in the live company and if the server slows down overall processes, you can terminate the purge in the Test Company with zero impact. You can purge as much data as you want but with 2 gigs it could be a long time depending on the server speed, etc, etc. So, some companies purge a few years at a time. This way you have more control of the time issue, and you can see how long it takes and the number of records you still have after that particular purge.

    IMO, overall, it's best to purge as much data as possible because you want all the old data in (1) History company for easy access.

    Happy to provide assistance. If you need some help, please pm me.

  • 0 in reply to KimClement

    Thank you very much. I was thinking of doing something similar and good to know it is possible!

  • 0 in reply to Anthony Cuomo
    SUGGESTED

    You are welcome.

    Not that you will need it, but good luck to ya.