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 |
|
mpalam
Starting Member
4 Posts |
 Posted - 2006-11-15 : 05:19:32
|
| HiI have just started working on SQL Server. But I need to provide a generic script/program - that does a DB sanity check of the customer's DB with our internal master-list. This script should: (a) Check that all DB objects are present (tables/views/Stored Procedures/constraints/Primary Keys/indexes) in the appropriate file-groups/etc. If not create them (b) Log out a report of all DB objects that are there in customer DB - which should not be there as per ours. Customers can drop these separately later Please provide me with a such a script where I can compare two DB's. The result being full detail and description about the underlying objects. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-15 : 05:32:42
|
| There are lots of these tools out there. Have you googled them?Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-11-15 : 05:38:06
|
| Oooh, homework!Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
comparing DB through SQL script for a beginner