SQL Server Enterprise Manager allows for easy enterprise-wide configuration and management of SQL Server and SQL Server objects. SQL Server Enterprise Manager provides a powerful scheduling engine, administrator alert capability, and a built-in replication management interface.
Use SQL Server Enterprise Manager to:
- Create scripts.
- Manage backup devices and databases.
- Manage tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types.
- Import and export data.
- Transform data.