Deploy to Azure SQL

Octopus Cloud
, ,
1

Hi,

Is there any way to use Azure SQL Server with Octopus deployment. If possible please share the document or article on this.

Thanks.

3

Hi @rudramaniteja,

Thanks for getting in touch!

There is no guide for this within Octopus, but as you can see within the SQL server documentation it is supported:

You would first need to create the Database within Azure. I have attached a document that will help you achieve that:

You would need to allow access to this SQL instance from your machine:

image
image.png1912×1708 227 KB

The Connection string will show you the server name plus the port number needed:

image
image.png3354×686 172 KB

You will enter this information into the Octopus manager wizard:

image
image.png1296×815 17.4 KB

Once this is done, you will have a working product.

I hope this helps if you have any further questions, please reach out.

Kind regards,
Ziaul

4

Hi,
Thanks for response.

I use roundhouse for database migrations, till now i have databases on Virtual Machine. So I used SQL VM as a target in Octopus by adding as tentacle. But recently we have migrated all databsed to Azure SQL server. So how can i add Azure SQL service as a target in Octopus?

I am using Octopus cloud, not configured on a server.

Thanks.

5

Team,

Can you update on this issue.

Thanks

6

Hi @rudramaniteja,

Extremely sorry about the late reply.

Unfortunately, Octopus does not support this straight out of the box. You would need to use a Jumpbox to achieve what you are after. I’ve attached some documentation which should guide you through:

I hope this helps if you require any additional guidance, please do get in touch!

Kind regards,
Ziaul

8

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.