I would like to know how data refreshes are handled in other shops using Sybase.
We have requirements where production data is to be copied into development.
The number of tables and the no.of rows are very high, doing a bcp of all these tables seems to a long and time consuming process.
Backup and restore db into another database seems to be good option, but there are issues such as user accesses/permisssion etc to take care of .
Wondering what apporach/methodology does other shops follow for such.