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

easy-navi

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':)
:-k
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:)

kriki

-restore it in a Navision-DB (BUT ONLY DATA, NOT THE RECORDS).
-rename the company
-make a backup
-restore in SQL.

bbrown

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.