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 soumikgh@gmail.com wrote:
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" soumikgh@gmail.com 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
Sorry, that URL should be https://github.com/topicus-ini/mssql2monetdb
Best regards, Dennis Pallett Op 1 aug. 2013 18:53 schreef "Dennis Pallett" dennis@pallett.nl het volgende:
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" soumikgh@gmail.com 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 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
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 Hannes.Muehleisen@cwi.nlwrote:
Hello Dennis,
On 01.08.2013, at 12:53, Dennis Pallett 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 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 <Hannes.Muehleisen@cwi.nl mailto:Hannes.Muehleisen@cwi.nl> wrote:
Hello Dennis, On 01.08.2013, at 12:53, Dennis Pallett <dennis@pallett.nl <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
participants (5)
-
Dennis Pallett -
Hannes Mühleisen -
Martin Kersten -
Radovan Bičiště -
soumik ghosh