October 20, 2005 at 6:40 am
I took backup of the database and restored in some other location say mirror database.
In the mirror database, I add some constraints by eliminating duplicates and foreign key constraints.
In the meantime some data would have been updated or inserted inside the original database.
How to identify the updated or inserted records without using triggeres. I am also not allowed to add timestamp column to the structure.
pls help me to solve this.
thanks in advance
regds
vanitha
October 20, 2005 at 7:14 am
Hi!!!!!!
there is possibilities of retriving data which are newly inserted in original database by comparing it with mirror database but it is hard to retrive data which are updated....
Regards,
Papillon
October 20, 2005 at 7:14 am
Hi!!!!!!
there is possibilities of retriving data which are newly inserted in original database by comparing it with mirror database but it is hard to retrive data which are updated....
Regards,
Papillon
October 20, 2005 at 7:21 am
yes i am able to retrieve inserted records...but i want to retrieve updated records.
October 20, 2005 at 7:27 am
Hi!!!!!
Can u tell me ur table structure....and which fileld updated recently......do u have any idea @ that...........
Regards,
Papillon
October 20, 2005 at 7:49 am
There are third-party tools that will do this for you. Here's a link to just one of them:
http://www.apexsql.com/sql_tools_diff.asp
And no, I do not work for this company!
Phil
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply