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

pbuilder-dist-simple

PBUILDER-DIST-SIMPLE(1) 				      General Commands Manual					   PBUILDER-DIST-SIMPLE(1)

NAME

       pbuilder-dist-simple - simple multi-release pbuilder wrapper

SYNOPSIS

       pbuilder-<dist> operation [...]

DESCRIPTION

       pbuilder-dist-simple  is  a  wrapper  that makes it easy to use pbuilder with chroots for many different Ubuntu distributions.  If you need
       more features than pbuilder-dist-simple provides, have a look at pbuilder-dist(1).

USAGE

       Create one symlink to pbuilder-dist-simple for each distribution for which you want a build environment, naming them like "pbuilder-lucid",
       "pbuilder-natty", etc.

       Replace operation with the action you want pbuilder-dist-simple to do (create, update, build, clean, login or execute).

EXAMPLES

       pbuilder-natty create
	      Creates a pbuilder environment for Ubuntu Natty.

       pbuilder-lucid update
	      Updates an existing Ubuntu Lucid environment.

       pbuilder-lucid build ./sample_1.0-0ubuntu1.dsc
	      Builds the specified package on an already existing Ubuntu Lucid environment.

FILES

       By default, pbuilder-dist-simple will store all the files it generates in ~/pbuilder/.  This can be changed by modifying the BASE_DIR value
       on the top of the script to any other directory you want.  If the directory doesn't exit, it will be created at runtime.

SEE ALSO

       pbuilder(1), pbuilderrc(5), pbuilder-dist(1)

AUTHORS

       pbuilder-dist was originally written by Jamin W. Collins <jcollins@asgardsrealm.net> and Jordan Mantha <mantha@ubuntu.com>, and	this  man-
       page by Siegfried-A. Gevatter <rainct@ubuntu.com>.

       Both are released under the GNU General Public License, version 2 or later.

ubuntu-dev-tools						 February 25, 2008					   PBUILDER-DIST-SIMPLE(1)