{infiniteZest}
// Articles. Tutorials. Utilities.
Home  |   Search  |   Login  
Categories Skip Navigation Links
New / All
AJAX
Apple
ASP.NET
.NET
Git
Google / Android
Python / IronPython
Miscellaneous
SQL Server
Using SQL Server on a Mac with Fusion
Summary
This article talks about using SQL Server in a virtual environment. Here the operating system installed is Windows Vista Ultimate on a Mac using VMware Fusion. The DBMS version used is SQL Server 2008. Adventure Works database is installed on top of this in the virtual environment and tested by issuing queries and creating database diagrams inside SQL Server Management Studio. Simple testing is also done with SQL Server Business Intelligence Development Studio on Windows virtual machine.
 
Table of Contents

Installing Fusion and creating a Windows virtual machine

SQL Server Tools and Processes

Figure 1. SQL Server 2008 Tools installed on a Windows Vista Ultimate virtual machine created with VMware Fusion.

Figure 2. SQL Server Services from the SQL Server Configuration Manager. These services are running inside a Vista virtual machine on an iMac.

Installing Sample Databases

Figure 3. Installing the Adventure Works database on SQL Server 2008. This SQL Server is on a virtual machine.

Figure 4. The samples and databases from AdventureWorks are installed on this virtual machine.

Figure 5. Installing Adventure Works 2008. Needs a couple of features enabled.

Figure 6. Finished installation of AdventureWorks Database on Vista on Mac.

Databases in SQL Server Management Studio

Figure 7. Top 1000 rows from the Person table from the SQL Server Management Studio on Vista on Mac.

Figure 8. Database Diagram for the Person table in the SQL Server Management Studio on a Vista virtual machine.

SQL Server Business Intelligence Development Studio

Figure 9. Business Intelligence project templates in Visual Studio 2008. This is running on a Vista virtual machine on an iMac.

Figure 10. A sample Analysis Services Project built and deployed from Business Intelligence Studio on a Vista virtual machine.

Summary

More Articles on Fusion

 
Article Series
Previous Article:
Installing SQL Server on a Mac with Fusion
This article is part of the Series:
Article Series: Fusion on a Mac
Next Article:
Installing Visual Studio on a Mac with Fusion

Installing Fusion and creating a Windows virtual machine

For this article series, VMware Fusion was used as the virtualization software for Mac. So, before any virtual machines (Windows, Ubuntu / Linux) were created, Fusion software was installed on the Mac. Please refer to the following article for notes on installing Fusion on the Mac:

Installing Fusion on Mac OS X

Then a Windows Vista Ultimate virtual machine was created on the Mac with Fusion software. For notes on creating a Vista virtual machine on Mac, please refer to the following article:

Installing Windows on a Mac with Fusion

Then on top of that, SQL Server was installed. Please refer to the following article for notes on that:

Installing SQL Server on a Mac with Fusion

Rest of this article goes through using the SQL server created (as above) on a virtual machine.

SQL Server Tools and Processes

Installation of SQL Server 2008 gives several tools. One of the most important of these tools is SQL Server Management Studio. Following is the listing the tools installed with SQL Server 2008:

  • SQL Server Management Studio
  • SQL Server Business Intelligence Development Studio
  • SQL Server Profiler
  • Import and Export Data
  • Deployment Wizard from Analysis Services
  • Several Configuration Tools
  • Integration Services
  • Documentation and Tutorials

Figure 1. SQL Server 2008 Tools installed on a Windows Vista Ultimate virtual machine created with VMware Fusion.

Figure 1. SQL Server 2008 Tools installed on a Windows Vista Ultimate virtual machine created with VMware Fusion.

SQL Server also uses many services. These are the SQL Server services running on this virtual machine created with Fusion:

  • SQL Server (for the instance)
  • SQL Server Browser
  • SQL Server Agent
  • SQL Full-text Filter Daemon Launcher
  • SQL Server Active Directory Helper
  • SQL Server Analysis Services
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • SQL Server VSS Writer

Figure 2. SQL Server Services from the SQL Server Configuration Manager. These services are running inside a Vista virtual machine on an iMac.

Figure 2. SQL Server Services from the SQL Server Configuration Manager. These services are running inside a Vista virtual machine on an iMac.

Installing Sample Databases

To test the functionality of the SQL Server database, a sample database (Adventure Works) is installed. The sample database Adventure Works can be obtained from the following location:

Adventure Works Sample Database

Figure 3. Installing the Adventure Works database on SQL Server 2008. This SQL Server is on a virtual machine.

Figure 3. Installing the Adventure Works database on SQL Server 2008. This SQL Server is on a virtual machine.

The default location for these samples is: C:\Program Files\Microsoft SQL Server𖟄\.

Figure 4. The samples and databases from AdventureWorks are installed on this virtual machine.

Figure 4. The samples and databases from AdventureWorks are installed on this virtual machine.

Figure 5. Installing Adventure Works 2008. Needs a couple of features enabled.

Figure 5. Installing Adventure Works 2008. Needs a couple of features enabled.

Figure 6. Finished installation of AdventureWorks Database on Vista on Mac.

Figure 6. Finished installation of AdventureWorks Database on Vista on Mac.

Databases in SQL Server Management Studio

After the Adventure Works samples have been installed, you can see many AdventureWorks databases in the SQL Server instance where it has been installed. The goal here is to see how the database behaves in a virtual environment.

In this case, three AdventureWorks databases are installed: AdventureWorks2008 (lot of tables), AdventureWorksDW2008 (for data warehouse), and AdventureWorksLT2008 (smaller set of tables).

Figure 7. Top 1000 rows from the Person table from the SQL Server Management Studio on Vista on Mac.

Figure 7. Top 1000 rows from the Person table from the SQL Server Management Studio on Vista on Mac.

In the figure below, a new database diagram is created using Person as the central object. In order to create this database diagram, first the Person table is selected and then all the related tables are added to the diagram. Then these tables are arranged.

As you can see in the diagram below, the Microsoft SQL Server Management Studio here is in the Windows Vista virtual machine. At the top of the window, you can see the VMware Fusion toolbar; Fusion is the virtualization software used to create the Vista virtual machine here.

Figure 8. Database Diagram for the Person table in the SQL Server Management Studio on a Vista virtual machine.

Figure 8. Database Diagram for the Person table in the SQL Server Management Studio on a Vista virtual machine.

SQL Server Business Intelligence Development Studio

SQL Server 2008 comes with Business Intelligence Development Studio. This is basically Visual Studio 2008 with templates for Business Intelligence Projects. As you can see from the figure below, following BI templates are added to Visual Studio 2008:

  • Analysis Services Project
  • Import Analysis Services 2008 Database
  • Integration Services Connections Project
  • Integration Services Project
  • Report Server Project Wizard
  • Report Model Project
  • Report Server Project

Figure 9. Business Intelligence project templates in Visual Studio 2008. This is running on a Vista virtual machine on an iMac.

Figure 9. Business Intelligence project templates in Visual Studio 2008. This is running on a Vista virtual machine on an iMac.

Figure 10. A sample Analysis Services Project built and deployed from Business Intelligence Studio on a Vista virtual machine.

Figure 10. A sample Analysis Services Project built and deployed from Business Intelligence Studio on a Vista virtual machine.

Summary

Here the test was to see if an SQL Server 2008 database server can be installed locally on a Windows Vista Ultimate virtual machine created by VMware Fusion. As you can see from the article above, the server and associated tools install fine. The tools like SQL Server Management Studio and Business Intelligence Studio work fine. However, no testing is done here to see if the server (in this particular setting) would handle a production environment. Obviously, this wouldn’t be the set up for a production environment needing performance and availability.

More Articles on Fusion

This article series on Fusion goes through a couple of virtual machines created with Windows Vista and Ubuntu operating systems. These articles also go through using popular applications like Microsoft Office, SQL Server, and Visual Studio on these virtual machines created with Fusion. They also discuss the pros and cons of virtual machines, graphics, sound, video, and Internet connections in them.

Article Series: Fusion on a Mac

Article Series
Previous Article:
Installing SQL Server on a Mac with Fusion
This article is part of the Series:
Article Series: Fusion on a Mac
Next Article:
Installing Visual Studio on a Mac with Fusion
Bookmark and Share This

More Articles With Similar Tags
icon-fusion-windows-start-bar.jpg
This article goes through creating Windows Vista Ultimate virtual machine on Mac OS X using VMware Fusion. Here a Windows Vista Ultimate virtual machine is created with 1 GB of RAM and 40 GB of hard disk space. Several screenshots of creating the Vista virtual machine are also included in this article.
icon-fusion-windows-games.jpg
This article discusses using Windows Vista Ultimate virtual machine on a Mac created and managed with VMware Fusion. Various advantages and disadvantages of using Vista virtual machine this way are discussed. Modes of usage (single window, full screen, and unity) are also discussed. Getting online video from the Vista virtual machine, the effect of Fusion on Aero, and getting automatic updates from inside the virtual machine are also discussed. Plenty of screenshots included.
icon-fusion-windows-office-on-start-bar.jpg
This article goes through installing Microsoft Office on Windows Vista virtual machine created with VMware’s Fusion. Here MS Office Ultimate is installed on Windows Vista Ultimate virtual machine. Getting PDF and XPS file format functionality for MS Office is also discussed.
icon-fusion-visual-studio-features.jpg
This article talks about installing Visual Studio on a Windows virtual machine installed on a Mac with VMware Fusion. Here the versions used are Visual Studio 2008, Windows Vista Ultimate, and VMware Fusion 2.01. Discussions on size, installed features, and MSDN are also included in this article.
This series of articles documents an experience of installing, working with, and playing with VMware Fusion on a reasonably powerful iMac. On this iMac, a few virtual machines have been created with various operating systems - Windows Vista Ultimate, Ubuntu (Linux) Desktop, and Ubuntu (Linux) Server. Also installed and tested several powerful applications like Microsoft Office Ultimate, SQL Server, Visual Studio, Eclipse, and LAMP Servers on these virtual machines. These articles go from installing Fusion to comparing various virtual machines created with it. These articles also discuss the pros and cons of virtual machines, running online video on virtual machines, and compare browsers, office applications, and programming tools across virtual machines.
About  Contact  Privacy Policy  Site Map