Wizards available in Microsoft SQL Server

Microsoft SQL Server 2022 includes a variety of wizards within SQL Server Management Studio (SSMS) to simplify common administrative and development tasks. Here's a categorized list of the most commonly available wizards in SQL Server 2022:
🔧 Database Management Wizards

1. Database Engine Tuning Advisor Wizard
   • Helps analyze T-SQL workloads and recommends indexes, partitioning, and statistics.
2. Generate Scripts Wizard
   • Creates T-SQL scripts for database objects (tables, stored procedures, etc.) and data.
3. Import and Export Data Wizard
   • Used for transferring data between SQL Server and other data sources (Excel, flat files, Oracle, etc.).
4. Copy Database Wizard
   • Copies or moves databases between servers without downtime. Note: requires SQL Server Agent to be enabled.
5. Maintenance Plan Wizard
   • Automates backups, index rebuilds, integrity checks, etc.
6. Create Login Wizard
   • Simplifies creation of SQL Server logins.
7. User Mapping Wizard (available during login creation)
   • Assigns database roles to users in one step.
8. New Publication Wizard
   • Sets up a publication for transactional, merge, or snapshot replication.
9. New Subscription Wizard
   • Creates subscriptions to publications.
10. Configure Distribution Wizard
    • Enables and configures the Distributor server.
11. SQL Server Import and Export Wizard
    • Standalone wizard for data migration between SQL Server and other sources/destinations.
12. Create Package Wizard (via SSIS)
    • Generates an SSIS package from the Import/Export Data Wizard steps.
13. Data Collection Wizard (part of Management Data Warehouse)
    • Sets up performance data collection.
14. Policy-Based Management Wizard
    • Creates or evaluates policies for SQL Server configuration compliance.
15. Database Mirroring Wizard
    • (deprecated but may be accessible depending on your SSMS version)
16. New Linked Server Wizard
    • Helps configure a connection to a remote data source.
17. Create Full-Text Index Wizard
    • Assists in enabling full-text search capabilities on tables.

Notes: Important Notes on SQL Server Wizards

• Wizards are primarily accessible via SQL Server Management Studio (SSMS), not directly through T-SQL.
• The availability of wizards may depend on the SSMS version, not just the SQL Server engine version. Ensure you're using the latest version of SSMS for full compatibility with SQL Server 2022.

Here is a diagrammatic + step-by-step guide on how to launch the most common wizards in SQL Server 2022 using SQL Server Management Studio (SSMS):
🎯 1. Import and Export Data Wizard
📍 Path:

Object Explorer > Right-click on a database > Tasks > Import Data / Export Data

📘 Use Case: Transfer data between SQL Server and Excel, CSV, Oracle, etc.
🧰 2. Maintenance Plan Wizard
📍 Path:

Object Explorer > Management > Maintenance Plans > Right-click > Maintenance Plan Wizard

📘 Use Case: Schedule backups, index rebuilds, update statistics, etc.
📦 3. Copy Database Wizard
📍 Path:

Object Explorer > Right-click on a database > Tasks > Copy Database

📘 Use Case: Move a database to another server with minimal downtime.
📄 4. Generate Scripts Wizard
📍 Path:

Object Explorer > Right-click on a database > Tasks > Generate Scripts

📘 Use Case: Script tables, stored procedures, views, and optionally include data.
🧪 5. Database Engine Tuning Advisor
📍 Path:

Tools > Database Engine Tuning Advisor (or Launch from executable: `dta.exe`)

📘 Use Case: Analyze workloads to recommend indexes, statistics, and partitioning.

📍 Path:

Object Explorer > Security > Logins > Right-click > New Login...

📘 Use Case:Create SQL or Windows logins and assign database roles.
🔁 7. Replication Wizards
📍 Path:

Object Explorer > Replication > Local Publications > Right-click > New Publication...

Object Explorer > Replication > Local Subscriptions > Right-click > New Subscription...

📘 Use Case: Set up replication (transactional, merge, snapshot).
🧮 8. Full-Text Index Wizard
📍 Path:

Object Explorer > Expand a database > Tables > Right-click table > Full-Text index > Define Full-Text Index

📘 Use Case:
Enable full-text searching on large text columns.
📊 9. Data Collection Wizard
📍 Path:

Object Explorer > Management > Data Collection > Right-click > Configure Management Data Warehouse

📘 Use Case:
Set up performance monitoring and reporting framework.