Hi there,

I have a situation with the setup of our DNN Database that I need to have some good advice on. Currently due to versioning, administration, and moderation issues I have had to create two DNN websites. These are identical to each other, one is an Update (dev) site, where my users can update documents/text/etc. The other is the Live site where I have to manually "push" the updates to.

The current process I use is to copy all the content from the Update DNN directory, to the Live DNN directory manually. Then I have to backup both databases, and restore the old one to the new one.

I would like to come up with some way to automate this so I can run it on a scheduled task. We have a crude batch file but since it is flakey I've taken to doing the updates myself. The batch file runs and does the copy of the files from one directory to the other, but then we have to manually execute the SQL script to backup and then copy 1 database to the other.

I was thinking about using something like robocopy to synchronize the files, but I wasn't sure what the best way would be to have the database execute? We've also run into a situation where we have to stop the IIS App Pool to "release" the locked files in the directory when we do a file copy. Do you know of a way to further automate this process to take out the human intervention?

Thanks,
Owen - http://www.fdwsnetworks.com