PROJECT DESCRIPTION
Deploying a web application to a server, either on-premises or in the cloud, is relatively straightforward. It’s a matter of replacing the compiled web application files (usually DLL files for a .NET application or WAR files for a JAVA application). If the deployment has problems, reverting the deployment is also easy, just replace the new files by the previous ones. For databases, a new deployment means creating new tables or columns on existing tables, remove columns or tables that are no longer needed, apply migration scripts with destroying existing data. These operations usually involve creating deployment SQL scripts manually. They are hard to test because they modify the database permanently. Rolling back changes in case of failure is even harder.
GOALS
Improve custom built tools that manage and apply database SQL scripts, by dynamically generating SQL scripts to upgrade or downgrade a database. Change detection and script generation must be database agnostic, with a concrete implementation to at least one database engine: Microsoft SQLServer, PostgreSQL or Oracle.
TECNOLOGIeS / PRODUCTS
Visual Studio 2017, C#, XML, SQL scripts SQLServer, PostgreSQL or Oracle.
To acquire knowledge on the proposed technologies
To integrate an experienced team
Others benefits
Send an email to [email protected]
konkconsulting
Porto (PORTUGAL)