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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would suggest the BCPTOOL available from www.mbay.net/~mpeppler
It supports transfer across servers and has a GUI interface.
Thanks,
Amit.
It supports transfer across servers and has a GUI interface.
Thanks,
Amit.
ASKER
I checked some links, but I'm looking for something that runs under the windows platform..
Thanks,
Floris.
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
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_databas e_name.'+n ame 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.
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
'
+'select * from server_name.output_databas
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
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
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
See http://www.isug.com/Sybase_FAQ/ASE/section9.html#9.6.1