How to run sql file in terminal
- how to run sql file in putty
- how to run sql script in putty
- how to execute sql script in putty
- how to run sql in putty
Shell script to run sql query in oracle...
Proxying MS SQL connections using PuTTY
Connecting to a Microsoft SQL Server database isn't too hard, most of the time. But, what if the database is in your office, and you want to access it remotely, but you don't have a VPN?
There is another way to connect, using PuTTY and port forwarding.
All you need is a server in the office which accepts SSH connections and can connect to the SQL Server.
How to run sql file
This will serve as a gateway or makeshift proxy server. With the proper port forwarding setup, you can connect to your database from anywhere.
Getting PuTTY set up
This article assumes you already have a basic familiarity with SSH concepts and use of PuTTY to open SSH connections from Windows.
This is not meant to be a "getting started" guide for using PuTTY. If you're new to PuTTY, try the official documentation (https://the.earth.li/~sgtatham/putty/0.58/htmldoc/Chapter2.html#gs) and a guide to creating SSH keys at https://www.ssh.com/ssh/putty/windows/puttygen
The instructions below will work equally well whether you use a password or a key to log into the gateway server.