WebAware has extensive experience working with relational databases. We have been working with SQL and non-SQL databases since 1986 and have experience with many different database products, large and small. Some of these include:
- Microsoft Access / JET
- Microsoft SQL Server
- ZIM 4GL
We design relational databases using entity-relationship models (ER), based on object models of the application if present. We use a modelling tool that can output ER diagrams for the database, as well as generate schema scripts to build the database.
WebAware can help you with data conversions, whether from one database to another or between non-database formats.
Extract, Transform, Load
WebAware has experience in creating Extract Transform Load (ETL) processes for moving data between systems, either once-off or on a regular cycle.