Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please explain the NULL MAPPING options in the upsizing wisard

Status
Not open for further replies.

jrumbaug

Programmer
Apr 27, 2003
90
US
When converting my data files to SQL with the upsizing wizard, there is an option called NULL MAPPING. The four options are:
1)general field overrides
2)general and memo fields override
3)all fields override
4)default settings

I am trying to understand the differences of these options. If I understand correctly, #1 allows nulls in most fields, #2 also allows nulls in memo fields, #3 alows nulls in ALL fields, but I am not sure what #4 does.

Jim Rumbaugh
 
I believe it is more along these lines...

1) set fields of type General in my VFP database to allow nulls in SQL Server
2) set fields of type General and type Memo in my VFP database to allow nulls in SQL Server
3) set all fields in my database to allow nulls in SQL Server
4) respect the settings I already have for the fields in my database in SQL Server

boyd.gif

SweetPotato Software Website
My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top