The task of this workshop is to write SQL Server Explorer, an application that simulates SQL Server Enterprise Manager to a great extent. It will give you an excellent opportunity to use Visual Basic and learn Microsoft SQL Server 6.5. In the process of writing this application, you will learn about the server side programming of SQL Server and third party controls, as well as how to design and implement a large scale application.

At the successful completion of this project workshop, you will grasp the native Transact SQL commands for advanced SQL Server administration, use RDO, ODBC or VBSQL fluently with VB to communicate with SQL Server, use object oriented analysis and design (OOAD) techniques and implement objects using VB class modules, know how to communicate among objects of the same or different types. There are a lot of GUI screens to write in this application, it is recommended that students be divided into groups of 3-4 to cooperate in one project.

Workshop Schedule:
Total 30 meeting hours (10 weeks).

Project Outline:

1. MDI window -- the main window of SQL Server Explorer Tasks: Implement the window as an MDI window, menus, toolbar, status bar server manager as a child window
2. Server Manager: Child window that uses a treeview control to list out all the servers and their underlying objects. You are to implement 3 folders under a server:
   • Database Devices
   • Databases
   • Logins
3. Menu should change to fit the activated child window.
4. When server manager is activated, need to implement the following menus:

   Server
      Register server
      Server group

   Tools
      SQL Query Tools - to bring up the query window
      Database object transfer

   Manage
      Logins
      Database devices
      Database
      Users
      Groups
      Tables
      Indexes
      Triggers
      Stored procedures
      Views
      Rules
      Defaults
      User Defined Datatypes

   Object
      Permissions
      Dependencies

   Generate SQL script
      Drop
      Rename

   Help
      Contents
      Transact SQL help
      About
      (Help can be simplified by just invoking 
       the help files that come with SQL Server)

5. When query window is activated, need to add "Edit" menu for query text editing and "Query" menu for setting query options.