how to compare what has been changed between yesterday and today

Hello
1/ I am looking for ways to find out what has been changed per each table.
2/ Everyday I have a full database back up bak file created - about 10G.
(about 400 tables)
3/ Every day I will do a full restore of the day before yesterday database
and yesterday database.
e.g. Name of databases: DayBeforeYestDB,yesterdayDB
4/ Question:
Any tools to generate created another database that will contain only the
list of tables with data changed.
or
do I have to write my own scripts
Regards
it com
www.red-gate.com
SQL Data Compare...best $295 you will ever spend...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"itcom" <jensonluk1@.netscape.net> wrote in message
news:B5163A1E-880F-4437-AE2C-AFACA43949CD@.microsoft.com...
> Hello
> 1/ I am looking for ways to find out what has been changed per each table.
> 2/ Everyday I have a full database back up bak file created - about 10G.
> (about 400 tables)
> 3/ Every day I will do a full restore of the day before yesterday database
> and yesterday database.
> e.g. Name of databases: DayBeforeYestDB,yesterdayDB
> 4/ Question:
> Any tools to generate created another database that will contain only the
> list of tables with data changed.
> or
> do I have to write my own scripts
>
> Regards
> --
> it com
|||Hi,
What actually u need to know .If i understand ur Ques. u want that what
data chnages took place between last 2 backups.
Red-gate is good it will set a auditing option so will come to know
what datachanges and in which table.
Otherwise u can write ur on script.
U can restore both the database and compare the record count.
Or enable a C2 Auditing mode.
from
Doller

how to compare what has been changed between yesterday and today

Hello
1/ I am looking for ways to find out what has been changed per each table.
2/ Everyday I have a full database back up bak file created - about 10G.
(about 400 tables)
3/ Every day I will do a full restore of the day before yesterday database
and yesterday database.
e.g. Name of databases: DayBeforeYestDB,yesterdayDB
4/ Question:
Any tools to generate created another database that will contain only the
list of tables with data changed.
or
do I have to write my own scripts
Regards
it comwww.red-gate.com
SQL Data Compare...best $295 you will ever spend...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"itcom" <jensonluk1@.netscape.net> wrote in message
news:B5163A1E-880F-4437-AE2C-AFACA43949CD@.microsoft.com...
> Hello
> 1/ I am looking for ways to find out what has been changed per each table.
> 2/ Everyday I have a full database back up bak file created - about 10G.
> (about 400 tables)
> 3/ Every day I will do a full restore of the day before yesterday database
> and yesterday database.
> e.g. Name of databases: DayBeforeYestDB,yesterdayDB
> 4/ Question:
> Any tools to generate created another database that will contain only the
> list of tables with data changed.
> or
> do I have to write my own scripts
>
> Regards
> --
> it com|||Hi,
What actually u need to know .If i understand ur Ques. u want that what
data chnages took place between last 2 backups.
Red-gate is good it will set a auditing option so will come to know
what datachanges and in which table.
Otherwise u can write ur on script.
U can restore both the database and compare the record count.
Or enable a C2 Auditing mode.
from
Doller