Skip to main content

How to Create fresh Database with setup data

By

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, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML

Amazingly tool that is immensely useful (after some time spent on getting to know it properly).


Labels:

Comments

Post a Comment

Popular posts from this blog

is not a JMX compliant Standard MBean

By
I got the fallowing exception and issue solved. If your are using MBean , MBean Interface and Implementation should be in same package, Otherwise use MXBean. javax.management.NotCompliantMBeanException: MBean class comlanka.rest.controller.DataManagerController does not implement DynamicMBean, and neither follows the Standard MBean conventions (javax.management.NotCompliantMBeanException: Class comlanka.rest.controller.DataManagerController is not a JMX compliant Standard MBean) nor the MXBean conventions (javax.management.NotCompliantMBeanException: comlanka.rest.controller.DataManagerController: Class comlanka.rest.controller.DataManagerController is not a JMX compliant MXBean)         at com.sun.jmx.mbeanserver.Introspector.checkCompliance(Introspector.java:176)         at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:317)         at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:522)        
Post a Comment
Read more

git Update failed

By
  Issue -  when you work with a large team, the git repository may have many branch creation and deletion operations, sometimes we may getting git update failed, when we try to update the whole repository. Solution - Tyr >  git fetch -p -p, --prune After fetching, remove any remote-tracking references that no longer exist on the remote. Tags are not subject to pruning if they are fetched only because of the default tag auto-following or due to a --tags option. However, if tags are fetched due to an explicit refspec (either on the command line or in the remote configuration, for example if the remote was cloned with the --mirror option), then they are also subject to pruning.
Post a Comment
Read more

Angular2 bind data only if form is submitted

By
How to bind data only if form is submitted in Angular2 This can be down with angular2 form handing with data-driven approach (User Angular  FormBuilder ). Template File <form [ngFormModel]='myForm' (ngSubmit)="onSubmit()"> <input type="text" [ngFormControl]="myForm.controls['userName']" /> <button type="submit">Submit</button> <button>Cancel</button> </form> <br>userName : {{originalUserName}} Angular Component Class export class AppComponent { myForm:ControlGroup; originalUserName:string; constructor(private _formBuilder:FormBuilder) { this.originalUserName = 'abc'; this.myForm = _formBuilder.group({ userName: [this.originalUserName] }); } onSubmit(form) { this.originalUserName = this.myForm.controls['userName'].value; } } GitHub Example Source
Post a Comment
Read more