Will,
Thank you for your response.
SQL Server considers empty date and string fields as NULL not empty(). Therefore if any of those fields contains empty rows the wizard will make the field except NULL values. There are many of these stituations that must be resolved when upsizing. If you plan on going to Oracle start converting all your logical fields to integers. Logical data type fields to not exist in Oracle.I was under the impression that logical fields didn't exist in SQL Server either and that they're represented throught the bit data type (0/1). The thing that puzzles me though is that I upsized with the option of structure only and no data. Hence, the table has no rows (confirmed by doing a SELECT on the new table and printing @@ROWCOUNT). Additionally, the source VFP table has no empty rows or empty columns. Any ideas?
First thing to do is change all datetime fields in VFP to allow nulls. Working with VFP, SQL Server and Oracle data sources for the past four years I find it much easier to keep the data sources as alike as possible. If you have a large number of tables in the database it is easier to write a program to do the conversion. I've got the code somewhere if you want an example.I'd be interested in taking a look at your code sample if you get the chance.
Thanks a lot.
Jon
Jon Rosenbaum
Devcon Drummer