Does anyone know if it's possible to mirror only data changes with SQL Server 2008's database mirror functionality. I suspect the answer is that it isn't possible, but wanted to see if I've missed something.
If not, does anyone know of any way to replicate only data and table schema changes from a source database to a reporting system. We don't want stored procs, views, functions, etc in the destination system. Replication doesn't need to be instantaneous, but what we're trying to avoid is having to do a full database copy followed by a DROP of all sprocs, views and functions (due to the size of the backup and the time this can take).
Replication (as in full-fledged SQL Server replication) isn't an option -- it has been investigated and would involve some changes to the database design, which would then take a number of weeks (if not more) to actually implement, test and support in the application above, as well as restricting and complicating how changes are applied to the database (i.e., although replication might technically be the right solution, for a whole host of process management and time constraints, it's probably not going to happen).