SQL Server Dataflows & Extra Analysis

The Sirkel Dataflows & Extra Analysis module provides powerful insights into your SQL Server database structure and data relationships.

It enables you to visualize table relationships using Sankey diagrams and perform deeper analysis on table content, size, and usage.

What does SQL Server Dataflows do

The Dataflows feature creates a Sankey diagram based on selected tables and their relationships.

This visualization is built using foreign key relationships and helps you understand how data flows between tables.

How to Use Dataflows
  1. Select one or more tables from the list
  2. Adjust the order if needed
  3. Click Dataflows to generate the diagram
  4. Analyze relationships visually

This helps identify dependencies, structure, and potential optimization areas.

Sirkel Form Flowchart
Dataflows Toolbar Overview
Action / optionMeaningResult
SirkelData Data Flow Select AllAll possibilities - tick tables in the list.SirkelData - Search Replace Data - Tables
SirkelData Data Flow ClearNo options - check tables in the list.SirkelData Search and Replace Data Remove All in List
SirkelData Data Flow FindFind table in the list.  
SirkelData Flow OrderThe chosen order of the tables. 
Sirkel Toolbar FlowchartThe diagram is created with the selected tables and order.SirkelData Flow Sankey
SirkelData Flow Overlapping  
SirkelData Flow Alignment  
SirkelData Data Flow Palettes  
SirkelData Data Flow Print PreviewYou can print the table from this screen. 
SirkelData Data Flow ExportYou can export the database description to various formats: PDF XLS XLSX RTF CSV DOCX TXT HTML MHT 
SirkelData Data Flow CloseExiting the Flow screen. 

Extra Analysis Features

The Extra Analysis module provides detailed insights into your database content.

Tab 1: Size Fields and Contents

Provides an overview per table, including:

  • Number of records
  • Field details
  • Data size and content length
Sirkel Extra Analysis and Options
Tab 2: Tables Info

Gives additional insights such as:

  • Table structure
  • Field usage
  • Space consumption
Sirkel Extra Analysis Tables Info
Extra Analyses Toolbar
Option - ActionMeaning
Sirkel Toolbar Print PreviewPrint preview of the content from the grid.
Sirkel Applications Toolbar FindPanelThe grid can display a find panel that enables users to search for keywords in visible columns.
Sirkel Toolbar Show Captiondisplay header
Sirkel Toolbar Show Group PanelSets a value indicating whether the group panel is visible.
Sirkel Toolbar Show IndicatorSets a value that indicates whether the driving indicator panel is displayed.
Sirkel Toolbar Show PreviewSets a value that indicates whether preview sections are displayed.
Sirkel Application Toolbar Export RibbonYou can export the grid to various formats: PDF, XLS, XLSX, RTF, CSV, DOCX, TXT, HTML, MHT
Sirkel Toolbar CloseClosing the window.
Why Use Dataflows & Extra Analysis
  • Visualize complex table relationships
  • Understand data flow between tables
  • Analyze database size and usage
  • Identify optimization opportunities
  • Export insights for reporting
Next Steps

After analyzing your database, you can: