Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
create new company based on another one without data
catiamatos1991
Member Posts: 158
HI everyone,
I need to create a new company like a old one but without the records data which maybe exist in the tables.
So I create a new company SR and I've exported data using page 9901 for my old company MR.
When I try to import the data using the .navdata file I can't select the company SR, only appears MR.
In order to avoid this I've copy the MR company to SR but now I've thousands of information I don't want and I need a fast way to delete.. I've search a few things including a deleting tool in page 50090 called Record deletion and as a super user it says I don't have execute permissions in this table... I can´t find a way to solve my problem.
I need to create a new company like a old one but without the records data which maybe exist in the tables.
So I create a new company SR and I've exported data using page 9901 for my old company MR.
When I try to import the data using the .navdata file I can't select the company SR, only appears MR.
In order to avoid this I've copy the MR company to SR but now I've thousands of information I don't want and I need a fast way to delete.. I've search a few things including a deleting tool in page 50090 called Record deletion and as a super user it says I don't have execute permissions in this table... I can´t find a way to solve my problem.
0
Answers
<<http://www.olofsimren.com/record-deletion-tool-for-dynamics-nav-2015/>>
Thanks,
you apparently already got the record deletion tool wolfkin recommended to you, but your license does not allow to use it.
If you have access to a developer license, use it to use the tool. Otherwise you probably also don't have the possibility to move those objects to IDs you have licensed.
Either ask your NAV partner to help you, or use RapidStart services to export data from your old company and import it into your new company.
Without a solution provider license you will run into access problems trying to delete posted data. You would need to delete data directly from SQL.
You could also develop the reverse of Olof Simren's tool: copying only those tables to a new company in the same database that you need (Which basically is, what RapisStart allows you to do).