I need to know how to migrate SF data from one database to another on a project level. I know I can backup the database and restore on another machine, but I want to be able to selectively copy projects from one machine to another for two reasons.



First, another developer and I both started using SF and just setup local DBs, and as I've learned this causes some problems when trying update each other's projects, and with two more developers soon joining the picture the idea of four different DB's that projects are tied to, and trying to manage permissions and apply SF updates unilaterally seems like too much work. So I want to merge all our SF projects into one SF DB.



Secondly, I would like to be able to copy the source code and the project DB files to a jump drive and work on code from home without having to VPN into work to get to the SF DB, and then when I'm done import the changes back into the work SF DB.



Maybe this has been explained somewhere else and I've just missed it. I've looked through the tables and it seems to complex for me to just blindly stab at trying to write an import/export program.



Any help is greatly appreciated.



PS. This post really applies to all the SF products, application framework, DDT, and role based security. Should this maybe placed in requested features forum instead??



Thanks,

Jason Seidell

Jason Seidell

Programmer/Analyst

Infinedi

However I do wish there was a way I could move all the source code and datafiles I need for a project into a single location so I could work on the project from another disconnected computer. And for backup purposes to capture everything for a project at a given point in time (ie. before a version update) without having to also snapshot the DB.

Jason Seidell

Programmer/Analyst

Infinedi

Hey Jason.

Not sure if you are already going to the class in July or not, but this is one of the subjects they go extensively about during the course.

Meanwhile, I guess your two best choices would be TeamSystem (and there is an MSDN subscription that comes with it, the Visual Studio Team System 2008 ones) and probably Vault (a cheaper choice, from SourceGear, www.sourcegear.com)