Results 1 to 3 of 3

Thread: Data Refresh

  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: Data Refresh

    Folks,

    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.

    Please share your exepriences..?

  2. #2
    Join Date
    Jun 2003
    Posts
    140
    May be its a time to remember Replication Server !

  3. #3
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    If you are on ASE 12.5.1 you can use ASE Replicator, too.
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •