Is there a clean way to keep my dev database in sync with my production database? So if a user saves a record in production, this information gets populated to our dev database? It does not have to be real-time, but that would be nice. I am using SQL 2005.
How can I do this? Replication? If so how, I am not familiar with replication