I am trying to move my app from one Machine to another. I have backed up the StrataFrame database on Machine1. When I do a restore on Machine2 I get message in SSMS:

The same thing happens for the StarataframeSample database. But if I backup my own database, it restores fine onto Server2. Anybody throw any light on whats happening here ?

It's just how SQL works. You are restoring from one machine to another overtop of an already existant database. SQL requires you to explicitely overwrite the existing database in that scenario.

For the new problem, you need to make sure that your database connection in StrataFrame (Visual Studio->StrataFrame menu->Database Connection) is pointing to the appropriate server, and you need to be sure to build your application on the new workstation.

I have checked that the database connection is pointing to the new server. All business objects are still red as if they are not configured.

In the Business Object Mapper, I can see all the business objetjects , but they are all Red , as if they are not configured. If I highlight one of them, Rt Click and go through the whole confiuration again (assigning it to the Table etc) it reconfigures it ok, But I lose all the BO properties.

What I want to be able to do is copy all the BO definitions and propertoes from MachineA running on Sql ServerA  to MachineB running on SqlServerB. Am I missing something ?

The issue is that the database (StrataFrame) you are pointing to doesn't have the mappings. Most likely, this means that you have more than one SQL Server and StrataFrame database. From within Visual Studio, click the StrataFrame -> Database Connection link and make sure that you are pointing to the correct SQL Server and StrataFrame database.

Done that but still no joy. When I go into BO Mapper, each of the Business Objects sows up, but still with a red X. If I rt click and go into properties, following shows up

Its as if it is not finding the link to the Business Objects details after I have copied to the new server and machine

Just did some more digging (on the new server and machine) and notice that the table DTEProject_Item_Exceptions seems to be populated with the fileds in the Tables that make up the Busines Object and the properties seem to be set as per they should be.....so the data has definitely come over to the new macjhine and server ,just does not seem to be recognized by BO Mapper

Hi. Just wondering of anybody got any ideas on this... I cant copy over to our server machine and am at a standstill....TIA

Hi Guys....this post seems to have dropped off the raidar. I'm still unable to see the Business Objects correctly having copied over the SF database to a new server and it is really hoding me up. I would  appreciate it if any assistance could be given.