Real-Time Migration with Striim: Microsoft SQL Server to Cloud SQL for PostgreSQL in Minutes

Striim emerges as an outstanding facilitator, enabling the creation of intelligent data pipelines from Microsoft SQL Server to Cloud SQL for PostgreSQL in a matter of minutes. Continuous synchronization between Microsoft SQL Server and PostgreSQL becomes more than a possibility—it becomes a tangible reality. How is this possible? Through Striim's powerful capability to offer real-time data integration by agile and effective capture of modified data.

The example was carried out from a Microsoft SQL Express to PostgreSQL (Cloud SQL). It was not possible to perform a CDC (Change Data Capture) test because the Express version of MSSQL does not support it, as certain modifications need to be executed on the source database.

Striim Connector Configurations: Connecting the Data Bridge

In this chapter, we dive into the technical but vital complexities of establishing an intelligent communication channel between Microsoft SQL Server and Cloud SQL for PostgreSQL in real time. Get ready to delve into the specific configurations that will pave the way for continuous synchronization of modified data between these two titans.

Designing the Roadmap: Schema Selection

In this phase of our migration odyssey, we enter into the subtle but critical choice of schemas. Each schema, with its intertwined nuances and relationships, plays a crucial role in the final destination of our data. We will explore how Striim makes this choice more than just a technical decision.

Navigating the Waters of Migration: Object Selection

In this chapter of our migration journey, we delve into the object selection phase. Unlike Ispirer, at this stage, we focus exclusively on data migration. We will explore how the simplicity of this choice embodies the effectiveness of Striim.

Configuring the Destination: Navigating Toward the New Horizon

In the journey of data migration, we face the crucial task of configuring our destination. With Striim, the freedom to name the destination schema becomes a powerful tool. In this segment, we explore the configuration of the destination, where we shape the new horizon of our migrated data.

Destination Creation Option: Shaping the Future

In the fascinating journey of data migration with Striim, we are presented with the unique opportunity to shape the future of our schemas and tables at the destination. This exceptional feature allows us to create, if we so desire, the schema and tables at the destination that have not yet come into existence.

Discovering the New Horizon: Tables and Schemas at Destination

We encounter the tangible result of our decisions—the tables and schemas that have come to life at the destination, in this case, the powerful Cloud SQL environment. In this section, we explore the newly created tables and schemas at the destination, discovering the structures that will pave the way to optimized performance.

Starting the Journey: Initial Data Load into the Database

At this exciting stage, we embark on the fundamental process of initial data loading into our destination database. Every bit and byte we transfer marks the beginning of a new era, where information comes to life in its new home.

Conclusion: Accelerating the Future with Striim

In the fascinating journey of migrating data from SQL Server to PostgreSQL in the cloud, Striim stands out as a powerful and agile tool. Its ability to transfer data at astonishing speeds and its user-friendly interface make the process smooth and efficient. However, we must be aware that, although Striim excels in data migration, it does not address the transfer of essential objects like procedures, functions, packages, and triggers, to name a few. This is where Ispirer comes into play, skillfully complementing Striim for a complete and hassle-free migration. Together, these two technological allies open the doors to a dynamic future full of possibilities on the destination platform.

Patricio Tapia

DBA Specialist