Sunday, March 11, 2012

Access Upsizing Wizard Size problem

I am using the Upsizing Wizard to create a copy of an Access database as a SQL Server database. The original .mdb is 14 mb. The resulting MSSQL database is 72 MB. Why the huge increase in size?I would be willing to bet that the database you are working with has a lot of fields with unspecified length. The wizard probably over-compensated by making all of the character fields nvarchar(4000) or something silly like that. Peruse the datatypes in your tables, and think to yourself if you really need that much room in any of the fields.|||Good idea, but that was not it. The fields are all the size they should be.|||How are you measuring the size? Is this the size of the data portion, the log portion, or the sum of both?|||Right-clicking on the database in Enterprise Manager, and choosing Properties.

No comments:

Post a Comment