Tags: create, cycle, database, experience, htmldb, interested, life, mysql, oracle, papers, production, segregated, software, sql
Software Development Life Cycle with HTMLDB
I'm interested if there are any White Papers or if anyone has experience trying to create segregated development, QA and Production environments with HTMLDB so that it is possible to migrate components of an application between environments instead of the all or nothing approach of an import/export?
DEV and QA could potentially exist on the same server but Production would be required to be in a totally separate operating environment.
I eagerly await feedback.
Leave a comment...
- 4 Comments
This whitepaper on best practices has a section on setting up separate dev, QA and production environments.
Sergio#1; Fri, 22 Feb 2008 22:40:00 GMT
It appears that promotion is an all or nothing event. It would be nice to be able to identify ( either via a "check in/out", timestamp or other mechanism ) and promote only incremental changes to new environments. I realize that HTMLDB is mostly meta-data, template etc but I believe it would make the process easier to manage.#2; Fri, 22 Feb 2008 22:41:00 GMT
- Well, you can just export your entire application, it generates a plain-text SQL file with a bunch of API calls.
Store this file in your source code control tool of choice
Use that tool's "diff" features to get your incremental changes between any 2 versions.
Thanks.#3; Fri, 22 Feb 2008 22:42:00 GMT
We use CVS for our source control. the Process we follow is that when ever a new module is created the code $Revision$ is put in the field version under the application attributes. So when the application is exported to sql the sql file is checked into CVS. Once checked into CVS the text"$Revision$" is automatically stamped with the version number generated by cvs. This process has worked for us very effectively for the last 3 years , for moving modules from Development , Test , Training and Production Instance. We also follow the same process for all our plsql packages also.
Hope this helps
Vivek#4; Fri, 22 Feb 2008 22:43:00 GMT