Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2001
    Posts
    27

    Unanswered: 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?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    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.

  3. #3
    Join Date
    Dec 2001
    Posts
    27
    Good idea, but that was not it. The fields are all the size they should be.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    How are you measuring the size? Is this the size of the data portion, the log portion, or the sum of both?

  5. #5
    Join Date
    Dec 2001
    Posts
    27
    Right-clicking on the database in Enterprise Manager, and choosing Properties.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •