Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Location
    Portland, OR
    Posts
    8

    Unanswered: How to copy one db to another with updates

    Does anyone know how, using Microsoft SQL server, that I could copy all the user tables from one database to another within the same instance of SQL server?

    Is it possible to copy with updates rather than just inserts?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    backup and restore with different name?
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2009
    Location
    Portland, OR
    Posts
    8
    yes, I understand how to restore.

    what I really want to do is copy newer data on top of a db with older data (with updates) . I suspect that what I want to do is impossible except by a stored procedure or DTS script?

  4. #4
    Join Date
    Aug 2008
    Location
    India
    Posts
    55
    U can use DTS export / Import wizard which will make your simple

Posting Permissions

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