VFP wizard has one nice feature it comes with source code. So you can change the way it works if there is such need.
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only