There is some consideration at my company to move some or all of the Lotus Notes databases to a “.Net” environment: C# instead of LotusScript and Formula, SQL Server instead of Domino. I suspect this is an ongoing consideration at a number of companies.
One of the possible solutions to aid converting the Lotus Notes/Domino databases to “.Net” is a service provided by company that uses a tool called “Composer for Lotus Notes”. On the surface (since I have not actually used it) it looks impressive - converting most LotusScript and Formula directly into C#, which is pretty easy to follow.
However, I have received no answers as to how to provide two features of Lotus Notes upon which we rely: replication and Role based security.
Has anyone any experience with how well, if at all, SQL server based databases can handle hourly replication (as from North America to Europe and Asia)? How it handles replication or save conflicts?
Has anyone any experience with how to implement Role based security ( as opposed to User Name or User group security) in a “.Net” environment?