Databases play a critical role in most software project architecture. However it seems that the concepts of agile methodology, version management, and continuous delivery are somehow less mature in the world of DBAs and database developers.
In this article we’ll show you how to bring modern development techniques to the world of database objects and logic leveraging Oracle Developer Cloud Service.
Managing SQL Scripts Lifecycle
Database objects are defined through a set of SQL Scripts which act as the "source code" for your database. Just like any other source artifact of your project, you should be managing these scripts in a central code repository. By leveraging a modern version management system—such as Git—you’ll be able to create branches for specific database fixes and enhancements, and have better insight into your SQL scripts versions and changes over time.
To truly enable agile development methodology for your database artifacts you’ll also want to have an issue tracking system that is synched with your code repository—so you can track the progress of your project development along with code changes.
Oracle Developer Cloud Service—a free service that is provisioned for customers of Oracle Database Cloud Services and other Oracle PaaS services—includes project management platform with a combination of private Git repostiroes, a task tracking system, agile project management features, as well as wikis for team knowledge collaboration. This makes it very simple to track your SQL scripts lifecycle and manage them effectively. Read the complete article here.
For regular information become a member in the WebLogic Partner Community please visit: http://www.oracle.com/partners/goto/wls-emea ( OPN account required). If you need support with your account please contact the Oracle Partner Business Center.