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?
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.