Speedtest (5/22/2014)
Hi , Im trying to validate if the db schema of about 3000 fields spread in about 15 tables matches the data dictionary(in excel) and also to keep a watch on it incase someone changes a column name or adds new column, i need to be alerted an hence would like to know if there is any easy way to validate it.Thanks for all the help
Why do you have the data dictionary in Excel? You already have it defined exactly as sql server has it, right there in sql server. Trying to keep an external file up to date is going to be nearly impossible.
You might to take a look at DDL triggers. http://msdn.microsoft.com/en-us/library/ms175941.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/