07-13-2010
thanks for noticing the '
It's sending the information now. I'll let you know and the rest of the readers know what happens.
Since I'm learning, what is scp?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear All,
I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files.... (6 Replies)
Discussion started by: lloydnwo
6 Replies
2. AIX
Hello everybody,
I am going to move to new AIX server and the question is how to correctly and painless move the whole configuration? I mean for example users, network, and - what is very important - the whole printer system configuration? I think users are simple to move - only /etc/passwd and... (1 Reply)
Discussion started by: Yac
1 Replies
3. UNIX for Dummies Questions & Answers
i need to move apache 2.2 from one server over to another server..... my servers are in atlanta and i'm logged in here in florida... what commands do i use ???? somebody mentioned the fetch command... please help.... i'm an idiot when it comes to unix (2 Replies)
Discussion started by: marinob007
2 Replies
4. AIX
I'm moving an application from an old RS6000 running 4.3.2 to a p5 running 5.3.
Could someone point me a the direction on docs to perform such a function? Critical OS files, moving of printers and print queues especially.
thanks (5 Replies)
Discussion started by: sullivjp
5 Replies
5. Shell Programming and Scripting
HI All,
I am trying to automate my stuff to make 'to-do-easier'.
I am new to shell scripting. I need help to you regarding the below problem.
I have one directory in my server, frequently files will store in that directory. I want to move that files into another server on every 5... (5 Replies)
Discussion started by: ravvamohan
5 Replies
6. Solaris
Hi Everyone,
I'm still learning daily about UNIX (specifically Solaris 10).
I'm tasked with moving my current application and database from Datacenter A to Datacenter B.
There will be no updates and no changes other than a new server and new location.
So far, I have Solaris... (3 Replies)
Discussion started by: smckech1972
3 Replies
7. UNIX and Linux Applications
how does one move Oracle database to new OS? Does Oracle need to be the same version as old one? (6 Replies)
Discussion started by: orange47
6 Replies
8. Programming
I have a Perl script that worked fine before moving it to justhost.com. It was on a Windows/Apache server. Just host is using UNIX. Other Perl scripts on other sites that were also moved work fine so I know Perl is functioning.
The script is called cwrmail.pl and is located in my cgi-bin.
When I... (9 Replies)
Discussion started by: BigBobbyB
9 Replies
9. Red Hat
Hi all,
We have a disk array that has the boot drive on an OCZ SSD on a PCIe card. Well, the motherboard died and we got a new motherboard. We moved the controllers, NICs, etc, to the exact same slots on the new motherboard, except now it won't boot. I guess it doesn't recognize the OS on the... (1 Reply)
Discussion started by: glowe57
1 Replies
10. UNIX and Linux Applications
Good afternoon
I need your help please.
There is a Mantenance Windos which needs to Restart de Database Server 192.x.x.97 to set up some configuration
Is it mandatory or not to stop/start Applcation server that runs in 192.x.x.95 ?
Is it mandatory or not to stop/start apache and Tomcat?... (3 Replies)
Discussion started by: alexcol
3 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)