Database Copy in Sage 300 ERP

By | September 26, 2014

Database Copy is a standard functionality available in Sage 300 ERP which can be used to copy the data of one company into another without taking the dump of one and loading the same into the second one.

New Stuff: BOM Component Usage Enquiry in Sage 300 ERP

Below are the steps to use Database Copy in Sage 300 ERP:

1. Navigate to Start >> All Program >> Sage >> Tools >> Database Copy and enter your admin password.

Untitled
2. Select the source database which you want to copy into your target database and click on Next.
Untitled
3. Going forward, select the target database into which you want to copy your selected database.
Untitled
4. Again, click on Next to finish this process which in turn starts copying your existing database into new one.
Untitled
After that, click on Yes for confirmation which will get you through the copying screen showing source and target databases at the top.
Untitled

Untitled

In the same way you can copy the existing System database into new system database as required after checking which System database is linked with your existing Company database. The linking can be checked by the Database Setup option available in Sage Application folder.

I am positive that this blog will help you in instances where you would be required to create the Test Database copy of your live database without wasting much time in dumping and reloading same database.

Also Read:

1. Invalid Database Specification error Sage 300 ERP (formerly Sage Accpac)
2Merge your multiple company databases into one Sage ERP
3. Backup your Company Database in Sage 300 ERP
4. Database Profiles table error on Sage 300 Workstation
5How to Resolve Help screen issue on Sage workstation