Wizards
SQL Server 7.0 contains more than 25 wizards designed to simplify frequent tasks, including:
- Creating databases, views, indexes, and stored procedures.
- Backing up or restoring a database.
- Configuring a publishing and distribution server for replication, and creating a publication for replication.
- Managing SQL Server database security.
- Creating a maintenance file that can be run regularly.
- Defining full-text indexing on SQL Server character-based columns.
- Creating a Web task that creates an HTML page, imports data from an HTML page, or runs an existing Web task.
Wizards can help reduce the learning curve required for a database administrator to become productive with SQL Server. In the data warehousing environment, where database administrators are often supporting many steps of the process with multiple products, this can translate into saving time and money.