This video demonstrates how to create automate dropping and creating the database and associated tables by creating SQL database scripts and calling them from a batch file. It shows you how to set up your environment and specify the deployment location of your database (.mdf) and log files.
Create the Database: • Software Development Deep Skill: Auto...
Script Drop and Create Database: • Software Development Deep Skill: Auto...
Script Drop and Create Tables: • Software Development Deep Skill: Auto...
Create Setup Environment Batch File: • Software Development Deep Skill: Auto...
Modify Database File Deployment Location: • Software Development Deep Skill: Auto...
Create Master Script: • Software Development Deep Skill: Auto...
Test and Debug Scripts: • Software Development Deep Skill: Auto...