This repository contains the modernized version of SQL Server Manager Lite, a database management tool originally written in Visual Basic 6.0. The application has been updated to use more recent components, making it compatible with Visual Basic .NET. Additionally, new features have been added.
SQL Server Manager Lite is a simple tool designed for interacting with Microsoft SQL Server databases. It provides essential functionalities to manage SQL Server instances and databases efficiently.
- Restore: Restore a database from a backup file.
- Attach/Detach: Attach or detach databases.
- Backup: Create a database's backup.
- Delete: Delete databases.
- Repair: Repair corrupted databases.
- Size Information: Retrieve and display the size information of MDF and LDF files for a database.
- Kill Connections: Terminate active connections to a database.
- Show Tables: View a database's tables and it's rows.
- Show Rows: Display rows of a specific table in a SQL Server database.
- Set Guest User: Set a database's guest user.
- User Management: Add, change passwords, and delete users for a SQL Server instance.
- Default MDF/LDF Location Selection: Set the default location for MDF and LDF files of new SQL Server databases.
- Query Editor: Use the included basic query editor for the creation, editing, and execution of SQL queries.
This application's original code was authored by Martin P. Rizal. Unfortunately, I couldn't find a GitHub repository for Martin P. Rizal, and his SourceForge account has been inactive since 2016. I express our gratitude to Martin P. Rizal for the foundational work in creating this tool.
Iv've done my best to update and improve the application. Some features may not be fully operational, and a few are commented out due to mysterious errors or forgetfulness – they might need replacement or have already been replaced. I appreciate your understanding and patience!
- Clone this repository to your local machine.
- Open the project in Visual Studio.
- Build and run the application.
Ensure you have the necessary permissions and credentials to perform the database management operations.
Feel free to contribute, report issues, or suggest improvements. We welcome your input to make SQL Server Manager Lite even better.
For more information or support, please create an issue on GitHub.
Happy database management with SQL Server Manager Lite! 🚀