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