Transactional Replication to DB on Same Server instance
Is this a good candidate for transactional replication?


I would use SSIS to incrementally load data (if the data set is too big) or just freshly load the data (if the data is less) every night (or anytime).

This way you dont have to create any publication, distribution database or subscription.

Easy to manage when you do upgrades on your main database - especially changing schema.

Another option would be to use BCP OUT and BULK INSERT IN. I have a script to help if you go with this. Make sure to adjust the script to filter out the data you need using where clause :-)

Note: Don't get me wrong, as I am not telling, you can't use T-Rep, but I don't see it to fit perfectly in your situation. There are better tools that you can use to cater your scenario.