I have 2 databases:
1 from production and 1 from development.
None of the developers kept a changelog so i need to know what has changed (or what is different between the 2).
Any Ideas on how to do this?A quick method is to compare selects from sysobjects, syscolumns, and sysindexes.
blindman|||Then give the output of those queries to the developers so they can sift through them. Only proper, I would imagine.|||A quick, first run is to compare the date modified of the objects. Of course this does not compare contents. I've done it this way and it wasn't as bad as it sounds. Good luck.|||...and a quick way to identify modified procedure code is to compare checksum(syscolumns.text) between the two databases.
blindman|||if this is recurring task and if your department has a few dollars to spare (as we all have ...), you can use software for this, e.g. http://www.red-gate.com/sql/summary.htm|||SQLDiff by ApexSQL is a good tool too. There are some free database compare scripts at http://www.sqlservercentral.com/. Just look in their script section on the site.|||Another way - create db scripts (use DMO) and compare by FC.exe (included in W2000).
Showing posts with label diff. Show all posts
Showing posts with label diff. Show all posts
Sunday, March 11, 2012
Database Diff?
Are there any tools/utilties that can diff 2 sql server databases. I know the DB Pro Edition of VSTS can do it, but its hard to justify a jump from my $800 copy of VS2005 Pro to a $5k-6k version of VS just to get database diff. The tablediff looks promising but I need it to do SPROCS and SFUNCS too. Any helps or recommendations would be appreciated.
You might give Redgate SQL Compare a try.
http://www.red-gate.com/products/SQL_Compare/index.htm?gclid=CMCczdPZx4wCFQlQWAod_HLZaw
|||ApexSQL's Diff tool is also quite good and not very expensive. (www.ApexSQL.com)|||Thanks. They both look good!Database Diff?
I was just looking at my database backups and i noticed there was about a
100MB difference in the backup files. We run optimization plans but those
are done on the weekend and this happened in the middle of the week.
Some people are a little curious as to why the database backup would shrink
so much. I was thinking of trying to do a DB diff between the two but wasnt
sure how to do this. Looked around a little and saw a few tools but i was
looking for a free solution.
Anyone know why this might have shrunk or a tool that i could use to do a
diff?
Thanks
Justin
You could restore a backup before the change, and a backup after the change,
and then use a trial copy of red-gate SQL Compare (or trial versions of
other tools), I guess. Tools like this pay for themselves in the long run,
unless this is the only time you will ever use it (which you can't possibly
know right now).
Aaron Bertrand
SQL Server MVP
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>I was just looking at my database backups and i noticed there was about a
>100MB difference in the backup files. We run optimization plans but those
>are done on the weekend and this happened in the middle of the week.
> Some people are a little curious as to why the database backup would
> shrink so much. I was thinking of trying to do a DB diff between the two
> but wasnt sure how to do this. Looked around a little and saw a few tools
> but i was looking for a free solution.
> Anyone know why this might have shrunk or a tool that i could use to do a
> diff?
>
> Thanks
> Justin
>
|||You can start by checking all the table sizes ;)
Maybe somebody/changed to diffirential backup ?
Cheers,
Harry
|||Yeah you are right, i dont know if i'll need it again but a trial would be a
great start. I'll look in to that product.
Thanks
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23YHa4cSzHHA.4476@.TK2MSFTNGP06.phx.gbl...
> You could restore a backup before the change, and a backup after the
> change, and then use a trial copy of red-gate SQL Compare (or trial
> versions of other tools), I guess. Tools like this pay for themselves in
> the long run, unless this is the only time you will ever use it (which you
> can't possibly know right now).
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>
|||Yeah i guess i didnt really think about that. its really not too hard to run
a script to give some basic statistics about tables. More just a resource
problem but i have some spare servers i can run this on.
Thanks!
Justin
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:CABE43A2-BD14-4E93-89FA-D5D5C8E12393@.microsoft.com...
> You can start by checking all the table sizes ;)
> Maybe somebody/changed to diffirential backup ?
> Cheers,
> Harry
>
100MB difference in the backup files. We run optimization plans but those
are done on the weekend and this happened in the middle of the week.
Some people are a little curious as to why the database backup would shrink
so much. I was thinking of trying to do a DB diff between the two but wasnt
sure how to do this. Looked around a little and saw a few tools but i was
looking for a free solution.
Anyone know why this might have shrunk or a tool that i could use to do a
diff?
Thanks
Justin
You could restore a backup before the change, and a backup after the change,
and then use a trial copy of red-gate SQL Compare (or trial versions of
other tools), I guess. Tools like this pay for themselves in the long run,
unless this is the only time you will ever use it (which you can't possibly
know right now).
Aaron Bertrand
SQL Server MVP
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>I was just looking at my database backups and i noticed there was about a
>100MB difference in the backup files. We run optimization plans but those
>are done on the weekend and this happened in the middle of the week.
> Some people are a little curious as to why the database backup would
> shrink so much. I was thinking of trying to do a DB diff between the two
> but wasnt sure how to do this. Looked around a little and saw a few tools
> but i was looking for a free solution.
> Anyone know why this might have shrunk or a tool that i could use to do a
> diff?
>
> Thanks
> Justin
>
|||You can start by checking all the table sizes ;)
Maybe somebody/changed to diffirential backup ?
Cheers,
Harry
|||Yeah you are right, i dont know if i'll need it again but a trial would be a
great start. I'll look in to that product.
Thanks
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23YHa4cSzHHA.4476@.TK2MSFTNGP06.phx.gbl...
> You could restore a backup before the change, and a backup after the
> change, and then use a trial copy of red-gate SQL Compare (or trial
> versions of other tools), I guess. Tools like this pay for themselves in
> the long run, unless this is the only time you will ever use it (which you
> can't possibly know right now).
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>
|||Yeah i guess i didnt really think about that. its really not too hard to run
a script to give some basic statistics about tables. More just a resource
problem but i have some spare servers i can run this on.
Thanks!
Justin
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:CABE43A2-BD14-4E93-89FA-D5D5C8E12393@.microsoft.com...
> You can start by checking all the table sizes ;)
> Maybe somebody/changed to diffirential backup ?
> Cheers,
> Harry
>
Database Diff?
I was just looking at my database backups and i noticed there was about a
100MB difference in the backup files. We run optimization plans but those
are done on the weekend and this happened in the middle of the week.
Some people are a little curious as to why the database backup would shrink
so much. I was thinking of trying to do a DB diff between the two but wasnt
sure how to do this. Looked around a little and saw a few tools but i was
looking for a free solution.
Anyone know why this might have shrunk or a tool that i could use to do a
diff?
Thanks
JustinYou could restore a backup before the change, and a backup after the change,
and then use a trial copy of red-gate SQL Compare (or trial versions of
other tools), I guess. Tools like this pay for themselves in the long run,
unless this is the only time you will ever use it (which you can't possibly
know right now).
Aaron Bertrand
SQL Server MVP
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>I was just looking at my database backups and i noticed there was about a
>100MB difference in the backup files. We run optimization plans but those
>are done on the weekend and this happened in the middle of the week.
> Some people are a little curious as to why the database backup would
> shrink so much. I was thinking of trying to do a DB diff between the two
> but wasnt sure how to do this. Looked around a little and saw a few tools
> but i was looking for a free solution.
> Anyone know why this might have shrunk or a tool that i could use to do a
> diff?
>
> Thanks
> Justin
>|||You can start by checking all the table sizes ;)
Maybe somebody/changed to diffirential backup ?
Cheers,
Harry|||Yeah you are right, i dont know if i'll need it again but a trial would be a
great start. I'll look in to that product.
Thanks
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%23YHa4cSzHHA.4476@.TK2MSFTNGP06.phx.gbl...
> You could restore a backup before the change, and a backup after the
> change, and then use a trial copy of red-gate SQL Compare (or trial
> versions of other tools), I guess. Tools like this pay for themselves in
> the long run, unless this is the only time you will ever use it (which you
> can't possibly know right now).
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>|||Yeah i guess i didnt really think about that. its really not too hard to run
a script to give some basic statistics about tables. More just a resource
problem but i have some spare servers i can run this on.
Thanks!
Justin
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:CABE43A2-BD14-4E93-89FA-D5D5C8E12393@.microsoft.com...
> You can start by checking all the table sizes ;)
> Maybe somebody/changed to diffirential backup ?
> Cheers,
> Harry
>
100MB difference in the backup files. We run optimization plans but those
are done on the weekend and this happened in the middle of the week.
Some people are a little curious as to why the database backup would shrink
so much. I was thinking of trying to do a DB diff between the two but wasnt
sure how to do this. Looked around a little and saw a few tools but i was
looking for a free solution.
Anyone know why this might have shrunk or a tool that i could use to do a
diff?
Thanks
JustinYou could restore a backup before the change, and a backup after the change,
and then use a trial copy of red-gate SQL Compare (or trial versions of
other tools), I guess. Tools like this pay for themselves in the long run,
unless this is the only time you will ever use it (which you can't possibly
know right now).
Aaron Bertrand
SQL Server MVP
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>I was just looking at my database backups and i noticed there was about a
>100MB difference in the backup files. We run optimization plans but those
>are done on the weekend and this happened in the middle of the week.
> Some people are a little curious as to why the database backup would
> shrink so much. I was thinking of trying to do a DB diff between the two
> but wasnt sure how to do this. Looked around a little and saw a few tools
> but i was looking for a free solution.
> Anyone know why this might have shrunk or a tool that i could use to do a
> diff?
>
> Thanks
> Justin
>|||You can start by checking all the table sizes ;)
Maybe somebody/changed to diffirential backup ?
Cheers,
Harry|||Yeah you are right, i dont know if i'll need it again but a trial would be a
great start. I'll look in to that product.
Thanks
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%23YHa4cSzHHA.4476@.TK2MSFTNGP06.phx.gbl...
> You could restore a backup before the change, and a backup after the
> change, and then use a trial copy of red-gate SQL Compare (or trial
> versions of other tools), I guess. Tools like this pay for themselves in
> the long run, unless this is the only time you will ever use it (which you
> can't possibly know right now).
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>|||Yeah i guess i didnt really think about that. its really not too hard to run
a script to give some basic statistics about tables. More just a resource
problem but i have some spare servers i can run this on.
Thanks!
Justin
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:CABE43A2-BD14-4E93-89FA-D5D5C8E12393@.microsoft.com...
> You can start by checking all the table sizes ;)
> Maybe somebody/changed to diffirential backup ?
> Cheers,
> Harry
>
Database Diff?
I was just looking at my database backups and i noticed there was about a
100MB difference in the backup files. We run optimization plans but those
are done on the weekend and this happened in the middle of the week.
Some people are a little curious as to why the database backup would shrink
so much. I was thinking of trying to do a DB diff between the two but wasnt
sure how to do this. Looked around a little and saw a few tools but i was
looking for a free solution.
Anyone know why this might have shrunk or a tool that i could use to do a
diff?
Thanks
JustinYou could restore a backup before the change, and a backup after the change,
and then use a trial copy of red-gate SQL Compare (or trial versions of
other tools), I guess. Tools like this pay for themselves in the long run,
unless this is the only time you will ever use it (which you can't possibly
know right now).
--
Aaron Bertrand
SQL Server MVP
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>I was just looking at my database backups and i noticed there was about a
>100MB difference in the backup files. We run optimization plans but those
>are done on the weekend and this happened in the middle of the week.
> Some people are a little curious as to why the database backup would
> shrink so much. I was thinking of trying to do a DB diff between the two
> but wasnt sure how to do this. Looked around a little and saw a few tools
> but i was looking for a free solution.
> Anyone know why this might have shrunk or a tool that i could use to do a
> diff?
>
> Thanks
> Justin
>|||You can start by checking all the table sizes ;)
Maybe somebody/changed to diffirential backup ?
Cheers,
Harry|||Yeah you are right, i dont know if i'll need it again but a trial would be a
great start. I'll look in to that product.
Thanks
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23YHa4cSzHHA.4476@.TK2MSFTNGP06.phx.gbl...
> You could restore a backup before the change, and a backup after the
> change, and then use a trial copy of red-gate SQL Compare (or trial
> versions of other tools), I guess. Tools like this pay for themselves in
> the long run, unless this is the only time you will ever use it (which you
> can't possibly know right now).
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>>I was just looking at my database backups and i noticed there was about a
>>100MB difference in the backup files. We run optimization plans but those
>>are done on the weekend and this happened in the middle of the week.
>> Some people are a little curious as to why the database backup would
>> shrink so much. I was thinking of trying to do a DB diff between the two
>> but wasnt sure how to do this. Looked around a little and saw a few tools
>> but i was looking for a free solution.
>> Anyone know why this might have shrunk or a tool that i could use to do a
>> diff?
>>
>> Thanks
>> Justin
>|||Yeah i guess i didnt really think about that. its really not too hard to run
a script to give some basic statistics about tables. More just a resource
problem but i have some spare servers i can run this on.
Thanks!
Justin
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:CABE43A2-BD14-4E93-89FA-D5D5C8E12393@.microsoft.com...
> You can start by checking all the table sizes ;)
> Maybe somebody/changed to diffirential backup ?
> Cheers,
> Harry
>
100MB difference in the backup files. We run optimization plans but those
are done on the weekend and this happened in the middle of the week.
Some people are a little curious as to why the database backup would shrink
so much. I was thinking of trying to do a DB diff between the two but wasnt
sure how to do this. Looked around a little and saw a few tools but i was
looking for a free solution.
Anyone know why this might have shrunk or a tool that i could use to do a
diff?
Thanks
JustinYou could restore a backup before the change, and a backup after the change,
and then use a trial copy of red-gate SQL Compare (or trial versions of
other tools), I guess. Tools like this pay for themselves in the long run,
unless this is the only time you will ever use it (which you can't possibly
know right now).
--
Aaron Bertrand
SQL Server MVP
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>I was just looking at my database backups and i noticed there was about a
>100MB difference in the backup files. We run optimization plans but those
>are done on the weekend and this happened in the middle of the week.
> Some people are a little curious as to why the database backup would
> shrink so much. I was thinking of trying to do a DB diff between the two
> but wasnt sure how to do this. Looked around a little and saw a few tools
> but i was looking for a free solution.
> Anyone know why this might have shrunk or a tool that i could use to do a
> diff?
>
> Thanks
> Justin
>|||You can start by checking all the table sizes ;)
Maybe somebody/changed to diffirential backup ?
Cheers,
Harry|||Yeah you are right, i dont know if i'll need it again but a trial would be a
great start. I'll look in to that product.
Thanks
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23YHa4cSzHHA.4476@.TK2MSFTNGP06.phx.gbl...
> You could restore a backup before the change, and a backup after the
> change, and then use a trial copy of red-gate SQL Compare (or trial
> versions of other tools), I guess. Tools like this pay for themselves in
> the long run, unless this is the only time you will ever use it (which you
> can't possibly know right now).
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>>I was just looking at my database backups and i noticed there was about a
>>100MB difference in the backup files. We run optimization plans but those
>>are done on the weekend and this happened in the middle of the week.
>> Some people are a little curious as to why the database backup would
>> shrink so much. I was thinking of trying to do a DB diff between the two
>> but wasnt sure how to do this. Looked around a little and saw a few tools
>> but i was looking for a free solution.
>> Anyone know why this might have shrunk or a tool that i could use to do a
>> diff?
>>
>> Thanks
>> Justin
>|||Yeah i guess i didnt really think about that. its really not too hard to run
a script to give some basic statistics about tables. More just a resource
problem but i have some spare servers i can run this on.
Thanks!
Justin
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:CABE43A2-BD14-4E93-89FA-D5D5C8E12393@.microsoft.com...
> You can start by checking all the table sizes ;)
> Maybe somebody/changed to diffirential backup ?
> Cheers,
> Harry
>
Subscribe to:
Posts (Atom)