StrataFrame Forum

Error trying to Restore Strataframe database

http://forum.strataframe.net/Topic25175.aspx

By Ger Cannoll - 11/11/2009

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:

Restore failed for Server Server2
The backup Set holds a backup of a database other than the existing 'StrataFrame' database.

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 ?

By Michel Levy - 11/12/2009

Hi Gerard,

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

By Ger Cannoll - 11/12/2009

Hi Michel

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

By Dustin Taylor - 11/12/2009

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.
By Ger Cannoll - 11/12/2009

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 ?

By Dustin Taylor - 11/12/2009

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.

By Ger Cannoll - 11/12/2009

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 ?

By Trent L. Taylor - 11/12/2009

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.
By Ger Cannoll - 11/13/2009

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


On New Server                On Old Srver (Working ok)
Class   SmaBO                SmaBO
Profile  ...                      ...
DataBase ...                  KFS
Table ...                       SMA
Schema ...                    dbo

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

By Ger Cannoll - 11/13/2009

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
By Ger Cannoll - 11/16/2009

Hi. Just wondering of anybody got any ideas on this... I cant copy over to our server machine and am at a standstill....TIA
By Ger Cannoll - 11/20/2009

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.