web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Restoring a company into development database from PROD database

(0) ShareShare
ReportReport
Posted on by

Hi, I am trying to copy stuff from PROD DB to DEV DB. My DEV DB is empty without any company. I took a backup for the whole PROD environment inside NAV Developer Environment , and went in DEV to restore it.

Over there I got a warning message " You cannot delete or change the type of the config. package code field ( in the Gen. Journal Batch table) before the value in the field is reduced to 0 or '(blank) in all records. This message occured because a nonzero value was found for the record journal template name ' GENERAL', NAME='THOMSON' in company QMLP-PRODUCTION."

I took a backup of a single company and tried to restore it in DEV  . Same message.

When I tried to restore the backup in the PILOT enviroment , It was successfully restored.

This thing told me that there is nothing wrong with the backup , might have to do with the DEV DB.

Please someone elaborate on this. I am new to this NAV stuff.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Roberto Stefanetti Profile Picture
    12,998 on at

    Hi

    Look at this post

    dynamicsuser.net/.../12563.aspx

  • Community Member Profile Picture
    on at

    Thanks for the prompt response Roberto.

    The post you mentioned tells me the objects inside the DEV DB doesnt match the PROD DB objects , thats why its happening.

    I deleted the companies from my DEV DB, but dont know how to get rid of the objects inside DB, Can you suggest me a method to completely wipe off the DB, so thats its like a brand new DB from scratch.

    Thanks

  • Verified answer
    Roberto Stefanetti Profile Picture
    12,998 on at

    hi,

    3 methods

    1) clean only db structure

    delete all company in your db, after rebuild applications objects, try to restore company again after rebuild

    2) create new db first way

    Once you create the db you can not delete system objects, I suggest you create a new dev db (actually, you could also delete it, the table metadata on sql server etc.).

    NAV 2013 Developer environment> Create Db> load the license in the db if you do not use a license server

    The new db created will contain only the tables from 2000000004 to 2000000203 created from scratch and managed on the new db

    Then do a backup applications with objects, commons given only the company that you need to bring in the new db> backup.fbk

    Go into the new db created> run the Restore backup file> then do build server application objects> should work

    3) create new db with restoring objects before, according to mo

    or if the first way does not work try the second way

    create new db (db created will contain only the new tables from 2,000,000,004 to 2,000,000,203) as above

    import all the objects from the production db with an import objects (except tables from 2000000004 to 2000000203)

    restore the company as above

    build server application objects

     > Should work (first difference is that we import the objects and then the data)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans