I managed to get this working yesterday on one of our projects. I''ve written up detailed explanation here[1] I hope this is of some use to someone else; let me know either way (especially if I''ve screwed up). Chris [1] http://blog.seagul.co.uk/articles/2006/02/08/in-memory-sqlite-database-for-rails-testing