是的,AWS DMS(数据库迁移服务)可以用于从本地到云端的RDS(关系型数据库服务)迁移,而无需入站网络连接。以下是一个使用AWS CLI命令示例的解决方法:
首先,确保您已安装并配置了AWS CLI。如果尚未安装,请参考AWS CLI文档进行安装和配置。
创建一个JSON文件,命名为dms-task-settings.json
,并将以下内容复制到文件中:
{
"TargetMetadata": {
"TargetSchema": "",
"SupportLobs": true,
"FullLobMode": true,
"LobChunkSize": 64,
"LimitedSizeLobMode": false,
"LobMaxSize": 0,
"InlineLobMaxSize": 0,
"LoadMaxFileSize": 0,
"ParallelLoadThreads": 0,
"ParallelLoadBufferSize": 0,
"BatchApplyEnabled": false,
"TaskRecoveryTableEnabled": false,
"ParallelLoadQueuesPerThread": 0,
"ParallelApplyThreads": 0,
"ParallelApplyBufferSize": 0
},
"FullLoadSettings": {
"TargetTablePrepMode": "DROP_AND_CREATE",
"CreatePkAfterFullLoad": false,
"StopTaskCachedChangesApplied": false,
"StopTaskCachedChangesNotApplied": false,
"ResumeEnabled": false,
"ResumeMinTableSize": 100000,
"ResumeOnlyClusteredIndex": false,
"MaxFullLoadSubTasks": 8,
"TransactionConsistencyTimeout": 600,
"CommitRate": 10000
},
"Logging": {
"EnableLogging": false,
"LogComponents": [
{
"Id": "SOURCE_UNLOAD",
"Severity": "LOGGER_SEVERITY_DEFAULT"
},
{
"Id": "SOURCE_CAPTURE",
"Severity": "LOGGER_SEVERITY_DEFAULT"
},
{
"Id": "TARGET_LOAD",
"Severity": "LOGGER_SEVERITY_DEFAULT"
},
{
"Id": "TARGET_APPLY",
"Severity": "LOGGER_SEVERITY_DEFAULT"
},
{
"Id": "TASK_MANAGER",
"Severity": "LOGGER_SEVERITY_DEFAULT"
}
]
},
"MigrationType": "full-load",
"TableMappings": [
{
"SourceTable": {
"SchemaName": "",
"TableName": ""
},
"TargetTable": {
"SchemaName": "",
"TableName": ""
}
}
],
"SourceEndpoint": {
"EndpointIdentifier": "",
"EndpointType": "source",
"EngineName": "",
"UserName": "",
"Password": "",
"ServerName": "",
"Port": ,
"DatabaseName": ""
},
"TargetEndpoint": {
"EndpointIdentifier": "",
"EndpointType": "target",
"EngineName": "",
"UserName": "",
"Password": "",
"ServerName": "",
"Port": ,
"DatabaseName": ""
}
}
请确保将文件中的
替换为您的实际值。例如,将
替换为本地数据库的架构名称。
aws dms create-replication-task --replication-task-identifier --migration-type full-load --table-mappings file://dms-task-settings.json
请将
替换为您的任务标识符。
aws dms start-replication-task --replication-task-arn
请将
替换为您的任务ARN。
这样,您就可以使用AWS DMS从本地迁移到云端的RDS数据库,