Which wizard would work best when converting from VFP to SQL Server? The VFP Upsizing wizard or the one inside SQL Server?


>Hi Bret,
>
>The preferable way to deal with empty dates is to convert them to Nulls. The alternative is to store dates as character strings in SQL Server.
>
>>We are currently trying to convert a VFP database to SQL server using the wizards on SQL Server. THe problem we see is that SQL Server does not like empty date fields. Is the a way to get around this? We have quite a few tables where there is nothing in the date field.
>>
>>As a side question, does anyone have any other conversion pitfall tips I may need? So far I see the Empty date and a numeric field where VFP allowed data in but SQL states it has problems.
>>
>>Any help would be appreciated.