Document Details

Tutorial Incremental Copy Multiple Tables Portal
Home / Scan #41 / Tutorial Incremental Copy Multiple Tables Portal
Sad Tux - Windows bias detected
This page contains Windows bias

About This Page

This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
GitHub View on GitHub 📚 View on Microsoft Learn

Bias Analysis

Detected Bias Types
windows_first
missing_linux_example
windows_tools
Summary
The documentation demonstrates a Windows bias by exclusively referencing Windows tools (SQL Server Management Studio), assuming SQL Server as the on-premises source, and omitting any Linux-based alternatives or instructions. There are no examples or guidance for users running SQL Server on Linux, nor for using cross-platform tools (such as Azure Data Studio or sqlcmd). All setup and verification steps are described using Windows-centric workflows and terminology.
Recommendations
  • Include instructions and examples for users running SQL Server on Linux, such as connecting via Azure Data Studio or sqlcmd.
  • Mention and provide steps for using cross-platform tools (Azure Data Studio, sqlcmd) alongside SQL Server Management Studio.
  • Clarify that SQL Server can run on both Windows and Linux, and provide any necessary Linux-specific prerequisites or commands (e.g., installation, firewall, service management).
  • When referencing file paths, authentication, or environment setup, include Linux equivalents or note any differences.
  • Add a section or callout for Linux users, highlighting any platform-specific considerations for self-hosted integration runtime installation and connectivity.
GitHub Create Pull Request

Scan History

Date Scan Status Result
2025-07-12 23:44 #41 cancelled Biased Biased
2025-07-12 00:58 #8 cancelled Clean Clean
2025-07-10 05:06 #7 processing Clean Clean

Flagged Code Snippets

    
        :::image type="content" source="./media/tutorial-incremental-copy-multiple-tables-portal/second-lookup-settings.png" alt-text="Second Lookup Activity - settings":::
1. Drag-drop the **Copy** activity from the **Activities** toolbox, and enter **IncrementalCopyActivity** for **Name**. 

1. Connect **Lookup** activities to the **Copy** activity one by one. To connect, start dragging at the **green** box attached to the **Lookup** activity and drop it on the **Copy** activity. Release the mouse button when the border color of the Copy activity changes to **blue**.

    :::image type="content" source="./media/tutorial-incremental-copy-multiple-tables-portal/connect-lookup-to-copy.png" alt-text="Connect Lookup activities to Copy activity":::
1. Select the **Copy** activity in the pipeline. Switch to the **Source** tab in the **Properties** window. 

    1. Select **SourceDataset** for **Source Dataset**. 
    1. Select **Query** for **Use Query**. 
    1. Enter the following SQL query for **Query**.

        
    :::image type="content" source="./media/tutorial-incremental-copy-multiple-tables-portal/pipeline-run-arguments.png" alt-text="Pipeline Run arguments":::

## Monitor the pipeline

1. Switch to the **Monitor** tab on the left. You see the pipeline run triggered by the **manual trigger**. You can use links under the **PIPELINE NAME** column to view activity details and to rerun the pipeline.

1. To see activity runs associated with the pipeline run, select the link under the **PIPELINE NAME** column. For details about the activity runs, select the **Details** link (eyeglasses icon) under the **ACTIVITY NAME** column. 

1. Select **All pipeline runs** at the top to go back to the Pipeline Runs view. To refresh the view, select **Refresh**.


## Review the results
In SQL Server Management Studio, run the following queries against the target SQL database to verify that the data was copied from source tables to destination tables: 

**Query**