07-23-2015
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi in vi, i have a file and i wanted to replace all wnix to unix. is the below correct.
c/wnix/unix g...
i have tried , and the above is not right...
help? (7 Replies)
Discussion started by: yls177
7 Replies
2. Shell Programming and Scripting
Hi
My source database is seibel and the target is oracle. I need to check the count for source query and target query. if it is equal then i need to send and success mail to an email id. If it is not equal need to send an failure mail to an email id.
pl let me know about the script in ksh.
... (2 Replies)
Discussion started by: ksmbabu
2 Replies
3. Shell Programming and Scripting
I need to write a shell script to transfer the files every hour from source - target server.
The cron job should be running every hour and shouldn't copy already copied files to the remote server ?
I was able to write intial script but not able to get the logic for (in the next run it should... (12 Replies)
Discussion started by: radhirk
12 Replies
4. UNIX for Dummies Questions & Answers
Hi,
Please let me know how to find out number of files in a directory excluding existing files..The existing file format will be unknown..each time..
Thanks (3 Replies)
Discussion started by: ammu
3 Replies
5. Shell Programming and Scripting
Hi!
I just want to count number of files in a directory, and write to new text file, with number of files and their name
output should look like this,,
assume that below one is a new file created by script
Number of files in directory = 25
1. a.txt
2. abc.txt
3. asd.dat... (20 Replies)
Discussion started by: Akshay Hegde
20 Replies
6. Shell Programming and Scripting
Hi,
I am new to DB2 and in need of urgent help.
Here we have about 100 queries (SQL) that have been manually executed to retrieve totals from different tables
and post it to Excel spreadsheet. Is there any way I can create a shell script as a wrapper and execute
these queries and create a... (5 Replies)
Discussion started by: bhaskar v
5 Replies
7. Post Here to Contact Site Administrators and Moderators
Hi guys...please any one help me ....
how to copy files from source to target location
if 5 files copied successfully out of 10 files then implement success=10
and if remaining 5 files not copied successfully then count error=5
how to implement this condition with in loop
i need code linux... (0 Replies)
Discussion started by: sravanreddy
0 Replies
8. Shell Programming and Scripting
hi All, Any one answer my requirement.
I have source location
src_dir="/home/oracle/arun/IRMS-CM"
My Target location
dest_dir="/home/oracle/arun/LiveLink/IRMS-CM/$dc/$pc/$ct"
my source text files check with below example.text file content
$fn "\t" $dc "\t" $pc "\t" ... (3 Replies)
Discussion started by: sravanreddy
3 Replies
9. Shell Programming and Scripting
Hi Guys,
how to count number of files successfully copied while coping files from source to destination path
ex:10 files from source to target location copying
if 8 files copied successfully then
echo successfully copied=8
failure=2 files
if two files get error to coping files from... (23 Replies)
Discussion started by: sravanreddy
23 Replies
10. Shell Programming and Scripting
Dear Experts
my scenario is as follows...
I have one source folder "Source" and 2 target folders "Target_123456" & "Target_789101". I have 2 series of files. 123456 series and 789101 series. Each series has got 3 types of fiels "Debit", "Refund", "Claims".
All files are getting... (17 Replies)
Discussion started by: phani333
17 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)