07-18-2013
Every database engine has a command line tool, but if it is not free on the host you want to use it on, you can get free JDBC jars and use xigole jisql or the like to access the data, and then a shell can examine it. Of course, you need to know the host, port, id, pw, database name, etc. to log in on any tool, and have network access, and not violate corporate standards.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello
say i have written some perl scripts , now i like to call them in my unix shell
as unix command like "more" , "ls" , "grep" so that my say perl script called "foo.pl"
will be called from every where as "foo" or "foo arg1 arg2"?
Thanks (1 Reply)
Discussion started by: umen
1 Replies
2. Shell Programming and Scripting
Hi
I am not sure how to call a perl script from a tcsh shell. do i need to set any environment variables? your help is appreciated
Thanks (1 Reply)
Discussion started by: megastar
1 Replies
3. UNIX for Dummies Questions & Answers
hi,
i want to call unix script from transformations used in informatica mapping?
can we do it in any way? Please reply ASAP.
We cant use Storep procedure transformation
Thanks in Advance
nishith (0 Replies)
Discussion started by: Nishithinfy
0 Replies
4. Shell Programming and Scripting
hi,,
i have perl scipt with line :
system('./try.sh $t $d $m');
in shell scipt try.sh i have the line:
echo $1
its not printing value of $t that i hav passed..y is it so..i am running it from apache web server (2 Replies)
Discussion started by: raksha.s
2 Replies
5. Shell Programming and Scripting
I am working on this script, but hit a bump. Looking for a little help figuring out the last part:
open(MY_FILE, $ARGV) or die
$COUNTER = 1;
$LINE = <FILE>;
while ($LINE, <FILE>) {
# Adds leading zeros for numbers 1 digit long
if ($COUNTER<10){
print "000";
}
# Adds... (2 Replies)
Discussion started by: Breakology
2 Replies
6. Shell Programming and Scripting
Hi
I m new to perl. I m trying to write a perl script that calls a bash script; does anyone have a script already that they can provide or help me out? Thanks a lot. (2 Replies)
Discussion started by: adnan786
2 Replies
7. Shell Programming and Scripting
Hi Rockers,
I hope u r dng good one. I have a one question is in unix with informatica . I need a unix script to check whether particular file exists in the folder , If it means we have a informatica server , so we can start the informatica server by accessing that file. Every week we have... (0 Replies)
Discussion started by: gurukrishnan
0 Replies
8. Shell Programming and Scripting
Hello Gurus
Can anyone please let me know how to call .profle file in perl script
When I am calling the .profile file its giving error
Shall I create unix script which has .profile command and call perl script internally (2 Replies)
Discussion started by: Pratik4891
2 Replies
9. Shell Programming and Scripting
I'm attempting to write a bash script that will create a network between virtual machines. It accepts three arguments: an RSpec that describes the network topology, and two list of machines (servers and clients).
I have a (working) Perl script that I want to call. This Perl script takes an RSpec... (6 Replies)
Discussion started by: mecaka
6 Replies
10. Shell Programming and Scripting
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
LEARN ABOUT DEBIAN
datacopy
datacopy(1) FreeTDS Utilities datacopy(1)
NAME
datacopy - move table data between two servers
SYNOPSIS
datacopy { -t | -a | -c owner } [-b batchsize] [-p packetsize] [-v] [-d]
[-S server/username/password/database/table_or_view]
[-D server/username/password/database/table]
DESCRIPTION
datacopy is a utility distributed with FreeTDS. datacopy will move table data from one server to another without the need for intermediate
files. datacopy is much faster and more efficient than is freebcp out/in.
datacopy makes use of the db-lib bcp API built into FreeTDS. This API is also available to application developers.
datacopy can be used to migrate data between Sybase ASE and SQL Server or vice versa.
OPTIONS
-t Truncate target table before loading data.
-a Append data to target table.
-c owner
Create the target table with the same schema as the source table. datacopy will submit a 'create table' command on the target
server/database using the specified owner in
the command, e.g. CREATE TABLE owner.table (...).
-b batchsize
The number of rows per batch of data copied. Each batch of data is effectively 'committed' to the database. The default is 1000.
-p packetsize
The number of bytes, per network packet, sent to and from the servers. Increased packet size can enhance performance.
-v Produce verbose output, including diagnostic timings.
-d Produce freetds TDSDUMP output. (Serious debug only!)
-S server/username/password/database/table_or_view
The connection information for the source server and the location/name of the table (or view) to be copied. If not specified, data-
copy will prompt the user for the information.
-D server/username/password/database/table
The connection information for the destination server and the location/name of the target table. If not specified, datacopy will
prompt the user for the information.
SEE ALSO
freebcp(1), defncopy(1), bsqldb(1), tsql(1), FreeTDS User Guide.
HISTORY
datacopy first appeared in FreeTDS 0.64.
AUTHORS
The datacopy utility was written by Bill Thompson (thompbil@exchange.uk.ml.com).
doc 13 November 2011 datacopy(1)