Hello All, Could someone point me to an example of copying a table from SQL Server to MonetDB over a JDBC or ODBC bridge? Is this possible at all? Thanks Soumik
Hello Soumik,
On 01.08.2013, at 12:43, soumik ghosh
Could someone point me to an example of copying a table from SQL Server to MonetDB over a JDBC or ODBC bridge? Is this possible at all? I would probably use something like
sqlcmd -q "select * from mytable" -oc:\myfile.csv -h-1 -s"," to export the SQL server table to a CSV file, and then mclient -s "copy into mytable from 'c:\myfile.csv' using delimiters ',' locked" to load the file into MonetDB. See http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto for more information. Best, Hannes
Hi Soumik,
We have recently created a Java/JDBC tool just for this purpose and
open-sourced it on Github. Check it out at
http://github.com/topicusini/mssql2monetdb
It's still in beta and definately still has some rough edges but it is
working quite well for us.
If you encounter any problems please create a bug report in GitHub.
Best regard,
Dennis Pallett
Op 1 aug. 2013 18:43 schreef "soumik ghosh"
Hello All,
Could someone point me to an example of copying a table from SQL Server to MonetDB over a JDBC or ODBC bridge? Is this possible at all?
Thanks Soumik
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Sorry, that URL should be https://github.com/topicus-ini/mssql2monetdb
Best regards,
Dennis Pallett
Op 1 aug. 2013 18:53 schreef "Dennis Pallett"
Hi Soumik,
We have recently created a Java/JDBC tool just for this purpose and open-sourced it on Github. Check it out at http://github.com/topicusini/mssql2monetdb
It's still in beta and definately still has some rough edges but it is working quite well for us.
If you encounter any problems please create a bug report in GitHub.
Best regard, Dennis Pallett Op 1 aug. 2013 18:43 schreef "soumik ghosh"
het volgende: Hello All,
Could someone point me to an example of copying a table from SQL Server to MonetDB over a JDBC or ODBC bridge? Is this possible at all?
Thanks Soumik
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hello Dennis,
On 01.08.2013, at 12:53, Dennis Pallett
We have recently created a Java/JDBC tool just for this purpose and open-sourced it on Github. Check it out at http://github.com/topicusini/mssql2monetdb It's still in beta and definately still has some rough edges but it is working quite well for us.
great to hear that you created this, I think you missed a '-' in the URL, correct is https://github.com/topicus-ini/mssql2monetdb , right? Best Hannes
Hi Hannes, Dennis,
Thanks for your help.
@ Hannes : What you suggest is what I have been doing, going the csv route
and it works really well. However it is an extra step, which starts to
become a hassle for frequent updates from another database.
@ Dennis : Great to see this tool. I'll try it and let you know.
Best,
Soumik
On Thu, Aug 1, 2013 at 6:58 PM, Hannes Mühleisen
Hello Dennis,
On 01.08.2013, at 12:53, Dennis Pallett
wrote: We have recently created a Java/JDBC tool just for this purpose and open-sourced it on Github. Check it out at http://github.com/topicusini/mssql2monetdb It's still in beta and definately still has some rough edges but it is working quite well for us.
great to hear that you created this, I think you missed a '-' in the URL, correct is https://github.com/topicus-ini/mssql2monetdb , right?
Best
Hannes
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hi you might consider a more direct route: http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/BinaryBulkLoad regards, Martin On 8/1/13 8:48 PM, soumik ghosh wrote:
Hi Hannes, Dennis,
Thanks for your help. @ Hannes : What you suggest is what I have been doing, going the csv route and it works really well. However it is an extra step, which starts to become a hassle for frequent updates from another database. @ Dennis : Great to see this tool. I'll try it and let you know.
Best, Soumik
On Thu, Aug 1, 2013 at 6:58 PM, Hannes Mühleisen
mailto:Hannes.Muehleisen@cwi.nl> wrote: Hello Dennis,
On 01.08.2013, at 12:53, Dennis Pallett
mailto:dennis@pallett.nl> wrote: > We have recently created a Java/JDBC tool just for this purpose and open-sourced it on Github. Check it out at http://github.com/topicusini/mssql2monetdb > It's still in beta and definately still has some rough edges but it is working quite well for us.
great to hear that you created this, I think you missed a '-' in the URL, correct is https://github.com/topicus-ini/mssql2monetdb , right?
Best
Hannes
_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hi, For data load purpose we use http://kettle.pentaho.com/ . Choice of data source is yours. :) Radovan On 08/01/2013 06:43 PM, soumik ghosh wrote:
Hello All,
Could someone point me to an example of copying a table from SQL Server to MonetDB over a JDBC or ODBC bridge? Is this possible at all?
Thanks Soumik
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- __________________________ Radovan Bičiště ceos data s.r.o. třída SNP 402/48 500 03 Hradec Králové Czech Republic mobil CZ: +420 601 563 014 skype: rbiciste
participants (5)
-
Dennis Pallett
-
Hannes Mühleisen
-
Martin Kersten
-
Radovan Bičiště
-
soumik ghosh