sysadmin
permission needs to be used in the target database for migration, and the xp_cmdshell
stored procedure must be able to run. If the source instance is a TencentDB for SQL Server High-Availability Edition or Cluster Edition instance, there is no permission restriction on the target database account.Operation Type | Supported SQL Operations |
DML | INSERT, UPDATE, DELETE, REPLACE |
DDL | TABLE: CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE TABLE, RENAME TABLE VIEW: CREATE VIEW, ALTER VIEW, DROP VIEW INDEX: CREATE INDEX, DROP INDEX DATABASE: CREATE DATABASE, ALTER DATABASE, DROP DATABASE |
Type | Environment Requirements |
Requirements for the source database | The service where the source instance is located must open the file sharing port 445. The source and target databases can be connected. The server where the source database resides must have enough outbound bandwidth; otherwise, the migration speed will be affected. |
Requirements for the target database | Only migration from Basic Edition to High Availability Edition (including Dual-Server High Availability Edition and Cluster Edition) is supported, and the version number of the target instance must be later than of the source instance. The target database cannot have the same name as the source database. The disk space of the target database must be at least 1.5 times the size of the source database. The target database cannot have access requests or active businesses; otherwise, the migration will fail. |
Configuration Item | Description |
Source Instance Type | Select the source database type, which cannot be changed after purchase. In this document, select SQL Server. |
Source Instance Region | Select the source database region. If the source database is a self-built one, select a region nearest to it. |
Target Instance Type | Select the target database type, which cannot be changed after purchase. In this document, select SQL Server. |
Target Instance Region | Select the target database region. |
Specification | Select the specification of the migration link based on your business conditions. For the performance and billing details of different specifications, see Billing Overview. |
Category | Configuration Item | Description |
Task Configuration | Task Name | Set a task name that is easy to identify. |
| Running Mode | Immediate execution: The task will be started immediately after the task verification is passed. Scheduled execution: You need to configure a task execution time and the task will be started automatically then. |
| Tag | Tags are used to manage resources by category in different dimensions. If the existing tags do not meet your requirements, go to the console to create more. |
Source Database Settings | Source Database Type | The source database type selected during purchase, which cannot be changed. |
| Region | The source database region selected during purchase, which cannot be changed. |
| Access Type | Select a type based on your scenario. In this scenario, select Database. For the preparations for different access types, see Overview. Public Network: The source database can be accessed through a public IP. Self-Build on CVM: The source database is deployed in a CVM instance. Direct Connect: The source database can be interconnected with VPCs through Direct Connect. VPN Access: The source database can be interconnected with VPCs through VPN Connections. Database: The source database is a TencentDB instance. CCN: The source database can be interconnected with VPCs through CCN. For a third-party cloud database, you can select Public Network generally or select VPN Access, Direct Connect, or CCN based on your actual network conditions. |
| Cross-/Intra-Account | Intra-account: The source and target database instances belong to the same Tencent Cloud root account. Cross-account: The source and target database instances belong to different Tencent Cloud root accounts. The following uses migration under the same account as an example. |
| Database Instance | Select the instance ID of source database. |
| Account | Account of the source SQL Server database, which must have the required permissions. |
| Password | Password of the source SQL Server database account. |
Target Database Settings | Target Database Type | The target database type selected during purchase, which cannot be changed. |
| Region | The target database region selected during purchase, which cannot be changed. |
| Access Type | Select a type based on your scenario. In this scenario, select Database. |
| Database Instance | Select the instance ID of the target database. |
| Account | Account of the target database, which must have the required permissions. |
| Password | Password of the target database. |
Configuration Item | Description |
Migration Type | Select an option based on your scenario. Full migration: The entire database will be migrated. The migrated data will only be existing content of the source database when the task is initiated but not include the incremental data written to the source database after the task is initiated. Full + Incremental migration: The migrated data will include the existing content of the source database when the task is initiated as well as the incremental data written to the source database after the task is initiated. If there are data writes to the source database during migration, and you want to smoothly migrate the data in a non-stop manner, select this option. |
Specify object | Only database-level migration is supported; that is, all objects in the specified database must be migrated together. Select the database to be migrated in Source Database Object and move it to the Selected Object box. |
Was this page helpful?