I am attempting to set up a proper development environment and I need to know if something is possible. I want to set up a development sql database that is regularly sync'd with the live so that any testing we do against the dev database does not affect the live. It also allows us to test using actual data from the live site.
Is this possible without using a third-party application like Scribe online? Is there a built-in feature of Windows to handle this?
We are running windows server 2012 and sql server 2012.