You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by 尹文才 <ba...@gmail.com> on 2017/06/27 06:51:19 UTC
Extract data from one database into another one
Hi guys, currently I want to use NIFI processors to copy all tables and the
data inside from one database(e.g. mysql) into another database(e.g. sql
server). I know the processor QueryDatabaseTable could be used to extract
data from a database and PutDatabaseRecord could be used to write avro data
into a table in a database, but as I know PutDatabaseRecord could only work
if the destination table exists. Does anyone know the Processors I need to
get this to work? Thanks.
Regards,
Ben