ApexSQL Doc!

SQL script http://solutioncenter.apexsql.com/create-a-database-script-from-a-backup-without-restoring-it
| | Direct execution against database (synchronization | | Proprietary schema snapshot http://blog.apexsql.com/apexsql-diff-exporting-sql-data-sources
| | Database installer package (e.g. Executable installer, C# solution http://knowledgebase.apexsql.com/all-about-apexsql-database-installer-packages
| | Source control project or label (synchronization http://knowledgebase.apexsql.com/configure-apexsql-diff-to-work-with-source-control-data-sources
| | **Integration** SQL Server Management Studio (SSMS http://solutioncenter.apexsql.com/how-to-compare-sql-databases-in-ssms
| | **Reports and exports**

ApexSQL Doc alternatives

  • dbForge Documenter for SQL Server

  • Explore and Generate Documentation of SQL Server Databases Automatically with dbForge Documenter for SQL Server.

    tags: database-document database-documentation database-documentation-tool documentation how-to-document-a-database
  • Dataedo

  • Documenting SQL Server, Oracle and MySQL databases made easy. Just import schema, describe anything and export to PDF, HTML or Excel.

    tags: concurrent-work data-dictionary data-modeling database database-documentation
  • SQL Doc by Red Gate

  • Document your databases automatically.

    tags: database-applications database-documentation database-management
  • SQL Data Dictionary

  • Easily generate a PDF or HTML data dictionary from SQL Server with just a few clicks.

    tags: database sql-server database-documentation data-dictionary
  • Database Note Taker

  • Free alternative to paid database documentation tools, Database Note Taker makes it easy for developers to capture and share knowledge about databases, simplify database documentation processes, and take the guess work out of every day development with databases. So much information about your databases is in code or your developer's heads. Now it's easy to record that somewhere. Being this simple, documentation will actually get done!

    tags: database database-management sql-server database-applications database-development
  • DOC xPress

  • DOC xPress produces complete documentation for SQL Server instances. In addition, it enables documentation for Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS). Snapshots of the environment can be captured with a few clicks, making it easy to capture what an environment looks like before making changes. Documentation can be produced from any daily snapshot, allowing users to see what the environment looked like in the past. The snapshot and the documentation processes can be scheduled using the command line, allowing integration with popular scheduling utilities. The documentation can be produced in HTML, HTML with frame navigation, RTF, or Word (docx) formats. The contents of the documentation can be customized, both for what is included in the output, as well as the templates to use for each type of object. Speed up your documentation efforts with DOC xPress! ยป

    tags: sql ssis ssrs
  • SSIS Documenter

  • SSIS Documenter integrates into the SQL Server 2005 Business Intelligence Studio. Once you have installed SSIS Documenter you will see a "Generate Documentation" menu item availabel for all SSIS packages. Generated documentation is created under the same solution, and can be deployed to the web server.

    tags: ssis