Recording changes

Hi,
Is there any way i can map changes between databases at different time. Lets
say i have created a backup on 17 March 2004. I come back to the server on
17 April 2004 (a month later) and now i need to know what has changed betwee
n this two dates. Is there
any way i can compare a backup to the database to get the changes '
Thanks in advance,
Regards,
Hatim Ali.Hatim Ali,
Data changes or schema changes? Red Gate Software provides tools to
check both:
http://www.red-gate.com/sql/summary.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Hatim Ali wrote:
> Hi,
> Is there any way i can map changes between databases at different time. Lets say i
have created a backup on 17 March 2004. I come back to the server on 17 April 2004
(a month later) and now i need to know what has changed between this two dates. Is t
her
e any way i can compare a backup to the database to get the changes '
> Thanks in advance,
> Regards,
> Hatim Ali.|||Are you interested in structural/schema changes or the data changes or both?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Hatim Ali" <HatimAli@.discussions.microsoft.com> wrote in message
news:D4F700FB-37D0-4655-8CDA-AD4C6DFE45DC@.microsoft.com...
Hi,
Is there any way i can map changes between databases at different time. Lets
say i have created a backup on 17 March 2004. I come back to the server on
17 April 2004 (a month later) and now i need to know what has changed
between this two dates. Is there any way i can compare a backup to the
database to get the changes '
Thanks in advance,
Regards,
Hatim Ali.|||For the only true database change management software on the market for SQL
Server - DB Ghost is the solution. Everything else is too late - making the
change is not change management, knowing who made the change, when the chang
e was made and a history of
all the changes made are a fundamental requirement when it comes to change m
anagement. Nothing else out there can do this. DB Ghost makes this easy.
www.dbghost.com
true database change management for SQL Server
"Hatim Ali" wrote:

> Hi,
> Is there any way i can map changes between databases at different time. Lets say i
have created a backup on 17 March 2004. I come back to the server on 17 April 2004
(a month later) and now i need to know what has changed between this two dates. Is t
her
e any way i can compare a backup to the database to get the changes '
> Thanks in advance,
> Regards,
> Hatim Ali.|||I'm interested in data as well as structural changes. Is there any other app
roach rather than using a tool '
Regards,
Hatim Ali.
"Narayana Vyas Kondreddi" wrote:

> Are you interested in structural/schema changes or the data changes or bot
h?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Hatim Ali" <HatimAli@.discussions.microsoft.com> wrote in message
> news:D4F700FB-37D0-4655-8CDA-AD4C6DFE45DC@.microsoft.com...
> Hi,
> Is there any way i can map changes between databases at different time. Le
ts
> say i have created a backup on 17 March 2004. I come back to the server on
> 17 April 2004 (a month later) and now i need to know what has changed
> between this two dates. Is there any way i can compare a backup to the
> database to get the changes '
> Thanks in advance,
> Regards,
> Hatim Ali.
>
>