Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JasonAnt
Starting Member
23 Posts |
 Posted - 2007-10-19 : 09:35:35
|
| I need database comparison tool, is there any freeware of it ?thank you |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
|
|
Kristen
Test
22859 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
JasonAnt
Starting Member
23 Posts |
Posted - 2007-10-19 : 22:16:17
|
| Thank you for replying, I have development and production database, I lost track what have been changed, table (field, datatype, size), sp, triggera tool will make my work easier |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-19 : 23:59:24
|
The tool I linked to should do.
Future guru in the making. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-20 : 03:09:08
|
| Won't help for your current scenario, but in terms of Best Practice for shipping updates from DEV to PRODUCTION this might be worth a read:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Script+Development+Database+Changes+to+Production+Database |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 17:07:33
|
| Sql2k5 comes with tablediff.exe. |
|
|
|
|
|
|
Ask: Freeware database compare tool
then the SProc by Viktor Gorodnichenko might do.