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 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.
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 ther
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 change was made and a history of
all the changes made are a fundamental requirement when it comes to change management. 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 ther
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 approach rather than using a tool ?
Regards,
Hatim Ali.
"Narayana Vyas Kondreddi" wrote:

> 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.
>
>