Export (0) Print
Expand All

How to create a new project

SQL Server 2000

A new project can be created using the SQL Project or OLAP Project wizards, or from an empty project.

To create a new project

  1. On the File menu, click New Project.

  2. On the New tab of the New Project dialog box, enter a name and location for the project.

  3. Double-click one of following three options:
    • SQL Project Wizard

      Connect to the appropriate SQL database and then choose the tables to automatically create an English Query SQL model based on selected entities and relationships from the database. To create additional entities and relationships use the commands on the Model menu.

    • OLAP Project Wizard

      Connect to the appropriate Microsoft® SQL Server™ 2000 Analysis Services database and then choose the cubes to automatically create an English Query OLAP model based on selected entities and relationships from the structures (cubes including dimensions, levels, measures, properties, and facts). To create additional entities and relationships by use the commands on the Model menu.

    • Empty Project

      Create a new, blank project. Connect to the appropriate database. Then specify the database structure manually by creating database objects using the Model menu, or by selecting tables and views with the Import Tables command on the Model menu.

  4. On the File menu, choose Save All to save all of the components of the project.

    To save only the module, choose Save <module name.eqm>.

    Note  If the project is not saved before it is closed, all of the work will be lost when it is closed. A project is not saved until one of the Save commands is selected.

See Also

How to create a new project using the SQL Project wizard

How to create a project using the OLAP Project wizard

OLAP Project Wizard

Project Wizards

SQL Project Wizard

Show:
© 2014 Microsoft