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" <rkevinbur...@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?