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 ?
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.
×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.
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
Question