Want to transfer data from DB2 to Redis without programming?
Using RedisDataStudio, a native GUI tool, you can transfer data from DB2 to Redis easily and fast, just a few mouse clicks!
Support Windows, Linux, macOS.
Transfer data from DB2 To Redis
Log in to DB2 database.
Log in to Redis.
You can transfer data from DB2 table or sql query results to Redis, in 3 formats.
For example, you have a DB2 table “users”, 2 records in it.
| id | name | age |
| 1 | Fred | 25 |
| 2 | Tom | 28 |
1. Store a record as JSON-encoded string in a single key.
| Key | Value |
| user:1 | {“name”:”Fred”,”age”:25} |
| user:2 | {“name”:”Tom”,”age”:28} |
2. Store a record as a Redis hash key, and each field of the record as a Redis hash key’s field.
| Key | Field | Value |
| user:1 | ||
| name | Fred | |
| age | 25 | |
| user:2 | ||
| name | Tom | |
| age | 28 |
3. Store each record as a JSON string in a Redis hash.
| Key | Field | Value |
| users | ||
| 1 | {“name”:”Fred”,”age”:25} | |
| 2 | {“name”:”Tom”,”age”:28} |
Transfer data from DB2 to Redis.
Here you can Download RedisDataStudio
