Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex Data Transfer
  • Available transfers
  • Getting started
    • All guides
    • Preparing for a transfer
      • Managing endpoints
      • Migrating endpoints to a different availability zone
        • Origin
    • Managing transfer process
    • Working with databases during transfer
    • Monitoring transfer status
  • Troubleshooting
  • Access management
  • Pricing policy
  • Terraform reference
  • Monitoring metrics
  • Audit Trails events
  • Public materials

In this article:

  • Scenarios for transferring data from Microsoft SQL Server
  • Preparing the Microsoft SQL Server database
  • Configuring the Microsoft SQL Server source endpoint
  • Configuring the target
  1. Step-by-step guides
  2. Configuring endpoints
  3. Microsoft SQL Server
  4. Origin

Transferring data from a Microsoft SQL Server source endpoint

Written by
Yandex Cloud
Updated at September 28, 2026
View in Markdown
  • Scenarios for transferring data from Microsoft SQL Server
  • Preparing the Microsoft SQL Server database
  • Configuring the Microsoft SQL Server source endpoint
  • Configuring the target

Yandex Data Transfer enables you to migrate data from a Microsoft SQL Server database to Yandex Cloud managed databases and implement various data processing and transformation scenarios. To set up a transfer:

  1. Review possible data transfer scenarios.
  2. Prepare the Microsoft SQL Server database for the transfer.
  3. Set up a source endpoint in Yandex Data Transfer.
  4. Set up one of the supported data targets.
  5. Create and launch the transfer.
  6. If you run into any problems, check the available solutions for troubleshooting.

Scenarios for transferring data from Microsoft SQL ServerScenarios for transferring data from Microsoft SQL Server

You can implement scenarios for data migration and delivery from a Microsoft SQL Server database to managed databases for further storage in the cloud, processing and loading into data marts for further visualization.

For a detailed description of possible Yandex Data Transfer scenarios, see Tutorials.

Preparing the Microsoft SQL Server databasePreparing the Microsoft SQL Server database

Airbyte® has the following requirements for a Microsoft SQL Server data source:

  1. Make sure your database is accessible from the computer running Airbyte®.
  2. Create a dedicated read-only Airbyte® user with access to all tables that require replication.

For more information, see this Airbyte® guide.

Airbyte® is already built into Data Transfer, so you do not have to create a separate VM to deploy it and add a user. All you have to do is grant Data Transfer network access to the source database.

Configuring the Microsoft SQL Server source endpointConfiguring the Microsoft SQL Server source endpoint

When creating an endpoint, select MSSQL as your database type and configure access to SQL Server. You can change the settings after you create an endpoint.

Management console
  • Host: IP address or FQDN of the host you need to connect to.

  • Port: Port number Data Transfer will use for connections to the host.

  • Database: Name of the DB to connect to.

  • Username and Password: Database username and password.

  • SSL Method: Encryption method used when exchanging data with the database:

    • UNENCRYPTED: Saving the password as plain text.

    • ENCRYPTER (trust cert): Using a certificate from a trusted source.

    • ENCRYPTER (verify cert): Using a self-signed certificate.

Read more about settings in this Airbyte® guide.

Configuring the targetConfiguring the target

Configure one of the supported data targets:

  • MySQL®
  • MongoDB
  • ClickHouse®
  • Greenplum®
  • Yandex Managed Service for YDB
  • Apache Kafka®
  • YDS
  • PostgreSQL

For a complete list of supported sources and targets in Yandex Data Transfer, see Available transfers.

Make sure that the network hosting the target cluster is configured to allow connections from the internet. To enable internet access, set up routing.

Once you have configured the source and target, create and launch the transfer.

Airbyte® is a registered trademark of Airbyte, Inc in the United States and/or other countries.

ClickHouse® is a registered trademark of ClickHouse, Inc.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.

Was the article helpful?

Previous
Origin
Next
Origin
© 2026 Direct Cursus Technology L.L.C.