Your "real time" doesn't make any sense to me. Real time happens in SQL Server all the time. You INSERT data - it goes in in "real time". UPDATE/DELETE data - same thing. What are you looking for specifically?

Also, test databases are best if the actually mirror production data in pretty much every way: hardware, settings, data, etc. You need all of those to make sure your code will perform properly in production.