Jason,
For
ease of use/development, I would recommend programming completely around one or
the other but not both. Using both allows room for too many
problems.
When
developing, keep in mind that a database is best at sorting and searching thru
data. If the mail text needs to be searchable, then entering them into the
database is a good idea. However, if the data is just going to sit there, I feel
that it is better to create the mail files and have a table in the database that
has the file name.
That's
my 2 cents.
Marc
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 9:52 AM
To: inFusion Support List
Subject: [iMS] Shedding Lotus
Greetings,
I've been working with iMS getting bulk mailing down (as I'm sure everyone that subscribes to this list is well aware :-) and am in the process of converting our company email to web based using iMS. The trick here will be porting over everyone's archived mail from our current mail server/client, Lotus Notes.
I know I can connect via ODBC to the Lotus DB, so pulling out the messages should be possible. I'm just wondering if I'll need to create a mail file for each of these archived messages (which could easily number in the thousands) or, because we plan on using SQL 7 as the DB behind iMS, storing all archived messages in SQL and using the file method of iMS for new messages.... OR, (and this is what I'm leaning towards) having iMS place all emails into the SQL DB and not using mail files.
Any input would be, as always, greatly appreciated!
Jason Bailey
Senior Client / Server Developer
Alcott + Routon
615.346.5236
