Link to home
Start Free TrialLog in
Avatar of florisb
florisb

asked on

Bacthmove data to database on other server

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
ASKER CERTIFIED SOLUTION
Avatar of ahoor
ahoor
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of florisb
florisb

ASKER

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

Thanks,
Floris.
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
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