Is it possible to use the SQL server of my ASP.NET VM instance on the Google Cloud Platform?
I have a doubt about Google Cloud Platform...
I did an ASP.NET deployment via Google Cloud which created a VM instance.
When I connect to the VM via RDP I notice that the VM has SQL server installed.
Can I use that SQL server for my hosted website on the same VM or do I need to order a separate SQL database via Google Cloud SQL?
Some explanation on why I can or can't use the SQL server on my VM would be very helpful as so far I did not succeed to find back anything about this in the documentation. And what are the pros & cons if it can be used compared to Cloud SQL?
Yes you can use a local database on a GCE VM.
But this becomes essentially having an on-prem database.
So really your question is on-prem vs Cloud database which there are endless blogs and information on the web about. This article does a good job explaining the pros and cons.
Pros for Cloud SQL is that it is a managed service and has automatic backups, maintenance, scaling, IAM database authentication etc.
While if you used a local database on a GCE VM you would be in charge of maintaining it and scaling it properly, a lot more work falls on you to make sure things run smoothly.
- How to check valid URL address?
- Parser Error- is not allowed here because it does not extend class 'System.Web.UI.Page'
- How to add data items to a List<Struct>
- IIS Regional Settings
- Set a default page in dynamic data
- ClosedXML Format cell to contain formula
- ProblemDetails response does not contain TraceId property
- Passing Parameter from AJAX call to .NET Controller as List<>
- ASP.NET rdlc with external images not displaying images in PDF
- When should I use async controllers in ASP.NET MVC?
- CSS messing up in updatepanel
- ERROR - Must Declare Scalar Variable - C#
- .Net Core 3.1 HttpClient does not reuse sockets
- How do I display a link as plain text in a README file
- POSTing JsonObject With HttpClient From Web API
- asp.net c# redirecting from http to https
- Compile the code in the form of a string
- How to read each row and value with SqlCommand in C#?
- Stimulsoft doesn't show correct pdf font in smart phone
- Sending Emails with BCC list not working
- Response.Redirect using ~ Path
- When should I use OWIN Katana?
- Do an HTTP 307 redirect
- Foreach loop, determine which is the last iteration of the loop
- IIS 7 Error "A specified logon session does not exist. It may already have been terminated." when using https
- get the ServiceKey value from a within a KeyedService implementation
- How can I validate multiple action parameters with ValidationAttribute in ASP.NET Core 3.0
- ASP Repeater control with multiple templates
- A "title" or a "header" for a div
- Get the application's JavascriptSerializer in a old ASP.NET ASMX web service