I've been using transactional replication to mirror a table from one database to another and lately it's been a pain to keep running.
My goal is to simply keep an exact copy of a table in another database.
Table inserts are about 100 a day from the ASP page from which records submitted, up to a maximum of 400 per day on peak days.
The total records in the table wind up to be about 20,000 by the end of a period, when we flush the table.
The table has a few text fields, but isn't huge.
What's the easiest way to write inserted rows and updates to those rows to another database table on the same server with the same structure?
I think maybe replication is overkill, and it's a huge pain.