company copy...

mxc
mxc Member Posts: 42
edited 2003-08-18 in Navision Attain
Can I duplicate a company in a Database. This new company should have all the data of the old company.

Thank you,
Regards,

Manuel Xavier

Comments

  • Waldo
    Waldo Member Posts: 3,412
    You could do the following:

    - make a backup of the company
    - rename the current company
    - restore the backup.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • tushaar99
    tushaar99 Member Posts: 35
    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.

    Regards
    Regards,
    Tushaar
  • Savatage
    Savatage Member Posts: 7,142
    this will also double the size of your database..make sure you have enuf room
  • mxc
    mxc Member Posts: 42
    Thanks for the tips...
    They worked.
    Regards,

    Manuel Xavier
  • Francis_Malengier
    Francis_Malengier Member Posts: 28
    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 !
  • eromein
    eromein Member Posts: 589
    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."
  • juel68
    juel68 Member Posts: 1
    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.fo