So, what's the best type of replication for this kind of setup?
My situation is - I need to, essentially, copy the database from a production server to a reporting server once every night. But, I don't want to overwrite any unique reporting-related views that have been created on the reporting server during this update/refresh of data. (Which is why I'm looking at replication as opposed to something more crude.)
So, basically, I don't need to keep the reporting DB updated throughout the day. A nightly refresh is fine.
I attempted to set up snapshot replication, but ran into all kinds of problems because when the replication process attempted to drop/recreate existing articles on the reporting server, it would error out because of dependencies in other articles. While I know you can alter the way the process handles existing articles, I wanted it to simply drop/recreate them.
How do the experts typically configure this type of replication?