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.
you’ll find it here:http://kx.com/q/c/http://kx.com/q/c/odbc.kOn Apr 14, 4:52?pm, “dan g.” <dan.guid…> 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.</dan.guid…>
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.