Total Page Preview:   000000004477

How to create a SQL-Server instance using cloudshell in gcp?

In this article I am going to explain how to SQL Server instance list in google cloud(gcp) cloudshell command.

 

Syntax 

gcloud sql instances create [INSTANCE_NAME] \
--database-version=[DATABASE_VERSION]  --cpu=2 --memory=3840MiB \
--zone=[ZONE] --root-password=[password123]

Where:

--database-version = SQLSERVER_2017_EXPRESS, SQLSERVER_2017_WEB, SQLSERVER_2017_STANDARD, SQLSERVER_2017_ENTERPRISE

--zone= REGION; default="us-central"  More

 

Example

 gcloud sql instances create prod-instance \
--database-version=SQLSERVER_2017_EXPRESS  --cpu=2 --memory=3840MiB \
--zone=us-central1-a  --root-password=[password123]

 

OUTPUT

Creating Cloud SQL instance...done.
Created [https://sqladmin.googleapis.com/sql/v1beta4/projects/hipaaprojects/instances/prod-instance].
 

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments

Krimmer
19-Oct-2021
I must thank you for the efforts you've put in writing this website. I'm hoping to view the same high-grade blog posts by you later on as well. In fact, your creative writing abilities has encouraged me to get my own, personal blog now ;)
Ferreira
13-Oct-2020
After looking into a number of the articles on your website, I seriously like your way of blogging. I book marked it to my bookmark site list and will be checking back in the near future. Take a look at my web site as well and tell me your opinion.