We are upsizing a large VFP application from a VFP backend to an SQL-Server backend. We have always assumed that the VFP MEMO datatype should be upsized to SQL-Server's TEXT datatype, and this approach seems to work great for us without any problems.

However, we recently got feedback from an experienced SQL-Server DBA at a client who wants us to upsize to SQL-Server that this is a bad design choice because the TEXT datatype is subject to the same type of data corruption that we occasionally see in VFP's MEMO fields.

We've never heard of major problems with SQL-Server's TEXT datatype, so we would like a second opinion. Does anyone out there have experience, good or bad with SQL-Server TEXT fields, and how stable they are compared to VFP's MEMO fields? Any feedback would be appreciated.