cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sebastian Estevez <sebastian.este...@datastax.com>
Subject Re: Importing data from SQL Server
Date Mon, 14 Sep 2015 15:58:14 GMT
If you have a csv, try Brian's cassandra-loader. It is a full featured c*
java import program built with all the best practices for data loading and
writes.

https://github.com/brianmhess/cassandra-loader

All the best,


[image: datastax_logo.png] <http://www.datastax.com/>

Sebastián Estévez

Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com

[image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
<https://twitter.com/datastax> [image: g+.png]
<https://plus.google.com/+Datastax/about>
<http://feeds.feedburner.com/datastax>

<http://cassandrasummit-datastax.com/?utm_campaign=summit15&utm_medium=summiticon&utm_source=emailsignature>

DataStax is the fastest, most scalable distributed database technology,
delivering Apache Cassandra to the world’s most innovative enterprises.
Datastax is built to be agile, always-on, and predictably scalable to any
size. With more than 500 customers in 45 countries, DataStax is the
database technology and transactional backbone of choice for the worlds
most innovative companies such as Netflix, Adobe, Intuit, and eBay.

On Mon, Sep 14, 2015 at 11:55 AM, Jason Kushmaul <
jkushmaul@rocketfuelinc.com> wrote:

> I had to write my own, but not due to lack of support.  I found I needed
> to preprocess the data before I put it into cassandra, you might find that
> beneficial. I only had 3 massive tables to worry about so it wasn't that
> much extra work to code it out - your case might be different if you have
> 50 tables, or if this needs to recur.
>
>  If you don't need to preprocess the data, what you could probably do is
> export your data from MSSQL to CSV (built into sql mgmt studio)
>  and use CQL to import the CSV -
> http://www.datastax.com/dev/blog/simple-data-importing-and-exporting-with-cassandra
>
>
> On Mon, Sep 14, 2015 at 11:37 AM, Raluca Marcu <ralu_k_17@yahoo.com>
> wrote:
>
>>
>> Kevin Burton <rkevinburton <at> charter.net> writes:
>>
>> >
>> > 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?
>> >
>>
>>
>> Hello,
>>
>> I realize this post is pretty old, but I was wondering if you found an
>> answer to this question and if you've used it.
>> I have to load data from SQL Server into Cassandra and I am completely new
>> to Cassandra and all of the posts I seem to be able to find are demos
>> about loading from MySQL into Cassandra.
>> Any, any help would be extremely appreciated!
>> Thank you very much!
>> Raluca
>>
>>
>>
>>
>>
>>
>
>
> --
> Jason Kushmaul | 517.899.7852
> Engineering Manager
>

Mime
View raw message