3 years ago
I am unable to load an mdb file from sql server 2k5 to kdb+. Heeeeelp!
Hi,
I have consulted the documentation and tried out the syntax given on q for mortals, but it doesn't work.
I have the file odbc.k and have saved it at W32, now my question is how to use it in data transfer from SQL Server to kdb+.
(From the documentation) This is not working for me...
>q w32/odbc.k
q).odbc.load`northwind.mdb / will load entire database
Plus I have got the following syntactical questions about odbc.k:
1. What is the syntax to copy a database from a remote location into
kdb+?
2. How to copy specific tables from a database in kdb+?
Anyone providing pointers to people who are experts and could help would be great for me.
Thanks,
Sayan
I have consulted the documentation and tried out the syntax given on q for mortals, but it doesn't work.
I have the file odbc.k and have saved it at W32, now my question is how to use it in data transfer from SQL Server to kdb+.
(From the documentation) This is not working for me...
>q w32/odbc.k
q).odbc.load`northwind.mdb / will load entire database
Plus I have got the following syntactical questions about odbc.k:
1. What is the syntax to copy a database from a remote location into
kdb+?
2. How to copy specific tables from a database in kdb+?
Anyone providing pointers to people who are experts and could help would be great for me.
Thanks,
Sayan
Separate topics with commas, or by pressing return. Use the delete or backspace key to edit or remove existing topics.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$1 Answer
Can't you use Data Transformation Services in SQL and connect to kdb+ through ODBC? This should allow you to move all of your data out of SQL Server.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
Hmm gotta try that. Thanks!