Sponsored Content
Top Forums Shell Programming and Scripting Moving a database from one server to another Post 302436980 by Chimpie on Tuesday 13th of July 2010 03:11:37 PM
Old 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

Moving data from one database to other

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

Moving to new AIX server

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

moving apache from 1 server to another

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

moving to new server

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

Moving files from one server to another server every 5 min

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

Key Points when Moving from Server A to Server B??

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

Moving Oracle database

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

Problem with Perl script after moving from a Windows/Apache Server to a UNIX server.

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

Moving boot SSD from a dead server to a new server

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

Is it mandatory or not to stop/start Applcation server ehen Restarting Database Server?

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
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)
All times are GMT -4. The time now is 02:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy