Copying tables between two databases

[chiverj]

Greetings, I want to copy a table from database on a production server to a database with the same name on a test server, how might I go about this?

We are running Sybase ASE 11.9.2 on Solaris

 

[markmar1]

Well, you can bcp out of one table, to the other table if you have both created.

Or on Sybase side, they have a C program(bcpxfer) you can compile that will allow you use select statement and use bcp libraries to copy data between servers, etc. It would eliminate the need to go to a flat file....

But if its quick and dirty need, bcp would probably be easiest.