Skip to main content

Posts

Showing posts with the label Database

How to Create fresh Database with setup data

In agile software development process  Database schema is changed time to time. Most of the enterprise software applications have 'system defined data sets'  (Configurations, constants etc  )  in the Database.In case of a new release, new client,  testing etc. we need an empty Database structure with system defined data sets . This can be achieved by cleaning data-set, but sometimes this can be time consuming and error prone. An empty Database structure can be created by modern DBMS. Setup data can also be exported from Database tables. Large applications may have complex relationships with tables and data extraction may be painful.         I have used  Jailer  (Database Subsetting Tool) to extract system defined data sets. Jailer is a Database Subsetting and Browsing Tool. Exports consistent, referenti...