GDC Class Notes

Class Notes of Graduate Diploma in Computing in Unitec

Use VS Code to Connect Sql Server

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

  1. install mssql extension on vs code
  2. CMD+Ship+p, sql, choose MS SQL:Connect
  3. enter server name: dochyper.unitec.ac.nz
  4. leave DB name blank?
  5. username
  6. password
  7. save pwd ?
  8. save profile?

and connection is done.

CMD + Shift + E to run the sql commands. 👍

More