Certain DBMS types (including DB2, SQL Server, and PostgreSQL) provide Docker containers that you can use to deploy and test locally.
Steps to use this:
1) Install Docker
2) Run the setup script located at the root of each module
DBMS | Module | Script | Docker Image |
---|---|---|---|
DB2 | obevo-db-db2 | db2-setup.sh | DB2 Express |
MSSQL | obevo-db-mssql | mssql-setup.sh | MSSQL Server on Linux |
POSTGRESQL | obevo-db-postgresql | postgresql-setup.sh | PostgreSQL image |
The setup script will do the following:
Note: for Windows, try the Windows 10 Bash integration (though we haven’t tested it yet). If that doesn’t suffice, you can follow along the db2-setup.sh script and replicate the steps in Windows.
3) In your IDE, enable the “integration-build” profile so that you can activate integration tests against your local Docker instance
(Note - DB2 does not enable the integration-build by default in the build as a couple integration tests like Db2PostDeployActionIT are failing. Db2DeployerMainIT is fine, however. You can use that for testing.)