 |
|
8000XXXX Errors Alerts ASP.NET 2.0 Classic ASP 1.0
Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO)Search
ASP FAQ Tutorials :: Databases :: General SQL Server & Access Articles :: How do I document / compare my SQL Server database(s)?
How do I document / compare my SQL Server database(s)?
ASP developers thrown into a project involving SQL Server will undoubtedly need to get up to speed very quickly on the database schema, structure, goals, etc. Unfortunately, not every company documents and maintains their databases in a way that makes sense to newcomers.
Here is an article by Viktor Gorodnichenko:
Compare SQL Server Databases with sp_Com...
Aside from that, there are several third party vendors, offering products of varying complexity. You may choke at the prices of some of these products, but remember that some of these tools are Enterprise-level and offer a *LOT* more than just documentation.
AdeptSQL Diff
AGS SQL Scribe
Apex SQLDiff
BMC SQL Programmer
Berryware SQL Matcher
CAST Release Builder
Cobb Systems Data Dictionary
DB Ghost
DBMaestro
Embarcadero DBArtisan
Enhanced ISQL/w
ERwin
Imceda Speed Change Manager
QALite
Quest SQL Impact
Red-Gate SQLCompare (with a companion article at MSSqlServer.com)
SQL Server Comparison Tool
SQL Total Compare
SynchroComp
Total SQL Analyzer
WinSQL
xSQL Object
Yes, you could document these things yourself using SQL Scripts, Database Diagrams, and what have you. But some of these tools are downright cool, have tons of additional functionality, and for a few dollars, will save you from reinventing the wheel.
Here is an article by Viktor Gorodnichenko:
Compare SQL Server Databases with sp_Com...
Aside from that, there are several third party vendors, offering products of varying complexity. You may choke at the prices of some of these products, but remember that some of these tools are Enterprise-level and offer a *LOT* more than just documentation.
AdeptSQL Diff
AGS SQL Scribe
Apex SQLDiff
BMC SQL Programmer
Berryware SQL Matcher
CAST Release Builder
Cobb Systems Data Dictionary
DB Ghost
DBMaestro
Embarcadero DBArtisan
Enhanced ISQL/w
ERwin
Imceda Speed Change Manager
QALite
Quest SQL Impact
Red-Gate SQLCompare (with a companion article at MSSqlServer.com)
SQL Server Comparison Tool
SQL Total Compare
SynchroComp
Total SQL Analyzer
WinSQL
xSQL Object
Yes, you could document these things yourself using SQL Scripts, Database Diagrams, and what have you. But some of these tools are downright cool, have tons of additional functionality, and for a few dollars, will save you from reinventing the wheel.
Related Articles
Can I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all? Could I get some help with JOINs? How can I tell which version of MDAC I'm running? How do I access MIN, MAX, SUM, COUNT values from SQL statements? How do I change column order in a table structure? How do I change the order of columns in a table? How do I concatenate strings from a column into a single row? How do I convert columns of values into a single list? How do I determine if a database exists? How do I get the IDENTITY / AUTONUMBER value for the row I inserted? How do I solve 'ADO Could Not Find The Specified Provider'? Should I use BETWEEN in my database queries? Why can't I use the * wildcard in a database search? Why do I get 'Syntax Error in INSERT INTO Statement' with Access? Why do I get weird results when using both AND and OR in a query? Why do some SQL strings have an 'N' prefix? Why does AbsolutePosition return as -1? Why doesn't SQL Server allow me to separate DATE and TIME? Why is Query Analyzer only returning 255 characters? Why should I avoid NULLs in my database? How do I deal with an apostrophe (') in a SQL statement?