I deployed sql server 2017 to my kubernetes and I want to put it a sample db such as northwind. There is no a gui for manage sql server. How Can I do that
>Solution :
You can forward your sql server port to localhost and then connect to the database using SQL Server Management Studio.
kubectl port-forward <sql-pod-name> <localhost-port>:<mssql-port>
For example:
kubectl port-forward mssql-statefulset-0 1433:1433
Then your database would be accessed on localhost.
Note that there is a comma between the address and the port
Another way is to connect directly to your database container inside a pod using exec command
kubectl exec -it <pod-name> -- /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'SA-password'