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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement