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
Rename Companies
rigolo
Member Posts: 5
Hi,
When we refresh our Test enviroment from production we would like to rename the companies from "CRONUS International" to "TEST CRONUS International" so that people can easily see what company/enviroment they are working in.
A rename on a C-SIDE database is very quick but we are working with an SQL database. A rename in SQL takes for ever .....
Are there any good hint's - tip's on how to quickly rename in a SQL enviroment.
The end goal is to be able to just take the SQL backup from our production database and restore that on our test database. After that run a "rename" script to change the company names and we are done.
Any ideas are welcome.
Regards,
Hein Rigolo
When we refresh our Test enviroment from production we would like to rename the companies from "CRONUS International" to "TEST CRONUS International" so that people can easily see what company/enviroment they are working in.
A rename on a C-SIDE database is very quick but we are working with an SQL database. A rename in SQL takes for ever .....
Are there any good hint's - tip's on how to quickly rename in a SQL enviroment.
The end goal is to be able to just take the SQL backup from our production database and restore that on our test database. After that run a "rename" script to change the company names and we are done.
Any ideas are welcome.
Regards,
Hein Rigolo
0
Comments
Then we have a red label saying "Test DB" on main manu which is visible only if "DBName"<>"Production DB name".
company names stay the same...
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Just start the rename before you go home and let it run overnight. You won't be doing this often anyway. There are other ways to show the user that they're in a test database. One way is Robert's suggestion, and you can also display the databasename on the main menu, or just change the color of the main menu in the test database.
RIS Plus, LLC
MVP - Business Apps
1. If you want to have test company on the same database as productions company, than you have to use navision backup&restore into local Navision DB (look 3.)
2. If you want to have seperate database and database is very big (> 2-10G - it depends on objects(keys) and HW), than is beter to use SQL backup & restore and than rename company on SQL, becouse it would thake to long do do Navision backup & restore
3. If database is not very big, than is better to use Navision backup& restore to create and rename test company. Make Navision backup of production company (only company data is nessesery, no object and shared data), restore it to local Navision DB (use cache), then rename it, backup it and than restore back into SQL.
Bostjan