incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pierre Chalamet <pie...@chalamet.net>
Subject RE: Importing data from SQL Server
Date Mon, 11 Mar 2013 14:41:55 GMT
You can quickly create a query using dapper and then transfer all your rows  using cassandra-sharp
actually. The only thing you have to do is to create a class to materialize a row and obviously
the SQL and CQL statements.

I also have a pending change for cassandra-sharp-contrib that I'm planning to submit for performing
such task. If you are patient enough, you will be able to get it in a few days. This requires
cql 3 btw.

- Pierre

-----Original Message-----
From: "Kevin Burton" <rkevinburton@charter.net>
Sent: ‎11/‎03/‎2013 15:25
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subject: Importing data from SQL Server

I have seen numerous posts on transferring data from MySql to Cassandra but have yet to find
a good way to transfer directly from a Microsoft SQL Server table to a Cassandra CF. Even
better would be a method to take as input the output of an arbitrary SQL query. Ideas?
Mime
View raw message