[AccessD] upsizing

Hi Susan,

In the database I just converted this afternoon using SSMA, Yes/No values
were converted to bits, and Allow Nulls is checked true.

My SSMA version is 1.2.852, which is the latest version for Access 2003 and
SQL Server 2005.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, July 30, 2008 5:46 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] upsizing

SSMA converts Access Yes/No fields to tinyint, instead of bit -- does anyone

have an explanation for that?

My guess is it's because SQL Server's bit didn't support NULL's until 7.0, 
but it seems like the wizard would keep up with something like that. I 
really can't recall if Access' Yes/No always supported NULLs or not.

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com