DataX-MySql to SQL server

最新推荐文章于 2024-09-20 14:37:16 发布

Rone-X

最新推荐文章于 2024-09-20 14:37:16 发布

阅读量477

点赞数

分类专栏： Hadoop 文章标签： mysql 数据库 sql

本文链接：https://blog.csdn.net/RONE321/article/details/126986514

版权

Hadoop 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

{
    "job": {
        "setting": {
            "speed": {
                "channel": 5
            }        },
        "content": [
            {
                "reader": {
                    "name": "mysqlreader",
                    "parameter": {
                        "username": "xxx",
                        "passwordsss": "xxxx",
                        "where": "",
                        "connection": [
                            {
                                "querySql": [
                                "
                               select id, created, deleted, updated, version, bill_ref_id, entry, qty,
       material_ref_id, source_bill_ref_id, source_line_entry, source_line_id,
       upstream_bill_ref_id, upstream_line_entry, upstream_line_id, ext_ref_id,
       cx_material_ref_id, orig_qty, unit_ref_id, currency, price, tax_rate,
       assist_unit_ref_id, assist_qty, cx_bill_ref_id, orig_tax_amt, orig_tax_price,
       line_discount, invoice_material_ref_id, invoice_material_type, invoice_material_name,
       serial, miaoder_unit, union_operate, proportion, service_fee_rate
		from sales_invoice_line 
        where created >= '2022-09-01';
								"
                                ],
                                "jdbcUrl": [
                                    "jdbc:mysql://12.13.13.34/gods?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false"
                                ]
                            }
                        ]
                    }
                },
                "writer": {
                    "name": "sqlserverwriter",
                    "parameter": {
                        "username": "xxx",
                        "passwordsss": "xxxx",
                        "column": [
                           "id",                      
							"created",                 
							"deleted",                 
							"updated",                 
							"version",                 
							"bill_ref_id",             
							"entry",                   
							"qty",                     
							"material_ref_id",         
							"source_bill_ref_id",      
							"source_line_entry",       
							"source_line_id",          
							"upstream_bill_ref_id",    
							"upstream_line_entry",     
							"upstream_line_id",        
							"ext_ref_id",              
							"cx_material_ref_id",      
							"orig_qty",                
							"unit_ref_id",             
							"currency",                
							"price",                   
							"tax_rate",                
							"assist_unit_ref_id",      
							"assist_qty",              
							"cx_bill_ref_id",          
							"orig_tax_amt",            
							"orig_tax_price",          
							"line_discount",           
							"invoice_material_ref_id", 
							"invoice_material_type",   
							"invoice_material_name",   
							"serial",                  
							"miaoder_unit",            
							"union_operate",           
							"proportion",              
							"service_fee_rate"        
                        ],
                        "connection": [
                            {
                                "table": [
                                    "zt_sales_invoice_line"
                                ],
                                "jdbcUrl": "jdbc:sqlserver://12.136.36.33:1433;DatabaseName=exds"
                            }
                        ]
                    }
                }
            }
        ]
    }
}