EM uses 20+MB of space to create 2MB of scripts?

  • I'm trying to script out all of my database objects. I'm using EM, Generate SQL Script, Script all objects, Script database, database users, databse roles, SQL Server logins, object-level permissions, indexes, and Primary/Foreign keys.  Each to its own file.

    When this process is complete, I have 2.18 MB of scripts in my folder.

    However, if I run this (EM, Generate SQL Script, etc) and try to save these files to a drive that only has 20 MG of free space, I run out of space before the process is complete. 

    How come creating 2.18 MB of scripts takes up more than 20 MB in the process?

    Thanks to anyone who can shed light on this for me.

    Jana


    J. Bagwell

    UVA Health System

  • This was removed by the editor as SPAM

  • I do not believe that it is the EM at fault. It's the OS. You're probably a victem of disk fragmentation.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply