Schema Webcast Notes

Prerequisites

  • Apache Maven -- Please get version 3. It's time for 2.x to die . . .
  • Java -- 6 is the most mature - 7 not fully tested
  • Add maven and Java to the search path.
  • Create a JAVA_HOME variable pointing to the root of the Java installation.
  • SqlServer -- Any version after 2005 should suffice. 2008 R2 is the best-tested platform. This can be installed locally or on a separate machine as my CI server or in the case of the webcast I used a VM with sql installed
  • Configure SQL Server locally
  • Hudson or Jenkins
  • Git or Svn for version control. Either is great, but one is absolutely required.

Maven archetype command

mvn archetype:generate -DarchetypeGroupId=org.bitbucket.bradleysmithllc.etlunit -DarchetypeArtifactId=etlunit-database-schema-archetype -DarchetypeVersion=2.0.30 -Dgoals=package