Installation Question - Strataframe DB


Author
Message
franka
franka
StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)
Group: Forum Members
Posts: 22, Visits: 35
This question probably doesn't belong in this forum but I didn't know where else to but it...

I've already installed Strataframe on my local SQLServer (Express 2005).  What I really need to do is setup a shared DB for multiple developers.  We do not have any shared 2005 SQLServer databases only 2000.  What's the best way to set up a shared DB (2000) and import/copy my existing projects (2005) into it?

I'm assuming I can uninstall Stratrframe from my workstation and then reinstall it setting the Strataframe connection string to our 2000 SQLServer.  That will give me new Strataframe and Strataframe Sample DBs, I believe.  But how can I copy/import my current BO projects from my local Stratrframe DB (2005) to the new Strataframe DB?  Or can I?

In short, what's the best way to do this?

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
But how can I copy/import my current BO projects from my local Stratrframe DB (2005) to the new Strataframe DB?  Or can I?

Well, the problem here would be taking the MDF and moving it into a 2000 server ... the easiest thing would be to just shared a SQL Server Express server if you have that as an option.  You can install SQL Server Express on a server and then share amongst all of the developers.  If you do this, then you can take your local StrataFrame.MDF file and just mount it on the shared server.  Otherwise you are going to have to write a program or create queries to move the data over a piece at a time, which I do not recommend. 

franka
franka
StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)StrataFrame Beginner (22 reputation)
Group: Forum Members
Posts: 22, Visits: 35
Unfortunately, our DBA area only supports SQLServer 2000 at this time.  So it looks like my only option is to uninstall Strataframe, reinstall it and have the Strataframe DB install on our shared 2000 SQLServer and then have all the developers using Strataframe repoint the SF connection (Strataframe Data Store) to the new DB.  After that they'll need to recreate and rebuild all their BO projects.  We're really just getting started and have nothing in production yet so the BO project recreation won't be a big issue.  Do my steps sound right?
StrataFrame Team
S
StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)StrataFrame Developer (4.6K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Yes, your steps are correct Smile
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search