If you need to test collation or some database implementation detail, that is the exception where it may be good to use a real database but certainly is not the rule.
I ended up a few times with discrepancy in the format (excel, .net and windows ) because someone changed it.