Rename Companies

rigolo
rigolo Member Posts: 5
edited 2004-07-02 in NAV/Navision Classic Client
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

Comments

  • RobertMo
    RobertMo Member Posts: 484
    usually when restoring DB we give a different name to DB.
    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...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • DenSter
    DenSter Member Posts: 8,307
    The reason why on SQL it takes so long is because it has to rename all the tables. Navision SQL option implements multiple companies by having a physical table per company, so when you rename your company, you are renaming all the tables inside that company.

    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.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • bostjanl
    bostjanl Member Posts: 107
    rigolo wrote:
    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
    There are several scenarios:
    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

Categories