Search code examples
sql-serversql-server-2012data-warehousepartitioningdatabase-partitioning

Partition exchange equivalent in SQL Server

I'm inexperienced with partitioning in SQL Server. I read on oracle-base that there is a concept of Exchange Partition where we switch the pointer from 1 partition to another with data. source: oracle-base

I see that SQL Server also have concept of partition switching. Though I am still reading more about this, I have following questions to raise:

  1. Oracle exchange partition and SQL Server partition switching are equivalent to each other?

  2. Oracle exchange partition lets switch pointer with data present in partition. Is same true for SQL Server?

This is required for a data warehouse ETL process.

Prod System: SQL Server 2012 Enterprise Edition

Thanks

Solution

  • I finally figured out solution. For my use case, I used Schema Swap methodology.

    Syntax: ALTER SCHEMA <new schema> TRANSFER <existing schema>.<table>;

    Basically, my need was to compare new full load data with existing full load data. This sqlservercentral post helped me to achieve my goal, further by using SSIS.