SQL Data Types

[Hollar]

I have an ACCESS DB that uses the attachment field type. I did a test migration to SQL 2003 and the attachment fields turned into memo fields. And naturally all the attachments disappeared. Does anyone know if SQL 2008 R2 supports this field type?

Thank you,
Hollar

 

[SQL_Hell]

It doesn't support 'that' data type, but it has others such as blob (image) or filestream.

You don't really want to be storing the file in the database do you?

Personally I would store the file on disk and just keep the path in the database, or use filestream which is a combination of the two

 

[Hollar]

Thank you, I guess I'll have to find another path.

 

[mdlueck]

Personally I would store the file on disk and just keep the path in the database, or use filestream which is a combination of the two

Or consider implementing Apache Hadoop to keep "database track of files".

http://hadoop.apache.org/