Analyze Several SQL Server Databases at the Same Time

If your Transact-SQL code is distributed among several databases, you may need to include these databases in the same code analysis. 

For instance, your code may include dependencies across two databases (i.e. an object in database 1 is referencing an object in database 2). 
A multi-database analysis will properly take these cross-database references into account.

To analyze several databases together, create a new Visual Expert project with SQL Server code, select “database” to locate your code, and select the databases to analyze as indicated below:

analyze multiple sql server databases


 

 

 

 

Code Analysis, SQL Server