We help IT Professionals succeed at work.

Bacthmove data to database on other server

florisb
florisb asked
on
Medium Priority
305 Views
Last Modified: 2008-02-01
Hi,

Isn there a free import/export data tool for Sybase that's easy to use to? I simply what to batchmove data from one database to another (On another server, I managed to import/export the database structure).

Thanks,
Floris
Comment
Watch Question

Commented:
If the tables and cloumns are the same on both servers you may use either bcp or remote procedures/proxy tables.

BCP is an easy to use bulkcopy program transporting the data into ascii files, with a given seperator. You can copy the data per table into a file, ftp the file to the other server and then bulkcopy it back in the tables.

Or you can make a connection between the 2 servers. For this both servers have to know each other in sysservers, remote logins must exist on the servers. You can then either use stored procedures which use both servers or create proxy tables on the remote server. Proxy tables exist from version 11.9.2 I think...

But I would suggest bcp (if both structures are equal)

Arjan

Commented:
Another option is SQSH, a freeware/shareware client that can pipeline data directly between two servers (like bcp out and in, but with no data file in between).

See http://www.isug.com/Sybase_FAQ/ASE/section9.html#9.6.1
I would suggest the BCPTOOL available from www.mbay.net/~mpeppler

It supports transfer across servers and has a GUI interface.

Thanks,
Amit.

Author

Commented:
I checked some links, but I'm looking for something that runs under the windows platform..

Thanks,
Floris.

Commented:
florishb,

ahoor has provide two good answers in bcp and a proxy database.  Another solution would be to get bcpxfer.  This is basically a c program that moves data in memory thus no data file.  Note:  It is not "offically" supported by Sybase.

knel

Commented:
Winquery or any toll which gives out text output is the best for such type of opertion.
Generate a sql state using sysobjects with any database.Since you said both are same.This sql statement can be run against any database

use input_database
go
select 'insert into server_name.input_database_name.' +name +'
'
+'select * from server_name.output_database_name.'+name from sysobjects

This sql statement will give statement for inseting data into the new database.Run this sql statement and you will have data in the need database.

Hope this solves your problem.
http://www.edbarlow.com/ has some reverse engineering scripts and even one to create bcp command for all tables in your database.

try the following link..(freeware)

http://www.edbarlow.com/document/procs/index.htm
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: ahoor

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

ChrisKing
EE Cleanup Volunteer

Explore More ContentExplore courses, solutions, and other research materials related to this topic.