Thanks Matt,
I already have scheme replicated. Will try this method and let you know.
If first time transfer works, with QueryDatabaseTable I should be able to
replicate new records automatically, which is what I am planing to have.
Thanks,
-Sumo
Sent from my iPhone
> On Aug 12, 2016, at 8:46 AM
Sumo,
One-time migrations are possible with NiFi (although probably not a
common use case). Are the target tables created already? Some DBs
(like MySQL) support queries that return the Create Table statement,
if you get those you can use PutSQL to execute them on your target
system.
If the target
I have A set of tables to transfer, but as I have small set of tables , I can
duplicate flows if flow design works with one table.
Basically migrating an app from mainframe/DB2 to MS SQL server.
Thanks
Sumo
Sent from my iPhone
> On Aug 11, 2016, at 1:17 PM, Jeff wrote:
>
> Hello Sumo,
>
> Ar
Hello Sumo,
Are you looking at transferring data from a specific table between two
databases, or all tables?
On Wed, Aug 10, 2016 at 3:17 PM Sumanth Chinthagunta
wrote:
> I have same scheme in DB2 and SQL server.
> Is there a simple solution to transfer data with NiFi? ( one time )
> Hoping for
I have same scheme in DB2 and SQL server.
Is there a simple solution to transfer data with NiFi? ( one time )
Hoping for somebody have better idea to build the flow :)
Thanks
Sumo
Sent from my iPhone