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 |
|
zion99
Posting Yak Master
141 Posts |
 Posted - 2009-02-04 : 01:46:02
|
| Hi All,I use database objects solution from Visual studio 2005 to store all my tables, stored procs, functions etc. each table, sp, function is stored in a separate file. Due to this it becomes very difficult to identify what was changed and which modified scripts should be deployed in production from uat.Is there a way that helps me identify what all things were changed and automatically a script is created only for such modified objects? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 09:30:22
|
| You should be incorporating with source control like visual sourcesafe. |
 |
|
|
latiful
Starting Member
10 Posts |
Posted - 2009-02-04 : 19:32:43
|
| Use SQL Compare from RedGate, it's a really very good tool. |
|
|
|
|
|
|
best practices - identifying changed tables & SP