Yes, the reigstry stores all the information about the imail user. It's in
the domains key. What you need to do before your conversion is to convert
the flags to their real values. Just match up the values in the imail admin
with their prospective values in the registry. And, yes, you can bypass the
registry and use your own database. You can do it on a domain level even.
Use the registry for some; use your own for others.
John
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jonathan
Waldchen
Sent: Wednesday, July 12, 2000 12:50 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] Migration of IMail User Database to external
database
Not sure if this will answer your question but it's how we went about it.
Since I do not believe the NT Registry contains info about password, last
name, and flags(I could be wrong, but I haven't checked) an Export/Import
wouldn't do you much good since you would then have to go back through every
account and fill in the missing information. We had been keeping all of our
client information(login, password, email adds, addresses, etc) in an Access
database which we custom built. A simple query pulled all of the information
for each account we needed, and then Word organized the table into a comma
delimitered file, which then was imported into a new billing software,
Platypus. Platypus' backend is SQL so the fields went to their respective
places and when we switched over from the Imail database to the external SQL
database(using a custom odbcuser.dll from Boardtown) everything went
smoothly. Now all of our Imail addministration(minus aliases and lists) is
done through our billing software. Not sure how this applies to a SQL
database that is custom built, since I am not a SQL programmer in any
respect but maybe this will give you somehting to think about.
Jonathan
----- Original Message -----
From: Richard Murphy <[EMAIL PROTECTED]>
To: IMail_Forum <[EMAIL PROTECTED]>
Cc: paul 'bgfl addy' <[EMAIL PROTECTED]>
Sent: Wednesday, July 12, 2000 11:22 AM
Subject: [IMail Forum] Migration of IMail User Database to external database
> Afternoon all..
>
> IMAIL 5.09
> NT4.0 sp6a
> 450 domains, 3000 users..
>
> Just a quick query, which has probably been asked numerous times before,
but
> does anyone have any experience or indeed, know an easy way of exporting a
> the IMail user database out of the windows registry and into an external
> one, perhaps SQL based??
>
> This question is, of course, based on the assumption that IMail lets you
> bypass completely the WinNT registry when retaining user info, which is
> effectively what I would like to achieve..
>
> TIA
>
> Richard
>
> Richard Murphy
> Birmingham Grid for Learning Technical Support
> Birmingham City Council (UK)
> E-Mail; [EMAIL PROTECTED]
> http://www.bgfl.org
>
>
> *************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity
> to whom they are addressed. If you have received this email
> in error please notify [EMAIL PROTECTED]
>
> The views expressed within this email are those of the
> individual, and not necessarily those of the organisation
> *************************************************************
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
