Connect Sql Server throught VS Code Mssql extension
In data warehouse course, the software recommended is VS SQL Management.
And you only have it on windows. Before, I always use the desktop at shcool to connect the server. Today, I questioned my self, if the server is running on server, and VS SQL manager is only a client. Is there a client on mac for SQL server? And I found this question on stackoverflow.
How to connect dochyper
- install mssql extension on vs code
- CMD+Ship+p,
sql
, chooseMS SQL:Connect
- enter server name:
dochyper.unitec.ac.nz
- leave DB name blank?
- username
- password
- save pwd ?
- save profile?
and connection is done.
CMD + Shift + E
to run the sql commands. 👍