# DTM + DBFit

# DTM database generator https://sqledit.com/dg/
## features:

* It can create random and repeatable data.
* Supported databases include Microsoft SQL Server, Oracle, IBM DB2, Sybase, Informix, MySQL, PostgreSQL, etc.
* Supported formats for output files are CSV, SQL Script, XML, and JSON.
* For external data sources, it supports Excel, Access files, and XML documents.
* DTM Data Generator provides 15 methods, to fill in the data in the database or to generate data.

## Pros:

* Supports many commonly used databases.
* Fast data generation.
* You will get options to replace, append and update for each table.

## Cons:

It only supports the Windows operating system.

## Price: license

# DBFit Unit testing framework
http://dbfit.github.io/dbfit/

## Feature:
* Write, manage and execute tests directly from the browser.
* Out-of-the-box support for Oracle, SQL Server, MySQL, DB2, PostgreSQL, HSQLDB and Derby
* DbFit tests are written using tables, making them more readable than xUnit-style tests
* Run tests from the commandline, any Java IDE or CI build tool.
* Run tests from the commandline, any Java IDE or CI build tool

## Price: Free and open source