Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Unanswered: Development server database refresh from production server

    Can we use BCP AND/OR BULK INSERT to do development server databse refresh from production server . I have to do this by following the rules below:

    - no truncation of source table
    - update of changed or new records only.

    I know we can use replication, dts and other methods for this but I need information about this one.


  2. #2
    Join Date
    Aug 2006
    San Francisco, CA
    Using BCP and/or Bulk insert to update a development server is possible, but would get complicated if you only want to update the changed records in the production server. If you want to only update the changed records you will need to somehow keep track of the records which changed in the production db, and this could lead to expanding your production db by adding extra columns or tables, which is probably not wanted. Overall I would not recommned this procedure.

    Something like log shipping in SQL 2000 might be a better solution.

    Good luck
    Hope this helped

Posting Permissions

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