Want to transfer data from SQL Server to Redis without programming?
Using RedisDataStudio, a native GUI tool, you can transfer data from SQL Server to Redis easily and fast, just a few mouse clicks!
Support Windows, Linux, macOS.
Transfer data from SQL Server To Redis
Log in to SQL Server database.
Log in to Redis.
You can transfer data from SQL Server table or sql query results to Redis, in 3 formats.
For example, you have a SQL Server 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 SQL Server to Redis.
Here you can Download RedisDataStudio
