dbForge Studio for SQL Server Tutorial - Part 1

Learn how to view database structure on diagram, to make a database schema snapshot and to create a table visually.
Learn more: http://www.devart.com/dbforge/sql/studio/

---

Closed Caption:

welcome to dbForge studio for SQL Server
tutorials these tutorials are created to
show you the main features of the
product and how to apply them in your
daily work for the sake of our tutorials
we designed the demo case which will
develop together with you here we have
the company that has an electronic sales
management system but this system has a
short comment specifically while
processing the order the salesman must
manually calculate the discounted price
for each other position and the sales
department asks us to add an ability to
manage discounts for different products
from one place and they also want
discounts to be automatically taken into
account while calculating the order cost
to add these features into our cells
management system we need to modify the
underlying database that's when before
studio IPS on the scene first let's
explore the database structure to find
the points of change i'll use database
diagram for this purpose I simply grab
the tables and drop them into the
diagram here we got our structure we can
easily zoom using the mouse and the
control key we can
overview the database structure at the
glance you can see the tables connected
with foreign key references we are
looking for sales for detail table here
it is
you can see unit price discount field
here and that's the main point of our
change before introducing any changes to
our database structure i want to make a
snapshot of its current state
snapshot can be compared with President
database structure to detect changes
made by developers later I'll show you
how it works and now we are safe to
modify our database
first I will create the discount table
now I wanted to have only four fields
discount ID description start and end
dates notice that designer automatically
suggests into data type for ID field so
we don't have to change anything for now
we pick discount ID is the primary key
notice that discount ID field
automatically receive fed identify back
we can delete it right from the text but
let's leave it for now hit update
database and our table is created i will
put it onto the diagram and save it for
the future use
that's it part 1 in the part 2 i'll show
you how to modify the existing objects
and how to deal with dependencies thank
you for watching