[solved] Restore security system

ta5
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
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
0
Comments
-
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 Developer0 -
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.
Thomas0 -
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.0
-
thanks0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions