evandertino/SchemaSpy-v6.md

## SchemaSpy-v6.md

      
    Raw
  

              SchemaSpy-v6.md
            
          
    Usage

Refs


http://schemaspy.org/
http://schemaspy.sourceforge.net/

Download JDBC

http://www.oracle.com/technetwork/database/features/jdbc/index.html
Build Docker image

$ docker build -t my/schemaspy .
Create schemaspy.properties

http://schemaspy.readthedocs.io/en/latest/started.html#configuration
Run Docker container (Generate Database info)

$ docker run --rm \
    -v /path-to/schemaspy.properties:/tmp/schemaspy/schemaspy.properties -v \
    -v /path-to/output:/tmp/schemaspy/output -v \
    -d my/schemaspy -hq # another options...

  
## SchemaSpy-v6_Dockerfile
FROM java:openjdk-8u111-jre-alpine

ENV LC_ALL C

RUN apk update
RUN apk add graphviz
RUN apk add fontconfig
RUN apk add unzip

WORKDIR /tmp/schemaspy

# TODO: Rename to real path
ADD ./ojdbcXX.jar .

ADD https://github.com/schemaspy/schemaspy/releases/download/v6.0.0-rc1/schemaspy-6.0.0-rc1.jar .
ADD https://www.fontsquirrel.com/fonts/download/open-sans ./open-sans.zip
RUN unzip open-sans.zip -d /usr/share/fonts
RUN fc-cache -fv

ENTRYPOINT ["java", "-jar", "schemaspy-6.0.0-rc1.jar"]
	FROM java:openjdk-8u111-jre-alpine

	ENV LC_ALL C

	RUN apk update
	RUN apk add graphviz
	RUN apk add fontconfig
	RUN apk add unzip

	WORKDIR /tmp/schemaspy

	# TODO: Rename to real path
	ADD ./ojdbcXX.jar .

	ADD https://github.com/schemaspy/schemaspy/releases/download/v6.0.0-rc1/schemaspy-6.0.0-rc1.jar .
	ADD https://www.fontsquirrel.com/fonts/download/open-sans ./open-sans.zip
	RUN unzip open-sans.zip -d /usr/share/fonts
	RUN fc-cache -fv

	ENTRYPOINT ["java", "-jar", "schemaspy-6.0.0-rc1.jar"]