1

I am using Membase Server 1.7.0. bulk of data is inserted in membase, parallel I want it to insert in SQL Server also.

What are my best options to bulk load data as quickly as possible into SQL Server from Membase Server using any existing tools? Can I use some csv/other format which can just read data and store in SQL Server tables?

Please Suggest.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
malakool
  • 11
  • 1

1 Answers1

1

What you probably want to do here is use the TAP API that Membase provides. The TAP API allows you to stream all key-value pairs out of your database so for each key you read from the stream you can just do an insert into your SQL database. There is currently support for TAP in spymemcached 2.7.1, the java client for memcached/membase.

mikewied
  • 5,273
  • 1
  • 20
  • 32