Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

ORGANIZE YOUR WORK

Create structure in your environment with dynamic folders.

Dynamic folders allow you to work more efficient in a team.

It will truly improve the way of working, you'll enjoy it

Teams work together on the same dynamic folders.

No changes are made to your user databases.

Dynamic folders

PROJECT TEAMWORK

Folder information is visible to everyone using SQLTreeo SSMS ADDIN.

Ideal for any project team structure. Categorize per project, customer, team, ...

Communication is being improved when your work is structured.

Project teamwork

OPTIMIZE YOUR MAINTENANCE TASKS

Maintenance jobs, Reporting jobs, user jobs.

By default All jobs are shown in one large list

you have to visually go through the list to "find" the job you need to work on

Separate maintenance tasks from user tasks from etl tasks and cleanup

You will never have any problems to find the right job.

custom-folders custom-folders

COMPARE OBJECTS

Compare your work with another environment/database.

A single click and you have a detailed comparization

Compare ANY object: Server, Database, Table, Procedure, View, Job, ...

Compare objects

GENERATE SCRIPTS

Get any object scripted by one mouse click. No more struggle finding the right efficient tool to script your Databases. SSMS ADDIN is able to script nearly any database object or folder.

Generate scripts

HOW BIG IS YOUR DATABASE

Immediately see the size of your Database. Detailed information on data and log size, used data and more.

taking away the extra step of querying this information.

Database properties

HOW MANY ROWS IN YOUR TABLE?

Immediately see the size of your table. Detailed information on number of rows, used data and more.

taking away the extra step of querying this information.

Table properties

EASILY EXPORT DATA

Extracting data is always a daunting task

Export the columns / rows that you want with a simple dialog

The output is a SQL Script that you can execute on any other database.

export table data

In this article