Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Copy Apex and all apps from development DB to multiple production DBs

179992
Member Posts: 25
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
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
Answers
-
Robert,
How many applications are you talking about roughly?
John.
--------------------------------------------
http://jes.blogs.shellprompt.net
http://www.apex-evangelists.com -
John,
Not a huge amount, in the region of 30-50 charts and reports I would think
thanks
Robert -
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
This discussion has been closed.