Hi William,
>Using VFP 6.0 and a test database of 2000 records, I ran the Upsize wizard to push the data to SQL Server 7.0. All went well, but every date field that is empty (not NULL, just empty) in the VFP table defaulted to 1/1/1900 in the SQL table. Nulls was checked on for the SQL table, I chose NOT to upsize Indexes, Relations or Defaults. Any ideas?
SQL Server, unlike VFP has no concept of an "empty" date, sad to say. The SQL Server default is 1/1/1900 as you observed. I changed my VFP validation rules to disallow empty dates and only allow NULLs in that case before Upsizing.
HTH,
Bill Armbrecht
VFP MCP