So I almost forgot, you can use CorrugatedIron and do it all from .NET code. It is a .NET driver to Riak http://corrugatediron.org
Not sure why I did not think of it. Thanks, Jeff On Thu, Nov 1, 2012 at 3:41 PM, Dmitri Zagidulin <[email protected]>wrote: > Ah, ok. > Then I highly recommend following Jayson Barley's approach, in the > previous email. Query SQL server, compose a POCO type object, serialize it > to JSON, and store it in Riak either via the C++/C# client, or just use an > HTTP client and PUT/POST it over http. > > > On Thu, Nov 1, 2012 at 3:37 PM, Kevin Burton <[email protected]>wrote: > >> OK. **** >> >> ** ** >> >> My preferred programming language is C++ or more recently C#. I have done >> some Java programming but that was a while back. When I have played with >> JavaScript it was always in the context of Microsoft’s version of >> JavaScript.**** >> >> ** ** >> >> I would like to migrate about 5 tables. Our database is very unstructured >> so there are few to no relationships so I don’t plan on migrating >> relationships.**** >> >> ** ** >> >> The migration is really for a demo where I do a query on SQL Server and >> as close as I can (based on the model that I create) retrieve the same type >> of information using Riak and compare the performance. Then once I have a >> basic apples to apples comparison I can show the other salient features of >> Riak.**** >> >> ** ** >> >> *From:* riak-users [mailto:[email protected]] *On >> Behalf Of *Dmitri Zagidulin >> *Sent:* Thursday, November 01, 2012 2:18 PM >> >> *To:* riak-users >> *Subject:* Re: Import tables/data from Microsoft SQL Server**** >> >> ** ** >> >> Possibly. Let's step back for a second, however. Node.js might not be a >> good fit for your migration script needs. >> >> A couple of questions: >> >> 1) What's your preferred programming language? Java, python, javascript, >> etc? >> >> 2) What kind of data are you trying to migrate? (one table or many? what >> kind of joins/relationships?) >> >> 3) What sort of use case/application is this migration for? **** >> >> On Thu, Nov 1, 2012 at 3:15 PM, Kevin Burton <[email protected]> >> wrote:**** >> >> In this case the “server” is the Microsoft SQL Server. Right? So I need >> to have IIS running on the same machine as the SQL Server?**** >> >> **** >> >> *From:* riak-users [mailto:[email protected]] *On >> Behalf Of *Dmitri Zagidulin >> *Sent:* Thursday, November 01, 2012 2:07 PM >> *To:* riak-users**** >> >> >> *Subject:* Re: Import tables/data from Microsoft SQL Server**** >> >> **** >> >> Node.js http://nodejs.org/ http://en.wikipedia.org/wiki/Nodejs is a >> server-side Javascript web application framework. >> >> It is completely unrelated to Java, and will have to be installed >> separately. (It uses its own, javascript-specific package management app >> called 'npm' (it's similar to ruby gems and python's eggs), plus has some >> dependencies that you'll need to install via apt-get). >> >> Take a look here, for example, for installation instructions: >> https://github.com/joyent/node/wiki/Installing-Node.js-via-package-manager >> **** >> >> On Thu, Nov 1, 2012 at 2:53 PM, Kevin Burton <[email protected]> >> wrote:**** >> >> Sorry for the newbie question but is node.js part of the Java >> distribution for a Ubuntu Linux Server or do I need to get it as a package? >> How is it installed? I am assuming that once node.js is installed then the >> code will be just like any other Java app. Right?**** >> >> **** >> >> *From:* Jeff Kirkell [mailto:[email protected]] >> *Sent:* Thursday, November 01, 2012 1:25 PM**** >> >> >> *To:* Kevin Burton >> *Cc:* riak-users >> *Subject:* Re: Import tables/data from Microsoft SQL Server**** >> >> **** >> >> This Microsoft blog post gives a sample how to query the SQL Server**** >> >> >> http://blogs.msdn.com/b/sqlphp/archive/2012/06/08/introducing-the-microsoft-driver-for-node-js-for-sql-server.aspx >> **** >> >> **** >> >> In the record loop, you use a Riak Node driver like riak-js.**** >> >> **** >> >> I can't share the scripts I wrote due to work but I can answer anything >> you may have outside of providing the code.**** >> >> **** >> >> Thanks,**** >> >> Jeff**** >> >> **** >> >> On Thu, Nov 1, 2012 at 2:09 PM, Kevin Burton <[email protected]> >> wrote:**** >> >> Would you mind sharing that app? If you have time since I am not familiar >> with Node.js would you mind showing me how you ran it as well as the >> source. Thank you.**** >> >> **** >> >> *From:* Jeff Kirkell [mailto:[email protected]] >> *Sent:* Thursday, November 01, 2012 1:07 PM >> *To:* Kevin Burton >> *Cc:* riak-users >> *Subject:* Re: Import tables/data from Microsoft SQL Server**** >> >> **** >> >> There is nothing that I have come across. What I did in the past was run >> a quick Node.js app that pulled data out of SQL Server using one of the >> available drivers and serialize and write to Riak. It is not perfect, and >> may be slow depending on the amount of data but it does work.**** >> >> **** >> >> Jeff**** >> >> **** >> >> On Thu, Nov 1, 2012 at 1:40 PM, Kevin Burton <[email protected]> >> wrote:**** >> >> I would like some scripts or programming tools that I could use to >> transfer existing data held in Microsoft SQL Server databases into Riak. Do >> such tools exist?**** >> >> >> _______________________________________________ >> riak-users mailing list >> [email protected] >> http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com**** >> >> **** >> >> **** >> >> >> _______________________________________________ >> riak-users mailing list >> [email protected] >> http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com**** >> >> **** >> >> ** ** >> > > > _______________________________________________ > riak-users mailing list > [email protected] > http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com > >
_______________________________________________ riak-users mailing list [email protected] http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com
