Hi, everybody.
We would like to automate the prosess of moving Production db to Test and setup to the schedule. Any ideas solutions about this process will be really helpfull.
Thanks, Svetlana
Here is a screen shot of what I mean. I would send you the dtsx file but I have passwords writing in the script for the database encryption key and so on. I schedule this as a SQL job, it notifies me when it has ran and I drop and recreate the users manually. We use this here constantly for test, our conversion environment and testing in a failover environment.