SQL Server Database size?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
aladin11 Members Profile Find Members Posts Groupie Joined: 10 October 2009 Status: Offline Points: 70	Post Options Post Reply Quote aladin11 Report Post Thanks(0) Quote Reply Topic: SQL Server Database size? Posted: 12 January 2010 at 3:34pm
	Hi all, I have a WWF Access database at about 120 MB (after compacted and resized). Using SSMA to convert this .mdb to SQL Server Express 2005, I get the new SQL database size of 125 MB. I just wonder, Is that normal?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 13 January 2010 at 9:58am
	Seems about right. However, you need to watch SSMA as it often doesn't do a proper conversion. Usually when we use this you have to go through the database and remove any constraints that SSMA adds to the SQL Server database.
	Web Wiz Forums Hosting ASP.NET Web Hosting

aladin11 Members Profile Find Members Posts Groupie Joined: 10 October 2009 Status: Offline Points: 70	Post Options Post Reply Quote aladin11 Report Post Thanks(0) Quote Reply Posted: 15 January 2010 at 1:00pm
	Thanks Bruce, I had to manually remove the constraints. Do you think Ms Access Upsizing Wizard is a better tool to convert?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 15 January 2010 at 3:08pm
	They both have their pros and cons. Here in the office when migrating a Web Wiz Forums Access version to our servers for customers we use SSMA to convert the Access database to SQL Server like you do and then manually go through and fix any errors.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.