Database Reference
In-Depth Information
Figure 5-7.
SSIS Designer
Toolbox. The Toolbox contains a plethora of what are called
tasks,
which are control and data-flow elements that define units of work that are contained and preformed
within a package. You use a few of these tasks to migrate the data from your local database to your SQL
Azure database.
In Visual Studio, select View
Clearing Any Preexisting Data
Let's clear any data that exists in the SQL Azure database so you can start with a clean slate. In SSMS,
open a new query connecting to the TechBio database, and delete the data from the UserDocs, Users,
and Docs tables by executing the following
DELETE
statements:
DELETE FROM UserDocs
DELETE FROM Docs
DELETE FROM Users
All three of those tables should now contain no data, as shown in Figure 5-8.
