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 |
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
 Posted - 2009-04-08 : 03:24:09
|
| Hi all,I have 2 versions of a database the first version is an older one.the second version is a new one.How to find what are things modified in version 2 after version 1?example: Includes extra tables, Includes extra stored procedures. Modified an exsting table or stored procedures..Is this possible.? Karthik |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-08 : 03:25:35
|
Yes. There are even tools for this.See SQL Compare here http://www.red-gate.com/
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-04-08 : 03:34:24
|
| Thanks.Karthik |
|
|
|
kunal.mehta
Yak Posting Veteran
83 Posts |
Posted - 2009-04-08 : 08:19:17
|
Hi,You can find information regarding db objects in sysobjects view of both databases.you can use in or not in query on these views to get the difference betweeen two of themKunal |
|
|
|
|
|
|
Difference .