Framework to Migrate data from SQL Server and from DB2 to RIAK for Java application

sangeetha.subramanian at sangeetha.subramanian at
Tue Jul 1 01:22:36 EDT 2014

Thanks a lot

-- Sangeetha

From: Dmitri Zagidulin [mailto:dzagidulin at]
Sent: 30 June 2014 19:21
To: sangeetha.subramanian at
Cc: riak-users
Subject: Re: Framework to Migrate data from SQL Server and from DB2 to RIAK for Java application

As Bryan mentioned, above, the first thing you want to double-check, when migrating your blob type column to Riak, is the typical (and max) blob size.
If your objects are less than 1mb, then storing in Riak should be fine. If the max object size runs larger than 1mb, you should store those blobs in Riak CS (it's built on top of Riak, and serves exactly this use case).
As far as migrating a column or a table to Riak, we do not have any SQL migration tool - you would have to write the migrating code yourself.
The main thing to keep in mind, when loading massive amounts of data into Riak, is to take advantage of Riak's parallelism. Spin up multiple worker threads to issue puts, and be sure to take advantage of the Java client's connection pooling.
There is some good sample Java code for loading objects into Riak in the Riak Data Migrator repo ( ),

Take a look at
for some example code.

On Mon, Jun 30, 2014 at 3:22 AM, Sangeetha <sangeetha.subramanian at<mailto:sangeetha.subramanian at>> wrote:
Hi there,

We are planning to migrate data from SQL Server and DB2 to RIAK.

Right now we have a table with a column type blob. Querying this table is
causing huge traffic.
Is moving the column alone to RIAK is better or moving the table as whole to
RIAK is better. What is the best way to do this ?

We develop java application to access the RDBMS. Could someone tell me on
what is the best approach to migrate data from SQL Server and also from DB2
to RIAK.
Is there any common approach which can be used both DBs ? Please let me know


View this message in context:
Sent from the Riak Users mailing list archive at

riak-users mailing list
riak-users at<mailto:riak-users at>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the riak-users mailing list