Let's now try a database migration by carrying out the following steps:
- The database that we are working with already contains the tables and stored procedures in our scripts, so we are going to be brave and delete our database. In SSMS, in Object Explorer, right-click the database and choose Delete:
- We are going to create the database again with the same name. So, in Object Explorer, right-click on Databases and click on the New Database... option. Enter QandA for the name of the database and click OK:
- Back in Visual Studio, press F5 to run the app.
- After the app has run up, go to SSMS, and in Object ...