The DBMS tool of Wellcode Software offers a comprehensive and extensive framework to automate the database changes in the life cycle of an application.<\/p>\n
In the software development cycle continuously changes are made to the database, like
\n\u2022 new fields, tables, views, procedures, triggers, etc. are added,
\n\u2022 field lengths, field types, views or procedures, etc. get changed or\u00a0or deleted<\/p>\n
These changes must be executed in the next release cycle by the customer, who gets the new release of the application.<\/p>\n
If this process is not automated, so manual update routines must be written for each database change. Here the problem begins. Constantly will either forget to write such routines or the routines are already outdated and forgotten. Some routines stop working in certain DB constellations, etc. Human errors are inevitable, the burden increases exponentially with every new version.<\/p>\n
More complications raise when complex functions and views are used and permanently get changed or extended.<\/p>\n
Addional,\u00a0the\u00a0database -as is- is completely decoupled from the source code, the question which state had the database at a\u00a0given time, can not be traced. Some fuses and adjustments are necessary. The overview is hard to maintain.<\/p>\n
Here the DBMS Tool of Wellcode Software intercepts itself in\u00a0this part of the life cycle and largely automate the nesessary database updates.
\n\u2022 New objects are added
\n\u2022 existing objects are updated
\n\u2022 no longer valid objects are deleted.<\/p>\n
Additional, custom actions can be assigned to the update routines of the DBMS Tool. For example, if the contents have to be extended in depending of adding a specific new column, a custom routine can hang itself in the update action and execute the nesessary work.<\/p>\n
With the helf of the DBMS tool of Wellcode\u00a0Software human errors are excluded when it comes to updating the databases.<\/p>\n
The DBMS tool has a scripting function, which \u00a0creates an executable sql script \u00a0rather than executing the update directly on\u00a0the database.<\/p>\n
The DBMS tool exports the database structure in an XML file that can be stored in the application as either a file or a resource.<\/p>\n
This rdbms structure definition can then be checked and managed in the source code repository. Thus a direct link is made with the database structure and the source code.<\/p>\n
By shiping a new version of the program the exported DBMS structure is an integral part of the application, with its help\u00a0the target databases can be updated, regardless of the state of the target databases.<\/p>\n","protected":false},"excerpt":{"rendered":"
The DBMS tool of Wellcode Software offers a comprehensive and extensive framework to automate the database changes in the life cycle of an application. In the software development cycle continuously changes are made to the database, like \u2022 new fields, tables, views, procedures, triggers, etc. are added, \u2022 field lengths, field types, views or procedures, … Continue reading WellDBMS (The Wellcode DBMS Tool)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":107,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-18","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/pages\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/comments?post=18"}],"version-history":[{"count":7,"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/pages\/18\/revisions"}],"predecessor-version":[{"id":109,"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/pages\/18\/revisions\/109"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/media\/107"}],"wp:attachment":[{"href":"https:\/\/wellcode.de\/home\/index.php\/wp-json\/wp\/v2\/media?parent=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}