Should be executed in your PuTTY window while you are in your home directory. Time we will be passing the it SQL Script file that you uploaded earlier in the lab. This fileĬontains a series or SQL commands that will build the tables. In order to create the tables in the database we will need to execute the sample_model.sql file. Include a screenshot of the result, then type Exit to leave SQLCMD Once you have typed the command hit enter to get a new line.

This should bring you to a prompt that looks like belowįrom here you are ready to build your database using the command below opt/mssql-tools/bin/sqlcmd –S localhost –U SA –P YOURPASSWORD In order to create the database we will use the sqlcmd utility.

The files you uploaded will be in your home directory which can be accessed at the path of With the script files uploaded it is now time to connect via PuTTY to your AWS instance and create theĭatabase. You will see the files in the right hand pane. Two files to the right hand pane to upload them to your Linux Instance. sql files from the Module Assignment page. Once you are connected to your Linux box you will want to browse in the left hand pane to the location If you see the error mount: wrong fs type, bad option, bad superblock on. Sudo mount -t vboxsf HOST_SHARE GUEST_SHARE Make Folder Location where the SQL Scripts are. Sudo apt-get install virtualbox-guest-utilsĬreate a shared folder in VirtualBox settings of the ubuntu server. Make sure you installed the VB Guest Utils

Put them in a folder that is easy to find. Download the SQL scripts to your computer.

Virtualbox transfer files