| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2005-04-26 : 16:20:12
|
Is it a life saver for multiple databases like prod, dev, etc...Cause there are times where I totally forget about a few changes with some sprocs.I saw the ad on the top and wanted to know if anyone uses it.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-26 : 17:07:37
|
| I used it last summer and it was pretty good. Our company didn't want to pay for it so once the trial expired we stopped using it. Our final solution was to get a better handle on source control and a better deployment process. We've been in synch really well since we implemented those changes.Mike"oh, that monkey is going to pay" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-04-27 : 13:38:20
|
| If a Developer here made a direct change to the DB's DDL, and didn't script it, there would be a public execution. That seems to solve the problem here!Kristen |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-04-27 : 13:39:45
|
Cricket Cricket...
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-04-27 : 14:12:57
|
| More correctly: definitely "Not Cricket" <g> |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-04-27 : 14:43:13
|
| I use SQL Compare. I need to pay for the upgrade to the new "fast" version. I've been using it for about a year or two now. I LOVE it!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-04-27 : 15:05:40
|
Will try to get the company to purchase it thanks for the feedback.Hey Mike can I ask how in depth it compares, does it compare just based on overall objector the contents of that object, i.e, the difference between two scripts.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-04-27 : 15:21:49
|
| It allows you to select which things you want to compare, then it generates the scripts for those objects and does a line-by-line compare of the scripts. It's a little smarter than that, but that's the basics. It's really good at finding any little difference.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-04-27 : 15:49:16
|
Good thanks!Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-04-28 : 05:14:43
|
| Jon, if its a one-off (or infrequent) could you just Generate SQL both databases and use a text compare?Used to be that SQL would be inclinded to output the objects in different orders, for different database (e.g. the order they were created!!) , which certainly mucked up this approach - but that was back in Version 6.5 days, it may have changed.FWIW I would not want to use a DDL Compare tool as a means of releasing changes, but I CAN see the merits in checking that two are the same, and sorting out the mess if they are found not-to-be.Kristen |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-28 : 07:56:18
|
| I agree with Kristen on this. It's a great tool, but NOT a replacement for proper source control.Case in point: before we enforced a proper release control system, we used Red Gate to script out differences between development and production. One time we left the "script foreign keys" selection unchecked. This led to several hundred foreign key constraints being dropped from production, with no way to discover exactly what was lost.Beware of tools that make tasks too easy, because they make mistakes too easy as well. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-28 : 11:29:43
|
| The Red Gate tool is pretty good. I wouldn't rely on it for change control, but if you want to know the differences between two structures then it's great. It can be as detailed or as lax as you set it.-------Moo. :) |
|
|
|
golum1
Starting Member
2 Posts |
Posted - 2006-03-17 : 13:35:20
|
| a full year too late on this topic but if you want to just compare data then try firefly:http://www.getfirefly.net/ |
|
|
|
wendybo
Starting Member
1 Post |
Posted - 2006-03-27 : 04:36:16
|
| SqlRaptor is constituted of two tools: a documentation tool and a compare tool.SqlRaptor lets developers store comparisons into their database ( or on disk files) to ensure the integrity of team development efforts.The documentation tool produces CHM, HTML and RTF output.Essentially, the documentation tool uses SQL-DMO calls and ad-hoc queries to reverse engineer your database, and then places all of the documentation in a HTML Help-formatted file, or in a RTF file.If you want to add a comment to a column you can call an editor window directly from the HTML help file, this window connects to database and insert the comment in the right table (sysproperties).With SqlRaptor you have two utilities in one product.www.miqui.it |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-03-29 : 11:09:10
|
Spamming a 3 year old topic?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Itamar
Starting Member
19 Posts |
Posted - 2009-03-29 : 12:56:39
|
quote:
Originally posted by Peso
Spamming a 3 year old topic?
E 12°55'05.63"N 56°04'39.26"
 Sorry, I didn't see the date. Deleted.Nob Hill Software - Tools for Database PeopleSQL Version Control, Database Compare, Query Tools and more. www.nobhillsoft.com |
|
|
|
|
SQL Compare