[Dovecot] SQL Server

[Dave McGuire]

On 5/22/10 9:59 PM, Michael Orlitzky wrote:
>>> If you can access the Microsoft SQL Server from the machine hosting
>>> Dovecot, there should be no problem at all. I have used Microsoft's SQL
>>> sever for for several projects and it is an extremely fast and robust
>>> piece of software.
>>>
>>> Perhaps you could post a clearer picture of exactly what you are
>>> attempting to accomplish.
>>
>> Sorry. I should have been more specific. I want to use SQL Server for
>> the userdb and password database. I looked through the wiki and did a
>> number of searches but could not find an answer. If I were to use
>> sqlite, mysql, or pgsql, these would be listed under driver = in the
>> dovecot-sql.conf (or whatever you want to name it). How would you go
>> about using SQL Server? There is no sql-server driver as far as I
>> know. I have and am currently using dovecot from passwd files and from
>> sqlite databases so I am pretty familiar with how everything works. I
>> am just not sure how to go about this for SQL Server. Thank you.
> 
> You can specify arbitrary .NET DLL functions to be executed from
> triggers in Microsoft SQL Server, and there are .NET libraries to talk
> to Postgres, so just do it the other way around: run Dovecot off of a
> local Postgres install, and feed it data from Microsoft SQL every time
> something changes.
...
  [excellent example snipped]

  Wow, very nice.  This'll give you the benefit of not having your mail
system go down every time Windows blows up.

              -Dave

-- 
Dave McGuire
Port Charlotte, FL