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.