quote:

---

Originally posted by nr

There is no way to do this.
You can restore the backup to another database then copy the data from it if you have some way of knkowing what has been added.

Otherwise you can use things like replication or transaction log backups but if you only have a full backup then you are a bit stuck.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

UPDATE D
SET Column1 = S.Column1,
    Column2 = S.Column2,
    ...
FROM DestinationDatabase.dbo.MyTable AS D
     JOIN SourceDatabase.dbo.MyTable AS S
         ON S.MyPKColumn = D.MyPKColumn
WHERE     (S.Column1 <> D.Column1 
              OR (S.Column1 IS NULL AND D.Column1 IS NOT NULL)
              OR (S.Column1 IS NOT NULL AND D.Column1 IS NULL) )
      AND (S.Column2 <> D.Column2
              OR (S.Column2 IS NULL AND D.Column2 IS NOT NULL)
              OR (S.Column2 IS NOT NULL AND D.Column2 IS NULL) )
     ...

INSERT INTO DestinationDatabase.dbo.MyTable
(
    Column1, Column2, ...
)
SELECT S.Column1, S.Column2, ...
FROM SourceDatabase.dbo.MyTable AS S
WHERE NOT EXISTS
      (
          SELECT *
          FROM   DestinationDatabase.dbo.MyTable AS D
          WHERE  D.MyPKColumn = S.MyPKColumn
      )