With SQL Server transactional replication, is it possible that it is possible to repeat users and sources from source to target database? It's not something I'm capable of doing.
No, you can not replicate users and roles with transaction related replication from source to database A list of objects that can be published using Transactional Reaction.
You will need to deploy users and roles from the source so that the database can be used before the snapshot script or using the post. For information about pre and post snapshot scripts, see:
No comments:
Post a Comment