I'm working on moving a large number of documents from an older document management system to SharePoint (MOSS 2007). The original system stored the documents as binary data in image fields in a SQL server database.
My thought is to programmatically create multiple document libraries to group these documents. I then plan to read the binary data out to a filestream and then use that stream to upload the file to SharePoint.
Has anyone done something similar? Is there a better approach than what I'm working on? Also, if anyone has any examples of reading from a binary database field and writing to a SharePoint document library, I would appreciate it. Thanks.