Problem: Run schedular to copy from one table to other

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run the Script from any stage by updating data from Oracle Table.

I have 100 Scripts, each containing 10-15 SQL's in them. Each Script run for 40 mins to 1 hour 30 mins. In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the...

2. High Performance Computing

Job Schedular for Suse Enterprise SLES 11 SP2

We have a server with 160 hyper-threaded cpu's threads and 2Tb of RAM. I need to implement command line job queue and parallel thread usage for multiple user environment kindly suggest necessary tools to be installed. I have understanding that sun grid engine like applications are available for...

3. Shell Programming and Scripting

Copy and run that script in Remote server

Hi All, I need script to perform below task. 1. I have a script in one server and need to copy this script to remote server 2. login in to remote server 3. run the script which i copied to this server. #!/bin/bash read a scp /tmp/script.sh user@hostname:/tmp ssh user@$a ./scirpt.sh ...

4. UNIX for Dummies Questions & Answers

Unix Shell Script on Tidal schedular for ETL

Hello I am very new to Unix scripting, I am using informatica etl,which is schedule by tidal enterprise. I have a scenario where assume that Tidal only knows how to run jobs at a given time and does not know how to retry. So i want to know weather can i write a shell script such that...

5. UNIX for Dummies Questions & Answers

What is in-core copy and disk-copy of i-node table?

I have found a question from the exercises of my study mat. The question is "Why are there a in-core copy and a disk-copy of i-node block and super block?" If any one know the proper answer then please send me.....

6. Red Hat

mounting a copy of a disk without patition table

Ok. I screwed up. Using dd, I made a bit-for-bit copy of disk /dev/hda, which contains 3 partitions. dd if=/dev/hda of=olddrive.iso bs=2048k However, I neglected to make a copy of the partition table. I'd like to mount partition 3, /dev/hda3, which is an xfs filesystem, but obviously I don't...

7. UNIX for Advanced & Expert Users

Schedular

Hi, I was looking for a schedular(a simple script would do or a tool) that would invoke jobs on few conditions: 1. Every day 2. Every working day(Considering customized holiday list, from a file or table) 3. Weekly 4. being able to define variable dependency. like on every day run,...

8. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal.

9. UNIX for Dummies Questions & Answers

how to run cron job to truncate database table

hi i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database i have a main database - db1 and i have a table in that database - userips i wish to create a cron job that truncates or removes all the info...

10. Shell Programming and Scripting

Creating a Schedular to Run the Jobs.

Hi, I have to create a sheduler to run the shell scripts one by one(dependency). Suppose i have 10 scripts. For all the 10 scripts i have a database table containing these scripts_names and status. Executing the first script.if the first status script is only 'success' then go to next...

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)

UNIX for Dummies Questions & Answers