
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:

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:

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.nl>wrote:

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, 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:
-- __________________________ 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