kipusoep/UrlTracker — pull request #36 by sandromastronardi (2014-11-12 09:21:09+00:00)
Title: added compatability for SqlCompact

Added Sql Compact compatibility to support Umbraco as a Service in 2 scenarios:
1) enable to run UrlTracker while hosting with a Trial or Freelance plan
2) enable to run UrlTracker on local development environment after cloning the git repository (any plan), using the provided sql compact database

Changes

t-sql install scripts due to limitations in Sql Compact syntax (procedural extensions not supported)
t-sql queries adjusted due to limitations in Sql Compact syntax (wildcard search + booleans)

Credits: Ornella Geboers for the changes.
I am in the process of splitting the SqlCompact pull request and the DomainOnChild node pull request.
Development of the latter was continued with the changes of the first already included making the pull request a bit messy, hence this update.