Because the Enterprise Manager provided by Microsoft by default is difficult for many users to use, many users have not installed this software. In addition, many users have turned off the remote connection of the database server or installed the database server in the LAN, making external use and management difficult. Without a lot of trouble, the SSOM system can be installed on your internal server, so that external users can manage it directly using (local) connection. In mysql server management, phpmyadmin software is currently used for online management, and SQL Server (mssql) There is also a need for an online management tool like this, and thus the SSOM system for mssql management was born.
The system can manage the created SQLServer (mssql) database online. Its current main functions are as follows:
Connect to your SQL database and proceed
1. Create, delete and modify data tables
2. Create, delete, and modify field operations for each table
3. SQL statement execution container, which can execute all SQL statements, including stored procedures, and can also retrieve, insert, update, delete records and other operations
4. Back up the database. Currently, this product is being tested for the first time and is coded as Mainland China’s GB2312 code. Instructions for use:
1. In the database address column, enter the IP address of your database server. If it is on the same machine as this system, you can also use (local) to connect and enter your database name, database access account and password, and click login. Can.
2. After logging in, click Database in the left column to manage all tables, fields, records and other data in the database.
3. Click the SQL statement in the left column, and you can also run the sql script. All the operations you need can be completed, including querying the records using the select statement.
4. Click Database Backup in the left column to back up your database. Note that the backup path is the path on the database server.
Expand
