How to restore a single company from FBK chcanging its name?

easy-navieasy-navi Member Posts: 31
Hello, experts!

I have such a problem. I need to restore a single company from FBK file into the same database for testing purposes:

1.Now there is one DB and one company in it (let's say 'ABCompany').
2.I make a bakup - FBK file using tools
3. And now I NEED TO restore that FBK into the same DB with the name 'ABCompanyTEST':)
Is there any workaround or external tool to do it? I use the SQL version,

p.s. I can't just change the existing name 'ABCompany' to 'ABCompanyTEST' because:
-there are people working in it
-SQL version rename it very, very, very long ;(

Thanks for any help:)
http://www.reinwestuj.pl Inwestuj w nieruchomości. Condohotele, aparthotele.


  • Options
    krikikriki Member, Moderator Posts: 9,098
    -restore it in a Navision-DB (BUT ONLY DATA, NOT THE RECORDS).
    -rename the company
    -make a backup
    -restore in SQL.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    bbrownbbrown Member Posts: 3,268
    Use a separate database:

    1. Do a SQL backup
    2. Restore to a different SQL database
    3. Login and rename company in Test DB.

    SQL version rename it very, very, very long ;(

    I've only run into the above issue on sites that either have configuration issues or the rename is attempted with users in the systems. I use the above process monthly to update the test system for a 120 GB database. The company rename takes about 2 to 3 minutes. I'm expecting it to be faster now that we have upgraded to SP1 client.
    There are no bugs - only undocumented features.
Sign In or Register to comment.