Options

[solved] Restore security system

ta5ta5 Member Posts: 1,164
Hi

What is the best way to restore all information in a fbk file to a non empty test db? Normally I just want the new data, so I delete the company in the test db and restore the fbk. But the security system is not restored, because it is not empty in the test db...

Any suggestions to this?

Thanks
Thomas

Comments

  • Options
    Captain_DX4Captain_DX4 Member Posts: 230
    Security did not restore? It should have. How come you have security in your new database already?

    Barring this, I would suggest creating a dataport to export/import the security tables directly.
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • Options
    ta5ta5 Member Posts: 1,164
    I have native db. And there are already records in the security tables. I'm looking for a way the restore everything over my test db, without creating a new db.
    Thomas
  • Options
    kinekine Member Posts: 12,562
    Yes, you cannot force the backup to restore the data which are already existing in the DB. There is no other way than new DB or dataports.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    ta5ta5 Member Posts: 1,164
    thanks
Sign In or Register to comment.