IMail has a utility, DBUpdate, that does this. It should add the columns to the tables that are assigned to the domains.
Tripp ----- Original Message ----- From: "Sanford Whiteman" <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 2:15 AM Subject: Re[2]: [IMail Forum] Upgrade from 6.05 to 7.14 > isn> Problem is we have over 400 domains and I really do not want to > isn> update each one. anyone know a way to fix this easily? > > Easily...well, depends on your SQL knowledge/interest. :) You can > certainly loop through the user tables, reading the names from your > system tables, and alter each one to add the additional columns. > > IMail doesn't do this kind of update automatically; frankly, though, I > wouldn't really want an app to grind through my db without warning. > The sheer variance in the scope of such a function (some people have > one table, others have hundreds) makes it understandable that it's > best done by the DBA. > > -Sandy > > > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html > List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ > Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
