All posts by cufiler

SQL scripts as part of repository

The sql scripts needed to create tables on database would be numbered and stored in repository. And each change in data model would generate modification sql scripts automatically. The scripts from one application version to another are just those numbered scripts from one number to another. As result, first version of DRIVER table should generate 0001.DRIVER.SQL (with create table…). If we add a new field into data model, next generation should give a new file 0002.DRIVER.SQL with: – create table temp_DRIVER as select… – drop table DRIVER – create table DRIVER… – insert into DRIVER as select… – drop table temp_DRIVER Or something so simple as – alter table DRIVER depending on nature of datamodel change. But I think Uniface should be intelligent enoguh to give us this sort of scripts.