SQL Server Database size?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28234
Printed Date: 02 April 2026 at 4:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server Database size?
Posted By: aladin11
Subject: SQL Server Database size?
Date 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?
|
Replies:
Posted By: WebWiz-Bruce
Date 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.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: aladin11
Date 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?
|
Posted By: WebWiz-Bruce
Date 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.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|