SQL Server

Parent Previous Next

SQL Server


Tutorial Video


SQL Provider Requirements

  64-bit Operating Systems:

o   Microsoft ® SQL Server ® 2012 Shared Management Objects x64

o   Microsoft ® SQL Server ® 2012 Shared Management Objects x86

  32-bit Operating Systems:

o   Microsoft ® SQL Server ® 2012 Shared Management Objects x86


Best Practices

BI Compare

Documentation

Lineage

Data Dictionary


Getting Started

1.   After creating a solution, click the "Add" button on the right side of the page


       

2.   Give the solution item a meaningful name


3.   Select the SQL Server provider from the source type drop down


   


4.   Provide a valid server name and credentials


5.   You may also customize your documentation by adding filters


Important Note:

Excluding certain types may affect Lineage Analysis.



6.   Click "OK" to add the SQL Server to the Solution Items window


Sample Output

Doc xPress documents databases across all major versions of SQL Server: 2005, 2008, 2008 R2, and 2012.




Note:

Non-systemadmin users must be granted "View server state" permissions to view log file objects within documentation.