Copy Apex and all apps from development DB to multiple production DBs

179992

Hi,

We have one development database with around 100 production databases.

I am new to Apex and we are evaluating how we could use it within our existing application but the first thing I need to know is the easiest way to copy the apex developed applications to all of our production databases.

Currently I export all objects from our development schema and compile them onto the production databases, can I do something similar with apex?

Would I just need to export the flows_030100 and flows_files schemas from our dev database and import it into the production databases? If so what about any grants? I can easily grant all the privilages for flows_030100 and flows_files users but is there anything else?

Any other angles to approach this from?

Thanks
Robert

John Edward Scott

Robert,

How many applications are you talking about roughly?

John.
--------------------------------------------
http://jes.blogs.shellprompt.net
http://www.apex-evangelists.com

179992

John,

Not a huge amount, in the region of 30-50 charts and reports I would think

thanks
Robert

John Edward Scott

Hi Robert,

30-50 charts and reports? Do you mean 50 apps, or just 1 app with 30-50 charts and reports?

Assuming you mean 30-50 distinct apps, I'd say exporting those schemas is very much overkill (I would be thinking about hundreds/thousands of apps before that probably became an attractive option).

You can export your applications individual through the Application Builder, if you use the Supporting Objects feature you can also include scripts to generate Packaged Code, table creation scripts, data generation etc.

However doing 30-50 individual exports would also be a bit tedious, so you can also use a commandline tool to batch export applications from a workspace or the entire instance, I blogged about how to do this a while back -

http://jes.blogs.shellprompt.net/2006/12/12/backing-up-your-applications/

You can then import those applications into your other DB's (the exports are just regular SQL scripts).

Hope this helps,

John.
--------------------------------------------
http://jes.blogs.shellprompt.net
http://www.apex-evangelists.com