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 ?

Hi Gerard,

Did you miss the "options" in Restore screen in SSMS? You will see Restore WITH REPLACE

Hi Michel

I can see Tools..Options in SSMS (2008) but cant see anything like  Replace. Whereabouts is it ?

On the restore database window itself. In the left hand pane there is a "General" and "Options" page.  Click "Options", and you'll see the "Overwrite the existing database (WITH REPLACE)" checkbox available.

Hi Dustin. Thanks for that . I have been able to restore it now.

As a matter of interest, why does the StaratFrame database come up with this message but when I restored my own database, it did it without any message ?

I now have another issue. I am trying to move my Application from one Machine to another. I have Staratframe installed on both and can activate and deactive licenses fine.

So, I have Backuped the Strataframe Database, My own Database and the App files, and restored them to another machine, with a different Server, preserving the File Locations (i.e. The Application files  are on a folder named c:\KEK on both machines...dont know if this is necessary or not)

When I now go into the Business Object Mapper on the new machine, all the Busines Objects are in Red . Do I have to tell Strataframe that they are on a different Server ?

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