|SQL Server||Visual Studio|
|SQL Server 2005||Visual Studio 2005|
|SQL Server 2008||Visual Studio 2008|
|SQL Server 2008 SR2||Visual Studio 2010|
|SQL Server code name "Denali"|
The product supports only SQL Server 2005 (*sigh*), so I dutifully downloaded the VS 2005 installer from my MSDN subscription. The downloaded file is a .ISO file, which is an optical media image. Not wanting to burn a DVD (*sigh, again*), and otherwise being incapable of writing optical media on my office workstations, I naturally decided to extract files from the .ISO disc image file. ISOs are, after all, simply a type of archive (.ZIP, .TAR, etc.).
All versions of Microsoft Windows Vista and 7 have a Windows XP Mode Virtual PC support built in. Every license of Vista and 7 include a virtual Windows XP machine. All virtual machine software allows for mounting ISO files in the virtual machine optical drive, instead of mapping to the physical optical drive of the host machine. Once mounted, the contents of the ISO file may be browsed, as on physical optical media.
How to Use Virtual PC to Extract Files from ISO Files
- Launch the Windows XP Mode Virtual PC, or any other virtual machine.
- Using Microsoft Virtual PC (it's free!), simply change the CD-ROM settings of the virtual machine, to use the desired ISO file. This may be done, while the virtual machine is running. The image, below, illustrates the setting used to mount the downloaded VS 2005 installer.
- Launch Windows Explorer, on the virtual PC
- All disk drives of the host (physical) machine are automatically mapped to the virtual machine as netowrk drives, by default. Expand the directory folders in the tree menu, by clicking the [+] icons, until the desired destination directory is visible.
- Select the optical drive (CD, DVD, or BluRay) in the tree menu. You will see files appear in the right window pane. If the auto-play feature is enabled on the virtual machine, a program may be automatically launched:
- Close the launched application
- Right-click the optical drive in Windows Explorer. The context menu appears
- Click the Explore menu item, in the context menu
- Select the file(s) you wish to extract from the ISO image, in the right window pane
- Using the mouse pointer, drag the selected files onto the destination folder, in the tree menu
- When the mouse button is released, the selected files are copied to the destination directory. If this directory is on the host machine, no virtual disk space will be used on the virtual machine; because, the ISO image resides on the host, and files are simply being routed through the virtual machine.