StrataFrame Forum

How to move/copy StrataFrame's databases?

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

By James H Hansen - 1/5/2007

When I setup the trial version, I thought it was asking where to install the sample data, so I told it to install it on my test server.  After installation, I found that StrataFrame uses a SQL Server database to store its info.  Two issues:

For evaluation, how do I move the database to my main SQL server, which is up more often than my test server?  I know how to detach, copy, and attach databases, but is that going to mess with the installed framework?

Second, if I go with StrataFrame, I will be wanting to take my laptop on-site to my clients' locations.  Can I just copy the database to my laptop running the developer version of SQL server?  Or is this covered in the help file somewhere I haven't gotten to yet?

...Jim

By StrataFrame Team - 1/5/2007

You can either backup and restore the database from server to server using the SQL Server Management Studio, or you can detatch it and reattach it on the server where you want it to run.  You can then use the Database Connection option within the StrataFrame menu in Visual Studio to change the database connection that SF uses to reach the design-time StrataFrame database.
By James H Hansen - 1/5/2007

Thanks for the very prompt reply!  I saw it shortly after posting and am up and testing.

(BTW: While wading into the Mighty Fine Manual, I discovered the answer on "page" 12.  Thanks for not rubbing it in.)

...Jim

By Trent L. Taylor - 1/5/2007

Hehe hehe, no problem.  I am glad that you found what you were looking for.  Let us know if you have any other questions. Smile