G
guyinkalamazoo3
Guest
I just need some guidance and I have been scouring the internet for kind of an answer. At least I did discover the FILESTREAM database feature for SQL, which I have set up on a new SQL server instance. We are migrating data out of an AS400 DB2 mainframe over to SQL and some of the tables (files) in the AS400 contain BLOB data either in htm or rtf formats (and I think some imaging).
Can someone direct me in a proper direction for doing this as we would love to use the file system for this data instead of the SQL database. And am I going in the right direction for doing this in VB with entity class files, etc, or should this be done in something like SSIS?
I posted in this forum as maybe someone has done this in VB using LINQ, ADO or something else. And no, I dont want a third-party app
Thanks for the information and guidance
Brad Allison
Continue reading...
Can someone direct me in a proper direction for doing this as we would love to use the file system for this data instead of the SQL database. And am I going in the right direction for doing this in VB with entity class files, etc, or should this be done in something like SSIS?
I posted in this forum as maybe someone has done this in VB using LINQ, ADO or something else. And no, I dont want a third-party app
Thanks for the information and guidance
Brad Allison
Continue reading...