I would like to configure an Enterprise Replication between two databases (specific tables) in one single database server.

can this be accomplished by creating a alias name for the db server and using the actual dbservername and the dbserveralias to start replication.

i.e., DBSERVER=ids_em, DBSERVERALIAS=ids_em_alias, 1st db=test, 2nd db = test1, specific tables to be replicated from test to test1.

I don't want to use triggers as triggers are immediate and any error on "test1" would prevent the transaction not getting committed even in the db "test".

So I preferred to use ER in background.

can anybody help on this functionality.