>Hi,
>
>I have converted a VFP9 app to C/S using local tables initially using the Promatrix Framework. I am using the Sedna Upsizing Wizard to move data to SQL Server 2012 on my WIN 10 laptop for testing. I tried SQL Server and SQL Server Native Client 11.0 drivers.
>
>It seems the wizard defaults to TEXT for a MEMO data type.It works on some files and fails on others. I heard the TEXT data type should not be used since it is being phased out. When I change it to varchar(max) either it fails or sometimes it excludes numerous records as errors.
>
>Anyone have this same issue? What can I do to successfully use the wizard to upsize data?
>Also should I check the NULLS box in the wizard or not necessary?
Nulls may be an issue - if the target field doesn't allow nulls and your code tries to insert them, then you'd get an error and the record would be skipped.
Another thing, if your memos may contain binaries, make sure you have AutoTranslate=No in your connectstring, or else it may do some haircut on your bytes - strip the diacriticals etc.