cancel
Showing results for 
Search instead for 
Did you mean: 

Sql Server to KDB

dan_guidara
New Contributor
Hi... I was wondering what the best would be to copy a sql serverdatabase to kdb+ one. I saw in the code.kx that there is a odbc.kfile but I dont seem to have that with evaluation edition.
4 REPLIES 4

simon
New Contributor
you'll find it here:http://kx.com/q/c/http://kx.com/q/c/odbc.kOn Apr 14, 4:52�pm, "dan g." wrote:> Hi... �I was wondering what the best would be to copy a sql server> database to kdb+ one. �I saw in the code.kx that there is a odbc.k> file but I dont seem to have that with evaluation edition.



Thanks. it was a fairly large table, so I think I am going to export
it out to a csv first and then run .Q.fs so I avoid the 2GB memory
limit.



that's a good way of doing it
have a look at csvguess.q (which can write you a loader script)
and csvutil.q at http://kx.com/q/e or on code.kx



Thanks I will look into that.

I have about 40 GB/15,000 files that I am going to want to loop over
and build into a trade and quote table. When I figure it out I will
post the file.