I am new to databases and need some info that I'm having trouble researching. I just migrated a access database to SQL server 2005 using SQL Server Migration assistant (SSMA). I wondered how SSMA handles NULL values? Also how it treats differences between Access and SQL? Any help would be appreciated.
SSMA will create a table in SQL Server that has equivalent fields to those in Access and then transfer the data. So if you have a Text field in Access that is not Required (i.e. it allows NULL values) you will get an NVarchar(255) filed in SQL with the Nullable property set to True. When the data is migrated, the NULLs will be migrated as well.
Mike
No comments:
Post a Comment