Sybase data transfer tool

[former_member187136]

Hi,

Is there a tool available which allows me to select a table in Sybase, and have it copied to another Sybase database?

That means create the table when it does not exist, and insert all records from source to target.

I'm new to Sybase and have the SQL Server Import Wizard in mind, which lets me do just that.

BODS is used in the project which we can use to get data across but we have hundreds of little lookup tables with validated data which we need in the next DTAP environment. Building all these transfers individually will probably take ages.

[former_member187136]

Mark,

Even I didn't use the "sybmigrate" so I didnt suggest the tool to Opstal

My intention of asking for the bcp is that Opstal will take the table scheme from may be internal tool like ddlgen or any 3rd party tool

Thanks for bringing this point, as a point to add Mark is bcp in & out is just dealing with the "Table Data" this is nothing to do with the structures/schema

Am I right Mark

Regards

Kiran K Adharapuram

[former_member187136]

Hello Opstal,

There is a tool called bcp which you can use for copying the table and data to a flat file and pasting it in the destination

1 bcp out

2 bcp in

Further details you can get in from http://infocenter.sybase.com

Regards

Kiran K Adharapuram