SSMS 22 Wizards and Guided Tools for SQL Server 2025

SQL Server 2025 itself does not include built-in wizards as a Database Engine feature — wizards are graphical tools provided through SQL Server Management Studio 22, the SQL Server installation program, and related components such as SQL Server Integration Services. Understanding which wizards are available, where to find them, and when to use them versus writing T-SQL directly is essential knowledge for anyone administering or developing against SQL Server 2025. This lesson covers the nine most useful wizards and guided tools in the SSMS 22 ecosystem, organized by the administrative task they support.

Use SSMS 22 for full compatibility with SQL Server 2025. The Maintenance Plan Wizard experienced temporary issues in early SSMS 21 previews due to SSIS-related changes — those issues were resolved in SSMS 21.x updates and SSMS 22. Students and developers should download SSMS 22 from https://aka.ms/ssms to ensure access to the complete wizard set alongside SQL Server 2025-specific features.

1. SQL Server Installation Wizard

The SQL Server Installation Wizard is launched from setup.exe on the SQL Server 2025 installation media. It guides the administrator through every aspect of the installation: edition selection (including the new Enterprise Developer and Standard Developer free editions introduced in SQL Server 2025), feature selection (Database Engine, Analysis Services, Integration Services, Reporting Services), instance configuration, service accounts, collation, authentication mode, and data directory placement.

The Feature Selection page is the most important decision point in the wizard — select only the features required for the target workload. Installing unused features increases the attack surface, consumes disk space, and adds maintenance overhead without providing value. The System Configuration Checker runs automatically during setup and reports any prerequisite failures before the installation begins, preventing partial installations that are difficult to recover from.

Launch path: Run setup.exe from the SQL Server 2025 installation media → select New SQL Server stand-alone installation from the Installation Center.

2. Import and Export Data Wizard

The Import and Export Data Wizard is the most widely used data movement tool in the SSMS ecosystem. It transfers data between SQL Server and external sources or destinations including Excel workbooks, flat files (CSV, tab-delimited), Oracle databases, Azure SQL, ODBC data sources, and OLE DB providers. The wizard supports column mapping, basic data transformations, and can save the configured data flow as an SSIS package for scheduled reuse.

In SQL Server 2025 environments, the Import and Export Wizard is commonly used to load initial data into new databases, migrate data from legacy systems, and move data between on-premises SQL Server instances and Azure SQL. For more complex ETL requirements — multi-source joins, conditional transformations, error handling — SSIS packages or Azure Data Factory pipelines are more appropriate.

Launch path:

Object Explorer → right-click a database → Tasks → Import Data
Object Explorer → right-click a database → Tasks → Export Data

3. Maintenance Plan Wizard

The Maintenance Plan Wizard creates automated maintenance tasks that run on a schedule through SQL Server Agent. It is the recommended starting point for configuring the routine maintenance that every SQL Server 2025 production instance requires. The wizard generates SQL Server Agent jobs backed by SSIS packages — a more complex architecture than raw T-SQL Agent jobs, but one that provides a visual design surface for maintenance plan modification after initial creation.

Tasks configurable through the Maintenance Plan Wizard include:

• Database backups — full, differential, and transaction log backups with configurable destination paths, backup compression, and retention periods. SQL Server 2025 adds support for backups to immutable storage targets, configurable through the wizard's backup destination options.
• Index rebuild and reorganize — rebuilds or reorganizes indexes based on fragmentation thresholds. Index rebuild recreates the index entirely and updates statistics; reorganize defragments the leaf level in place with less I/O impact but less thorough results.
• Update statistics — refreshes the statistical histograms that the query optimizer uses to generate execution plans. Stale statistics are one of the most common causes of poor query performance.
• Check database integrity (DBCC CHECKDB) — verifies the physical and logical consistency of all objects in the database. Should run at least weekly on production databases.
• Cleanup history — removes old SQL Server Agent job history, backup history, and maintenance plan history from the msdb system database to prevent it from growing unbounded.

Launch path:

Object Explorer → Management → Maintenance Plans → right-click → Maintenance Plan Wizard

4. Backup and Restore Wizards

The Backup and Restore wizards provide step-through interfaces for database backup and recovery operations that are more approachable than writing BACKUP DATABASE and RESTORE DATABASE T-SQL statements directly. Both wizards generate the equivalent T-SQL in a script preview pane before execution, making them a useful learning tool for understanding the underlying syntax.

The Backup wizard supports full, differential, and transaction log backup types; backup to disk, tape, or URL (Azure Blob Storage); backup compression; backup encryption using SQL Server certificates or asymmetric keys; and copy-only backups for ad-hoc backup needs that should not affect the differential backup chain.

The Restore wizard supports point-in-time recovery by displaying the available backup sets in the correct restore sequence — full backup, then differential, then transaction log backups in chronological order. The Timeline button opens a visual timeline that allows selection of a specific recovery point within the transaction log backup window.

Launch path:

Object Explorer → right-click a database → Tasks → Back Up...
Object Explorer → right-click a database → Tasks → Restore → Database...

5. Generate Scripts Wizard

The Generate Scripts Wizard creates T-SQL scripts for any combination of database objects — tables, views, stored procedures, functions, triggers, indexes, constraints, and data. It is the standard tool for exporting database schema to source control, deploying schema changes to other environments, and documenting database structure.

The Advanced Scripting Options dialog provides fine-grained control over what the wizard includes in the generated script: schema only, data only, or schema and data; whether to script collation, triggers, and permissions; whether to include IF EXISTS checks before each CREATE statement; and the target SQL Server compatibility level for the generated syntax. In SQL Server 2025 environments, selecting the correct compatibility level ensures that scripts using VECTOR data types or REGEXP functions generate syntax compatible with the target instance.

Launch path:

Object Explorer → right-click a database → Tasks → Generate Scripts...

6. Copy Database Wizard

The Copy Database Wizard moves or copies a database from one SQL Server instance to another with minimal downtime. It supports two transfer methods: the SQL Server Management Object (SMO) method, which puts the source database offline during transfer and is suitable for smaller databases; and the SQL Server Agent detach-and-attach method, which uses file-level copy and is faster for large databases but requires the source database to be taken offline.

The wizard requires SQL Server Agent to be running on the destination server and the destination instance must be accessible from the source server through a linked server or direct connection. For SQL Server 2025 to SQL Server 2025 migrations within the same network, the Copy Database Wizard is efficient. For cross-version migrations or cloud-to-on-premises transfers, backup-and-restore or the Import and Export Wizard are more appropriate.

Launch path:

Object Explorer → right-click a database → Tasks → Copy Database...

7. Database Engine Tuning Advisor

The Database Engine Tuning Advisor (DTA) analyzes T-SQL workloads and recommends physical database design changes — new indexes, index modifications, partitioning strategies, and statistics updates — that would reduce the workload's execution cost based on the query optimizer's estimates. It accepts input as a workload file (a SQL script or a SQL Server Profiler trace), a plan cache snapshot, or a manual query entry.

In SQL Server 2025 environments, the DTA remains a useful starting point for identifying missing index opportunities on new databases where real workload data has not yet accumulated. For established production databases, the Missing Index recommendations visible in execution plans within the SSMS 22 Query Editor provide more targeted suggestions based on actual query patterns. The SSMS 22 GitHub Copilot integration offers a modern complement to DTA for generating index recommendations through natural-language prompts.

Launch path:

SSMS 22 menu → Tools → Database Engine Tuning Advisor

8. Always On Availability Group Wizard

The Always On Availability Group Wizard configures high availability groups that provide automatic failover and secondary replicas for read offloading and backup operations. It is available in SQL Server 2025 Enterprise and Standard editions — Enterprise supports up to eight secondary replicas plus distributed availability groups, while Standard supports basic availability groups with one secondary replica.

The wizard walks through specifying the databases to include in the availability group, configuring each replica (synchronous or asynchronous commit mode, automatic or manual failover), creating the Windows Server Failover Cluster listener, and performing the initial data synchronization. Configuring Always On requires Windows Server Failover Clustering to be installed and configured before the wizard runs — the wizard validates cluster prerequisites and reports any missing configuration before proceeding.

Launch path:

Object Explorer → Always On High Availability → Availability Groups → right-click → New Availability Group Wizard...

9. Full-Text Index Wizard

The Full-Text Index Wizard enables full-text search on character-based columns — CHAR, VARCHAR, NCHAR, NVARCHAR, TEXT, and XML columns — through linguistic indexing that supports word stemming, synonym expansion, and proximity queries. Full-text search capabilities go significantly beyond what LIKE pattern matching provides, particularly for large text columns containing documents, descriptions, or article content.

The wizard configures the full-text catalog that stores the index, selects the columns to index and their language for word breaking, and sets the change tracking mode — automatic tracking updates the index as data changes, manual tracking requires an explicit population command, and background population performs incremental updates on a schedule.

Launch path:

Object Explorer → expand a database → Tables → right-click a table → Full-Text index → Define Full-Text Index...

SSMS 22 Wizard Quick Reference

Wizards vs. T-SQL — Choosing the Right Approach

Wizards are most appropriate when: the task is performed infrequently and the exact T-SQL syntax is not immediately recalled; when visual confirmation of options reduces the risk of configuration errors; or when a student is learning what options are available for a given operation. Every SSMS 22 wizard generates the equivalent T-SQL in a preview pane before execution — reviewing this generated T-SQL is a highly effective way to learn the underlying statement syntax.

T-SQL scripted directly in the Query Editor is more appropriate for: repeated operations that benefit from automation and scheduling through SQL Server Agent; deployments to multiple environments where consistent execution is required; and production changes where the exact statement must be reviewed, tested, and documented in source control before execution. In SQL Server 2025 environments, GitHub Copilot in SSMS 22 can generate the T-SQL equivalent of most wizard operations through natural-language prompts — bridging the gap between wizard convenience and scripted precision.

Summary

SSMS 22 provides wizards for the full range of SQL Server 2025 administration and development tasks. The Installation Wizard guides setup and feature selection. The Import and Export Wizard moves data between SQL Server and external sources. The Maintenance Plan Wizard automates backup, index rebuild, integrity check, and statistics update jobs through SQL Server Agent. The Backup and Restore wizards support point-in-time recovery with visual timeline selection. The Generate Scripts Wizard exports schema and data as deployable T-SQL. The Copy Database Wizard transfers databases between instances. The Database Engine Tuning Advisor recommends physical design improvements from workload analysis. The Always On Availability Group Wizard configures high availability with automatic failover. The Full-Text Index Wizard enables linguistic search on text columns. Every wizard generates T-SQL that can be reviewed, modified, and saved — making wizards a practical learning tool for understanding the SQL Server 2025 statement syntax that drives each operation. The next lesson concludes this module.