Tuesday, September 13, 2011

How do get/put bulk data from/to a Sybase database in UNIX?


#get data
bcp <Database Name>..<Table Name> out /home/nayakr/out.csv -S<Server Name> -U<User Id> -P<Passowrd> -c

#put data
bcp <Database Name>..<Table Name> in /home/nayakr/in.csv -S<Server Name> -U<User Id> -P<Passowrd> -c

No comments :