I have just installed SQL Server Express 2005 to get around the 2Gb database size limits under Access 2003. My simple 2Gb Access database (simple meaning only 10 tables with 2-10 fields each, vast majority of the data in one of them and mainly Long Integers) became nearly 4Gb when migrated using SSMA - not great when the SQL Server Express database limit is 4Gb. Shrinking makes no difference.
Can anyone suggest why in general a SQL Server Express database would be nearly twice the size as its Access equivalent. Are there some useful tricks or techniques to reduce the apparently massive overhead?
hi,
inspect your "string" based columns to see how many of them are now nvarchar (National chars, DBCS, which requires 2 time the size of a varchar)... if you think you do not need to store your data in nvarchar columns you can perhaps gain some "additional space" for free..
regards
|||That did it. I'm hugely grateful!
No comments:
Post a Comment