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