Total Page Preview: 000000004421
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