Slightly OT: Size of Oracle vs MS SQL database tables

I'm working at a place where we're moving from an Oracle 10g environment to a mixed Oracle/MS SQL Server 2005 environment. (Main reason is cost; the Oracle software bid was five times the MS bid).

We've moved one database over to MS SQL Server 2005 and have discovered that all of our data tables more than double in size under MS SQL Server 2005. The net effect is to more than double the amount of disk space required to implement the same database.

A search of various sources of MS information haven't turned up a magic switch to reduce the size of these tables.

Any pointer to some information about this difference, expecially if there's something obvious that we're missing, would be greatly appreciated.

Mike Squires Received on Thu Apr 12 2007 - 07:53:06 CDT