Question
import data into a managed database from Windows 10
- Posted October 5, 2020
- 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 ?
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
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
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.