January 14, 2017 at 8:08 am
A little bit about my sql experience. I used Sql Server in my prior job to watch a 2 billion dollar budget but we had a dba so all I did was write queries. I retired, but still like to program using VB and sql server for my data tables. I am a beginner as far as db admin is and while I was setting sql server up on my laptop, I would google any errors and correct them. Sql server is humming along now and working quite nicely.
The desktop computer I had shot craps and while I was waiting to get it repaired, I started to use my laptop as my main computer. I have dual monitors, printer, speakers, keyboard, etc all connected, and if I want to move it, I have to unplug a lot of stuff to take it anywhere. It is my main computer now and to make it easier, I just got another laptop (two in 1) as my portable machine.
So now what I am looking at is to work from the same sql database on both computers. I am thinking cloud and maybe Azure. I have two databases I use off of 1 server and there are less than 50 tables in both databases combined. The larges table has 100,000 rows with 25 columns so in the whole scheme of things, it is pretty small.
The questions I have are:
Is Azure the only cloud I can use for Sql Server"
With what I am doing, the Azure $5.00/month plan should work for me shouldn't it?
Can I set up security so I can be on a public Wifi and be protected?
Can I backup my data from the cloud onto my laptop?
How hard is it to migrate the data from my laptop to the cloud.
Now I do this to connect to my database from vb: Con1.ConnectionString = "Server=server\SQLEXPRESS;Database = database;Integrated Security=SSPI;"
How do I do to connect to Azure from vb"
Thanks in advance
Carroll
January 17, 2017 at 1:28 pm
The size of the db doesn't necessarily matter, except for the cost in Azure.
What you need to work on the database from two machines is connectivity. As long as each machine can see the server from a network standpoint, and connect across a port (default 1433), you can access it from anywhere. You can do this in Azure, where you can use the Azure SQL Database. You will likely need to connect to the Azure portal from a secure browser and add in your local IP to the firewall, but it's fairly quick to do this.
If you want to use another cloud provider, typically you would be renting a VM from them and installing SQL in it. That works as well, but usually more expensive. AWS has a SQL RDS, no idea on cost.
The other thing to do is just run SQL in a VM on your local system and connect from one machine to the other. You could even put Virtual Box on each machine and keep the VM on an external drive, moving it from machine to machine if you travel with only one.
Backups from Azure, or anywhere, can be made to your machine. It's not that hard, but it is a little practice and learning.
Easy to move data from your laptop to the cloud. SSIS will easily copy data between SQL Servers.
Once you have an Azure database (or anywhere), the connection string is in the portal. You just need a server address to connect. Here's on old post on connecting: https://voiceofthedba.com/2013/05/30/exploring-a-database-in-azure/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply