Efficient data migrations are critical to a data-driven project. Identifying minor inconsistencies is a time consuming task... but it can be largely automated. Developers and even non-technical folks can use this self-serve web application to validate those requests.
It includes:
- XML serialisation through native JAXB
- Drag n Drop feature to upload files in Chrome and Firefox
- Standard file upload UI for Internet Explorer
- Responsive CSS
- Ajax calls
###What objects can be validated?
- tables
- views
- synonyms
- sequences
- stored procedures
###What sort of mistakes or inconsistencies are picked up by this app?
- missing objects (incorrect names, incorrect schema): if possible, the app will suggest the right schema
- incorrect object type: you thought it was a table... but nope... it was a synonym! If possible, the correct type will be suggested
- odd characters included in the request: as a result of copying & pasting
- underlying objects for views not included in the request: views can't be created without those dependencies... we give you a warning and display those objects you may want to include in the request!
All of that in... less than one second... for real.
Javadoc available at https://danielgalassi.github.io/validate-my-request/
###Quick & Simple:
Drag and drop the refresh request (an Excel template)
Wait 1 second... and review the results
