Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
In-Reply-To: <loom.20150914T173429-114@post.gmane.org>
References: <E9B3CD17-C275-4FF2-8BEB-A85AF1D19043@charter.net>
 <loom.20150914T173429-114@post.gmane.org>
From: Jason Kushmaul <jkushmaul@rocketfuelinc.com>
Date: Mon, 14 Sep 2015 11:55:20 -0400
Message-ID: 
 <CADT=LBw5Q=5eVjeiAdcw1Tuq2jXJbzNKr+ftfGnxYVO-ZjNkHQ@mail.gmail.com>
Subject: Re: Importing data from SQL Server
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b3442d80de14d051fb71af4

--047d7b3442d80de14d051fb71af4
Content-Type: text/plain; charset=UTF-8

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

--047d7b3442d80de14d051fb71af4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>I had to write my own, but not due to lack of support=
.=C2=A0 I found I needed to preprocess the data before I put it into cassan=
dra, you might find that beneficial. I only had 3 massive tables to worry a=
bout so it wasn&#39;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.<br></div><d=
iv><br></div><div>=C2=A0If you don&#39;t need to preprocess the data, what =
you could probably do is export your data from MSSQL to CSV (built into sql=
 mgmt studio)</div><div>=C2=A0and use CQL to import the CSV - <a href=3D"ht=
tp://www.datastax.com/dev/blog/simple-data-importing-and-exporting-with-cas=
sandra">http://www.datastax.com/dev/blog/simple-data-importing-and-exportin=
g-with-cassandra</a></div><div><br></div></div><div class=3D"gmail_extra"><=
br><div class=3D"gmail_quote">On Mon, Sep 14, 2015 at 11:37 AM, Raluca Marc=
u <span dir=3D"ltr">&lt;<a href=3D"mailto:ralu_k_17@yahoo.com" target=3D"_b=
lank">ralu_k_17@yahoo.com</a>&gt;</span> wrote:<br><blockquote class=3D"gma=
il_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-lef=
t:1ex"><br>
Kevin Burton &lt;rkevinburton &lt;at&gt; <a href=3D"http://charter.net">cha=
rter.net</a>&gt; writes:<br>
<br>
&gt;<br>
&gt; I have seen numerous posts on transferring data from MySql to Cassandr=
a<br>
but have yet to find a good way to<br>
&gt; transfer directly from a Microsoft SQL Server table to a Cassandra CF.=
<br>
Even better would be a method to take<br>
&gt; as input the output of an arbitrary SQL query. Ideas?<br>
&gt;<br>
<br>
<br>
Hello,<br>
<br>
I realize this post is pretty old, but I was wondering if you found an<br>
answer to this question and if you&#39;ve used it.<br>
I have to load data from SQL Server into Cassandra and I am completely new<=
br>
to Cassandra and all of the posts I seem to be able to find are demos<br>
about loading from MySQL into Cassandra.<br>
Any, any help would be extremely appreciated!<br>
Thank you very much!<br>
<span class=3D"HOEnZb"><font color=3D"#888888">Raluca<br>
<br>
<br>
<br>
<br>
<br>
</font></span></blockquote></div><br><br clear=3D"all"><div><br></div>-- <b=
r><div class=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><di=
v><span style=3D"font-family:verdana,sans-serif;font-size:small;font-weight=
:bold;color:rgb(0,170,238)">Jason Kushmaul</span><font color=3D"#500050" st=
yle=3D"font-family:verdana,sans-serif;font-size:small;font-weight:bold">=C2=
=A0</font><font color=3D"#500050" style=3D"font-family:verdana,sans-serif;f=
ont-size:small">| 517.899.7852</font><br></div><div><span style=3D"font-siz=
e:12.8000001907349px">Engineering Manager</span><font color=3D"#500050" sty=
le=3D"font-family:verdana,sans-serif;font-size:small"><br></font></div></di=
v></div></div></div>
</div>

--047d7b3442d80de14d051fb71af4--