Hello all, new to the community and interested in learning more about the migration process. I found the Wiki located here User Migration - Zimbra :: Wiki, but I didn't see the information I am specifically interested in learning.
We have a web-based application that is currently in development. We will be migrating about 850 database instances each on a devoted server to our singular instance, and we will likely be using Zimbra to support the email scope of our application.
Currently fragments of email messages are handled/stored in a multitude of places within the application's database and historical information has been stored starting at the inception of the system (by design). For instance we have message body, uidl, email accounts, email history etc.. in a variety of different tables. The idea here is that all the information currently stored in the app's database will need migrated to the Zimbra tool.
The plan was that an SSIS (SQL Server Integration Services) package would be created to modify and massage this data into a format which is acceptable to be imported into a Zimbra instances. My question is, what exactly would target format look like, and what are the list of requirements for a successful import into Zimbra from an SQL Server database. I've been told that each individual email must be exported in a single txt document, is this correct? If so how this this document be delimited.
Thanks Again & Cheers!