Hit OK, your Database should be created. Make sure you create one database per each company. At the End, you should have the following databases: Once this is complete, you are ready to load the sample data. Loading Sample Data To load the data, we will need to run the scripts in their respective database. In SQL Management Studio, perform a File -> Open -> File and open up the desired script: Once the script is opened, make sure you are in the right database and run the script. The script will create the tables that we are going to work with and isnert dummy data into those tables. Once the script is executed, you cann open up the database in the object explorer and take a look at the tables: We can verify that the tables have been created by right clicking on the tables and performing a “select top 1000 rows” Remember to run the scripts in the 3 databases (colonial, solmaris and TAL).
Hit OK, your Database should be created. Make sure you create one database per each company. At the End, you should have the following databases: Once this is complete, you are ready to load the sample data. Loading Sample Data To load the data, we will need to run the scripts in their respective database. In SQL Management Studio, perform a File -> Open -> File and open up the desired script: Once the script is opened, make sure you are in the right database and run the script. The script will create the tables that we are going to work with and isnert dummy data into those tables. Once the script is executed, you cann open up the database in the object explorer and take a look at the tables: We can verify that the tables have been created by right clicking on the tables and performing a “select top 1000 rows” Remember to run the scripts in the 3 databases (colonial, solmaris and TAL).