DB size after Upsizing / Importing to SQL Server

[AndyHorn]

Hi all,

I've tried two different ways of converting my Access 2000 MDB to SQL Server 2000.

1.) Using the built in Upsizing Wizard in Access.
2.) Using the DTS Wizard to Import the data into SQL Server.

Once upsized from Access, the DB is 75MB in SQL Server, but when Importing the Access DB from SQL Server using DTS it is 250MB (with no Indexes or relationships).

All the same tables with data are there in both.

Can anyone shed some light as to why the big difference in size?

 

[BNPMike]

Jet is unusual in that if only takes up the space that is actually used by text fields. I strongly suspect SQL Server will always allocate 255 bytes if you say a field is 255 bytes but only has 'Yes' in it. So first check your field sizes have not been declared too big.

 

[AndyHorn]

Thanks BNPMike I'll have a look at that.

It hasn't caused a problem, I was just curious as to why they were so different and wondered if I'd done something wrong.

Thanks for the tip!