Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Script the difference between two database having same structure but different data

    Hi,
    I want to find out the Script for the difference between two database having same structure but different data.
    The problem is SQL server does the differential data backup only on the database last backed up, but if i want to find out the difference between the data in two databases and update the old database with the values of the latest database, it doesn't allow to do so.
    Is there any other way of doing this task.

    Thanks
    Amu

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I know few of the third party tools can offer this functionality that would cater your needs, may refer to this link for more information.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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