After you have already activated RDS, it only takes three steps to perform data queries in DMS.
Step one: Log on to the RDS console and go to the Accounts page to create a database account.
Step two: Click Log on to Database, specify the RDS instance endpoint, database username, and password, and click Log On.
Step three: Select SQL Operations > SQL Window and enter the following SQL statements.
create database dmstest;create table test_table(id int,name varchar(30));insert into test_table values(1,'a'),(2,'b'),(3,'c');select * from test_table;
Summary
DMS provides professional data management services for relational databases such as MySQL, SQL Server, PostgreSQL, MongoDB, and Redis, as well as NoSQL databases, and supports the management of databases deployed on ECS instances.
DMS offers two versions:
DMS Free Edition provides free basic features to meet the management needs of new users.
DMS Advanced Edition meets advanced requirements and is suitable for experienced users with complex database management needs.
Basic database management: Features such as executing SQL statements and editing table structures.
Auditing and rollback of database operations: Features such as detailed logging of database operations by each Alibaba Cloud account and data recovery.
Efficient database connection: Features such as data copying across database instances and table structure comparison between test and production databases.
Data visualization and monitoring: Features such as graphing based on SQL result sets and business table monitoring.