Re: Copy From SQL server

Hello Soumik, On 01.08.2013, at 12:43, soumik ghosh 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