Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

Help with freetds

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Help with freetds
# 1  
Old 07-02-2012
Help with freetds
Hi all,

I have an MS-Sql 2008 server. I need to perform a bulk insert of data (over 1 million records every hour) from an Ubuntu box. Doing this in python using pymssql takes about 30 seconds for every 100,000 records.

I've installed the freetds suite on this ubuntu box. While tsql and isql are able to connect and execute queries successfully, only freebcp keeps throwing a "Msg 2410, Level 2" "Cannot bcp with TDSVER < 5.0" error.

The same bcp tool (Microsoft's version) on a Windows XP virtual box on the same Ubuntu box, can insert to the SQL server without any problem the entire 1million records in just 30 seconds.

I've checked and re-checked every configuration for freetds. It's puzzling why tsql and isql work, but freebcp doesn't.

Any help/pointers on getting freebcp to work or how to get such large data inserted quickly is greatly appreciated.
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

python-coverage

PYTHON-COVERAGE(1)					      General Commands Manual						PYTHON-COVERAGE(1)

NAME

       python-coverage - measure code coverage of Python program execution

SYNOPSIS

       python-coverage -x module.py [ARG...]
       python-coverage -e
       python-coverage -r [-m]
       python-coverage -a [file...]

DESCRIPTION

       python-coverage	executes  a Python program and measures which of its statements are executed and which are not.  It stores the information
       in the file .coverage in the current working directory.

OPTIONS

       -e     Erase the .coverage file.

       -x     Execute a Python module, giving it the remaining command line arguments.

       -r     Produce a coverage report.

       -m     With -r, show the line numbers that were missed by the execution.

       -a     Annotate source files.  For each source file foo, produce foo,cover, with executed lines prefixed by ">" and non-executed by "!".

       --help Produce a help summary.  It might be more helpful than this manual page.

AUTHOR

       The python-coverage command is a one-line Python script which calls the coverage.py Python module to do all the work.  The module was rigi-
       nally developed by Gareth Rees, and is now developed by Ned Batchelder.	The module's home page is
       http://www.nedbatchelder.com/code/modules/coverage.html.

       This manual page was cobbled together by Lars Wirzenius for Debian, by copy-pasting from the help texts from the module.

																PYTHON-COVERAGE(1)