import data into a managed database from Windows 10

Posted October 5, 2020 390 views
DigitalOcean Managed MySQL Database


I have a SQL dump that I would like to inject into my managed database. How can I proceed in order to upload the payload to my database from windows ?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers

to Import Data into Azure SQL Database
Use Transact-SQL statements. Using the commands, BULK INSERT or OPENROWSET (BULK…), you can import data.
Import using the Flat File Wizard. Using the Import Flat File Wizard in SSMS, you can import a text file into SQL server.
SQL Server Import and Export Wizard.

Due to official DO Managed Databases doc:
there are three database engines currently available within DO Managed Database Service: MySQL, PostgreSQL, and Redis. Select the most compatible with your database dump and follow one of the guides from the links below:

by Mark Drake
Redis provides a number of methods one can use to migrate data from one instance to another, like replication and snapshotting. However, migrations can get complicated when you're moving data to a Redis instance managed by a cloud provider, as managed databases tend to limit how much control you have over the database's configuration. This tutorial outlines one method you can use to migrate data to a Redis instance managed by DigitalOcean using Redis's internal MIGRATE command.