We help IT Professionals succeed at work.

Converting a backup (.bak) Database for use in  MS Dynamics GP

1,367 Views
Last Modified: 2013-12-11
I have recently installed MS Dynamics GP on a server; this server also has SQL 2005 installed. I have not worked with either program previously and was looking for some direction. I have the previous database in a .bak format and wish to convert it for use with the MS Dynamics GP program. The backup file is associated to an earlier version of the Great Plains program. Your help would be greatly appreciated. Thanks.
Comment
Watch Question

Cedric Obinna A.Full Stack Developer
CERTIFIED EXPERT
Top Expert 2008

Commented:
I haven't used MS Dynamics GP either but normally programs that backup also have restore commands. SO I'd suggest you look through ALL the menus (usually File Menu) for RESTORE command. Clicking that should allow you to browse and choose the backup file from where you saved it.

Hope that helps.

Author

Commented:
You would think that would be the case but with MS Dynamics I have to install the program for each instance relating to companies. I just can not figure out how to convert the older database first to integrate with the newer version of this software. Thanks.
Greg BessoIT Solutions Engineer

Commented:
While you have the COMPANY database in .bak form, do you also have the DYNAMICS database in .bak form from that same previous installation?

If you do, restore BOTH, then run GP Utilities from the start menu
In Utilities, you will upgrade first the "System" database (DYNAMICS), which is quick.
Then, you will upgrade the "Company" database(s), which will take some time.

Author

Commented:
The backup company database file I have is from an older version of Great Plains - I have it in a folder on the SQL server called e.g. "acme.bak". I need to restore the company in GP from this backup file but I cannot find the command in GP to do this. You mentioned that I have to restore the backup file prior to upgrading - how do I do that? Thanks.
IT Solutions Engineer
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Due to a problem with the server, I have to initiate a new clean install on a new machine. The backup (.bak) database is associated to the previous older version of GP. I assume that the backup file must be converted in the new SQL (2005)  install before I can access it via MS Dynamics GP 10. I have setup a new company (test)  in GP and now need to restore the backup file to over write it. So - I have to convert the .bak file to an .mdb file in SQL and then overwrite the test company with this converted file? Thanks.
Greg BessoIT Solutions Engineer

Commented:
In order to best help you, please answer the following questions...

1) Do you have a backup or mdf/ldf of the DYNAMICS database itself? This should have existed along with this company database you have.

2) Do you know specifically what version and service pack this came from?
Greg BessoIT Solutions Engineer

Commented:
But yes, if you created a new company, you can then restore this database over it, and then launch Dynamics GP Utilities.

Depending on which version the database came from though, the upgrade path can be very simple, or quite complicated (multiple steps/versions, not always directly to v10)

Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.