Front Line Systems

Sage 300 Support, Sage 300, HighJump Warehouse Edge Consultants

  • Home
  • ERP
    • Sage 300 ERP
    • Sage 300 (Accpac) Cloud ERP
    • Sage 300 Demo
    • Sage 300 Support
    • How Much Does Sage 300 Cost?
    • ERP Resources
      • Change Your Sage 300 Partner
      • Increase Your ROI on Sage 300
      • Get Your Sage 300 Year-End Guide
      • Ultimate Sage 300 Guide For Sage 300 Users
  • WMS
    • HighJump Warehouse Edge
    • Warehouse Efficiency Resources
      • 10 Ways a Warehouse Management System Will Increase Efficiency
      • How Does Warehouse Automation Improve Inventory Management?
      • How to Improve Warehouse Performance?
      • How to Increase Picking Speed In Your Warehouse?
      • Tribal Knowledge and Your Warehouse Efficiency
    • HighJump Data Sheets
  • Add-Ons
    • AP Automation
    • Business Intelligence Software
      • Anvizent Analytics
      • Sage Enterprise Intelligence
      • Solver BI 360
    • Credit Card Processing
    • Manufacturing Software
      • AutoSimply Manufacturing Software
      • MiSys Manufacturing Software
    • Other Add-Ons
      • Sage CRM Software
        • Sage CRM Demo
        • CRM Software Consulting
        • CRM Software: Discover How To Use Outbound Call Lists in Sage CRM
      • Document Management Software
      • EDI Software for Sage 300 ERP (Accpac)
      • Hotel Management Accounting Software
        • Hotel Accounting Software
      • Sage HRMS
      • PrintBoss Software
        • Video: PrintBoss Software for Sage 300
      • Projects for Sage 300
      • Avalara Sales Tax
      • Service and Maintenance for Sage 300 ERP
      • Web Stores for Sage 300 ERP
  • Contact Us
    • Contact Us
    • Sage 300 ERP Consultants (formerly Sage Accpac) | HighJump WMS Consultants
    • Meet the Front Line Systems Team
    • HighJump Warehouse Edge Client Testimonials
    • What Our Sage 300 Customers Are Saying
  • Visit Our Blog

September 21, 2016 by Front Line Systems Leave a Comment

How to Perform a Data Dump in Sage 300?

What is a Sage 300 Data Dump?

Database Dump is a Sage 300 utility that exports data for a company or a system database to a folder that you specify. Only a user that has been assigned the rights to Database Dump under the Administrative Services module or the ADMIN can use the utility.

When is a Data Dump Used?

The most common reason to use the Database Dump utility is to back up data before making any changes on a large scale (such as year-end procedures, item and pricing changes) or before using any of the account code change tools.

Here are the steps to do a Data Dump in Sage 300:

  • Login as a user with admin privileges – Log into Sage 300 as an ADMIN user or any other user that has been set up with Database Dump rights under the Administrative Services module in User Authorizations.

sage-300-datadump

  • Setup a directory where the data will go – Each company or system database needs to have its own folder. Please note that the Database Dump utility will remove any previous data so only one set of files can be stored at a time to a single folder.

sage-300-datadump-directories

If you have multiple companies, we recommend you create sub-folders using the name of the company or the database. You can see the Database ID for a company by opening a simple screen such as your Company Profile under Common Services. There you will see the name of the database ID at the top.

  • Once you create a separate folder for each company’s database, go to Administrative Services, then double click the Database Dump icon.

database-dump-icon

  • Select Database and Dataset Directory – You will need to select the database that you are going to dump from the drop down menu. In this case it will be our sample company. Then use the Browse button to navigate to the folder you created for that company (or system database or enter the directory).

It is important to verify that you match the Dataset Directory with the Database if you have more than one company.  Enter a brief description that will allow someone to identify the database and the date of the data being dumped.

database-files

  •  Activate Database Dump and Verify Results – Click the Dump button after you verified the proper database and dataset directory. You will get a message that says, “Any existing dump files will be deleted?”

database-dump-conf

This will not remove the data from the SQL database. The Database Dump utility will remind you that if you have completed a data dump to that directory before, it will remove everything and put new data in there. Verify again that you selected the correct database and have the right dataset directory, then click okay and it will process the data dump.

Once the data dump has completed, you will receive a message that appears on your screen on how many tables have been processed, and the size of the data. Go ahead a click Close.

dd-message

If you have no other databases to dump you can close the database window. Navigate to the directory to which you performed the data dump. You will have two items inside that folder. One is a .DCT file. The file contains instructions on how to put the data back into the database.

dd-directory

The other folder within the directory contains all your .rec files. It contains all of the actual records or data that you dumped. Each record has a module signifier at the beginning – AP, AR, GL etc.

dd-files

For more information, please contact Front Line Systems at 866-435-0243.

Review and bookmark our Ultimate Sage 300 Guide for Sage 300 Users.

About Front Line Systems

Front Line Systems is an ERP Consulting Firm  (we specialize in Sage 300) with headquarters in Minneapolis, Minnesota. We are passionate about helping businesses solve their accounting, CRM, manufacturing and warehouse concerns. We believe that your business has an amazing capacity for innovation and growth, and that technology can help you realize that capacity.
Front Line Systems is a technology partner that solves problems and creates solutions for the life of your business.

We are Sage 300 business partners and provide Sage 300 software implementation, support and consulting services in Minnesota, Wisconsin, Virginia, DC, Maryland, Connecticut (New England). We serve clients across the US. Contact Front Line Systems at 866-435-0243 or visit us online at www.flsinc.net. We look forward to serving you.

Filed Under: sage 300, Sage 300 ERP, Sage Partner Connecticut, sage partner minnesota, sage partner virginia

Leave a Reply

Your email address will not be published. Required fields are marked *

Get Answers to Your Accounting, Manufacturing and Warehouse Problems. Contact Us Here.

Fill out my online form.

Sign Up For Our Sage 300 Tips & Tricks Newsletter

Register Below

* indicates required

Search For:

Read Our Latest Blog Posts

  • Sage 300 version 2022 product update 2 – What’s new?
  • What’s New in Sage 300 version 2022 – Product Update 1

Why Front Line Systems?

We believe that your business has an amazing capacity for innovation and growth and that technology can help get you there. Front Line Systems is a technology partner that believes in solving problems and creating solutions for the life of your business.   Learn More

Quick Links

Sage 300 Success Stories
Sage CRM Software
Hotel Software
Manufacturing Software
Meet the Front Line Systems Team
Warehouse Management Software (WMS)
Privacy Policy
Blog
Sitemap

Partnerships

Korber Partner

Sage Business Partner

Contact Us

Front Line Systems, Inc. is a Sage 300 and HighJump Warehouse Edge (a Körber product) partner. We are headquartered in Minneapolis, MN and have offices in Virginia and Washington DC. We serve clients across the United States. If you need Sage 300 support or would like a new warehouse management system don't hesitate to contact our team today.

Front Line Systems, Inc.
Phone: (866) 435-0243

Copyright © 2023 Front Line Systems, Inc.