Related

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

Question

import data into a managed database from Windows 10

Posted October 5, 2020 109 views
DigitalOcean Managed MySQL Database

Hello,

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 ?

Add a comment
LargeElectricBlueShark
By:
LargeElectricBlueShark
Add a comment

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.

×
2 answers
pistle2020 October 5, 2020

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.

Reply Report
Yannek October 5, 2020

Hi,
Due to official DO Managed Databases doc:
https://www.digitalocean.com/docs/databases/
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:
https://www.digitalocean.com/docs/databases/mysql/how-to/import-databases/
https://www.digitalocean.com/docs/databases/postgresql/how-to/import-databases/
https://www.digitalocean.com/community/tutorials/how-to-migrate-redis-data-to-a-digitalocean-managed-database

How To Migrate Redis Data to a DigitalOcean Managed Database
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.
Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help