Manage SQL Server databases, execute SQL queries, export and manage data, tamper with the database structure, and perform other routine administrative tasks.
- SQL Manager Lite for SQL Server
- Version : 4.4.1 Build 49818
- License :Freeware
- OS :Windows All
- Publisher :EMS Software Development
SQL Manager Lite for SQL Server Description
SQL Manager Lite for SQL Server is a professional database application designed to help users create and edit MS SQL Server database objects, run SQL scripts, and edit SQL queries.
Well-structured suite of features
Although it comes packed with many dedicated parameters, it sports a clean and straightforward layout that gives users the possibility to create a new database, manage the existing one, design a new table or database objects, execute queries or SQL scripts, and manage permissions.
Database navigation and management
When it comes to navigating within databases, you can edit the registration information, establish connections to the created database, as well as perform various operations with database objects, such as create a new one, edit, rename, duplicate, and define grants for the selected object.
You are offered step-by-step assistance for creating and registering databases, and you can also view and edit the registration properties and server options.
Plus, it is possible to select multiple objects, perform search operations, view additional information about objects, save SQL queries to a favourites list, as well as use several tools for managing database and server objects, such as schemas, tables, procedures, rules, operators, alerts, and credentials.
The program allows users to create, edit, execute, and save queries, view all the objects’ dependencies in one diagram, use the SQL script editor, create HTML reports, perform database backup operations and restore the information, as well as get data about the users connected to the database.
Importing/exporting options
What’s more, the program allows you to import information from DBF, XML, ODF, CSV, plain text file, or other formats. The generated data can be exported to HTML, PDF, CSV, ODF, RTF, and other formats, or saved as SQL script.
An efficient database app
All in all, SQL Manager Lite for SQL Server proves to be a reliable utility for SQL Server administration and development tasks. It offers a complete suite of tools that can meet the requirements of advanced users.