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 |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-09-01 : 09:39:34
|
| HiIs it possible to compare two databases on differant servers to check the diffrences in both the databasesI want to see what all new tables,columns that are created in the development environment that does not exist in the production environment.Our databases are sql server 2005 and Iam using sql server 2008 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-09-01 : 10:46:15
|
| 1. yes2. investigate www.red-gate.com they have a dbcompare utility...at a reasonable price or build your own tool |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-09-01 : 11:09:54
|
| If you can get them on the same server then I wrote this a while ago to compare tables / columns etc between one db and another.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136699Don't know if it will do everything you need though.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-09-01 : 11:16:37
|
| As there are less than 100 tables I can manually figure out which are the new tables thar are createdbut for the new columns I will try what i can do using your postThanksVamsi |
|
|
|
|
|
|
Database compare