company copy...

mxc
Member Posts: 42
Can I duplicate a company in a Database. This new company should have all the data of the old company.
Thank you,
Thank you,
Regards,
Manuel Xavier
Manuel Xavier
0
Comments
-
Hi
what u can do is take the back up of the current compnay whose data is to be duplicated.
After taking the backup rename the company to a new name.
And once this is over restore the backup taken before.
U would thus get a company with the data duplicated.
RegardsRegards,
Tushaar0 -
this will also double the size of your database..make sure you have enuf room0
-
Thanks for the tips...
They worked.Regards,
Manuel Xavier0 -
In case people are working in the company you want to copy :
1. Make a backup of the company (data only)
2. Restore it in a local database
3. rename it in the local database.
4. Make a backup in the local database
5. Restore it in the original database.
The rename will take most of the time !0 -
lol,
Or what you could do is download my little CompanyCopy tool. You can find it in the download section of mibuso.com. It's called CompanyCopy 1.5.
Very handy tool if you just want to copy a couple of tables."Real programmers don't comment their code.
If it was hard to write, it should be hard to understand."0 -
The problem with renaming companies is user rights set specificaly for the company. They will be changed to to renamed company, and when the company is restored to the DB the users have no access to it.
Jógvan Juel Rasmussen
formula.fo0
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