dbForge SQL Tools – 15 essential SQL Server development tools in one package

dbForge SQL Tools is a comprehensive toolset, designed to empower database development.

It comprises a selection of essential tools that can increase the daily productivity of standalone developers and entire teams by more than 50%.
These tools offer versatile functionality for SQL Server development and administration, as well as seamless integration with SQL Server Management Studio and Visual Studio.

You can also set up a Continuous Integration process using PowerShell and plugins for CI systems such as Jenkins, Bamboo, TeamCity, and Azure DevOps.

This video is a brief overview of each tool in the pack. With a few quick examples in SQL Server Management Studio, we will show you how easy and simple it is to get your tasks done with SQL Tools.

⭐️Timestamps:
00:00 Introduction
00:59 SQL Complete
01:22 Source Control
01:55 Data Generator
02:20 Schema Compare
02:48 Data Compare
03:05 Unit Test
03:40 Index Manager
04:19 Data Pump
05:05 Documenter
05:40 Search
06:23 Query Builder
07:05 SQL Decryptor
07:55 Event Profiler
08:26 Monitor
08:55 DevOps Automation

⭐️Thank you for watching!

👉🏽Download a 30-day free trial of SQL Tools here:
https://www.devart.com/dbforge/sql/sql-tools/download.html
►For more details visit dbForge SQL Tools here:
https://www.devart.com/dbforge/sql/sql-tools/

►Subscribe to the Devart Youtube channel:
https://www.youtube.com/user/DevartSoftware

#SQL #SQLTools #SQLDatabase #DatabaseDevelopment #dbForge #Devart

---

Closed Caption:

dbforge sql tools make your database
development easy
dbforge sql tools is a comprehensive
toolset designed to empower database
development
it comprises a selection of essential
tools that can increase the daily
productivity of standalone developers
and entire teams by more than 50 percent
these tools offer versatile
functionality for sql server development
and administration as well as seamless
integration with sql server management
studio and visual studio you can also
set up a continuous integration process
using powershell and plugins for ci
systems such as jenkins bamboo
city and azure devops
this video is a brief overview of each
tool in the pack with a few quick
examples in sql server management studio
we will show you how easy and simple it
is to get your tasks done with sql tools
let's start with sql complete a tool
that drastically speeds up your sql
coding with advanced auto completion
code formatting and refactoring options
you will be able to write queries of any
complexity and format code according to
your corporate standards quickly and
easily eventually you will increase your
daily productivity with all the features
and options of sql complete that are
absent from ssms and visual studio our
next tool is the dbforge source control
a powerful ssms add-in that helps you
version control changes in sql server
databases
to launch it simply select the database
that you want to link and invoke source
control from the shortcut menus in ssms
this tool is compatible with all major
source control systems including git svn
tfs perforce mercurial and source gear
vault
dbforge source control delivers a smooth
and clear workflow in an intuitive and
convenient user interface next comes
dbforge data generator a tool that
comprises over 200 generators of
meaningful test data it works as a
standalone tool yet it can also be
launched from ssms just select the
database that must be populated with
test data and invoke data generator from
the shortcut menu the job will be done
in a matter of moments even if it
concerns thousands of rows of coherent
realistic data now let's take a look at
db forge schema compare the most
convenient tool for the comparison and
synchronization of your database schemas
it can also be launched separately or
accessed from ssms select the source and
target databases to be compared and run
schema compare the wizard will create a
new project where you will be able to
configure the comparison of database
schemas objects backups script folders
files and source control snapshots or
any combination of these
similarly you can compare and sync your
data using db forge data compare select
your source and target invoke the tool
and start the comparison afterwards you
will be able to analyze differences in
your data generate comparison reports
and deploy your changes to the target
database
the next tool that we'd like to show you
is dbforge unit test which helps you
write stable and reliable sql code that
can be easily regression tested at the
unit level
to use this tool simply install the t
sql t framework on the database that
contains the unit tests and set them for
execution to see the successful results
afterwards
you will see that creating and managing
tests has never been easier
next comes dbforge index manager which
helps determine the statuses of indexes
and see what tables require maintenance
simply select the database to be
analyzed and invoke the tool from the
ssms shortcut menu the tool
automatically finds database indexes
that require defragmentation
the list of defragmented indexes can be
easily exported to a csv file the
scripts for reorganization of selected
indexes can be copied to clipboard or to
a sql file
finally click fix to run the maintenance
all the indexes will be successfully
defragmented
dbforge data pump is yet another handy
ssms add-in that helps populate sql
databases with external source data and
migrate data between systems without
much effort just select the database
that you want to export data from and
launch data pump from the ssms shortcut
menu
specify the preferred format the source
and create the export file
data import to newer existing tables is
just as easy
all in all data pump for sql server is a
highly customizable solution that
facilitates data import and export and
thus boosts your productivity and speeds
up the delivery of your results
our next tool is the dbforge documenter
which automates the generation of
database documentation and is also
accessible directly from ssms just
select the database you want to document
invoke the tool from the shortcut menu
and configure your requirements
then preview your documentation for each
object and generate it in html pdf or
markdown whatever is required by your
corporate standards
the next tool is dbforge search a free
ssms add-in for easy search across your
test and production databases simply
launch it from the ssms object explorer
select the connection as well as the
databases and objects where your search
will be conducted then enter the name of
the required object and begin your
search
otherwise you can easily navigate to the
required object in the object explorer
tree
you can search for data as well
simply use the corresponding mode with
dbforge search you no longer need to
look through the entire ssms object
explorer to locate a required column
name or text in a stored procedure this
tool will definitely make your daily
work easier
now let's take a look at dbforge query
builder
it's a convenient standalone solution
with multiple options that help design
sql queries visually without writing
code
to easily build a query to obtain data
select the required tables and drag them
onto a chart
you can also wrap your query in a sub
query and change the query type
query builder includes a lot of features
that speed up your work in fact it is
yet another tool that helps beautify
your code and automate your daily
workflow without much effort
dbforge sql decrypter is a free tool
that allows decrypting and viewing
encrypted database objects in just a few
clicks
you get three output options to choose
from
the first one is single t-sql script
file and it exports all selected objects
into a single sql file
the second one is sql script file per
object
in this case a separate sql file will be
created for each selected object
the third one is decrypt in place your
file will be decrypted on the server and
you will be able to work with the
required object directly in sql server
management studio dbforge sql decrypter
is the fastest and most reliable way of
decrypting encrypted sql server objects
our next tool is the db event profiler a
powerful free tool that helps inspect
and analyze sql server events
it works as a standalone tool you simply
configure the necessary parameters using
the handy wizard and start monitoring
all server events
dbforge event profiler helps view the
query text extract the contents into a
separate sql file and save the project
to reuse it later whenever you may need
it
another tool we'd like to show you is
dbforge monitor a free ssms add-in that
helps track and analyze sql server
performance once monitor is launched the
overview tab appears and displays three
real-time graphs
cpu utilization memory utilization and
disk activity graph visualization helps
evaluate server performance and load on
the fly also you get a number of other
metrics that form a clear and
comprehensive picture of all processes
taking place on the server
finally there's dbforge devops
automation which helps set up a complete
devops cycle from development to
deployment to production it helps build
up a single logic chain that involves
all major db forged products as its
integral parts
this example shows how easily you can
use a powershell commandlet to automate
the formatting process and make your
script compliant with the standards used
in your company also this tool supports
the most popular continuous integration
systems such as azure devops jenkins
team city and bamboo now you can see how
each dbforge tool for sql server
contributes to your daily workflow
simplifies it and helps accelerate the
delivery of results download a 30-day
free trial of sql tools and see
everything for yourself
thanks for watching
[Music]