• Home
• Purchase
• Support
• SQL Server Resources
• Main Site

Data Management

Managing data is a difficult task to coordinate within an enterprise. Typically you have to manage database builds for Sales, Training, Test/QA and Development. Each have their own unique data requirements. dbOrchestra allows you to easily manage multiple database builds. Our DB Builder modules makes building multiple instances of a database an easy task. 

Table Data Editor

The Table Data Editor offers an easy-to-use point-and-click interface that allows you to...

• Directly Update a Row though a visual interface
• Directly Insert new row using any existing row as a template
• Quickly Delete single or multiple rows
• Build scripts for Insert, Update, Delete
• Easily Filter Rows

Import / Export Data

No database toolset is complete without the ability to import and export data. Most export tools only allow you to export one table at a time. dbOrchesta allows you to output as many SQL tables as you want in a single job!

Table Data Manager

Understanding complex databases is hard! Case tools produce database schema pictures that take $30,000 printers to reproduce. Sure they can produce the output to a PDF file, and all you need is an electron microscope to read them :-). 

In a single window you can quickly see the child-parent, parent-child, and object relationships in a few simple clicks. If this were the only function available in the Table Data Manager it would be worth it.

 But, here is more...

• Build complex sql queries using easy point-and-click interface 
• Build stored procedures 
• Build views

Execute query, return selectable recordset that can be further used to...

• Generate Insert, Update, Delete scripts 
• Perform direct execution of Insert, Update, Delete
• Perform bulk update (search and replace in selected rows)
• Produce results to Excel 

Table Data Difference Manager

Much like the Schema Difference Manager, the Data Difference Manager allows you to compare two databases. This comes in particularly handy when trying to keep certain metadata "in sync" between source and target databases.

Schema Management

dbOrchestra provides numerous tools for schema management. We pretty much cover all the bases with functionality that you will need to efficiently manage your tables.

Table Schema Manager

The Table Schema Manager is a powerful tool that allows you to quickly modify table schema. This feature allows you to quickly add new columns by using existing columns in the table as a template. The Table Schema Manager supports the following functions:

• Drop column
• Modify column
• Rename column
• Add column
• Add check constraint
• Drop check constraint
• Add default constraint
• Drop default constraint
• Modify primary key
  
  

The output of any of these functions results in dbOrchestra writing code for you. Click the image to the right to see a quick scenario for creating a default constraint.

Index Builder

The Index Builder is a powerful features that allow you to...

• Directly build indexes within the Builder or
• Create SQL index code to the SQL Editor

Foreign Key Builder

The Foreign Key Builder strikes a nice balance between visual and code. You simply select the parent table column(s), then the joining child table column(s). Click on the picture to the right for details.

File Manager

Managing your SQL source code is an important part of your daily job. Database development and code management can get very complicated. With the File Manager, code organization and access is a breeze. The File Manager has such advanced features as.

• Set Customized Tabs for quick access to your files
• Ability to set filters to only display certain file or directories
• Open files to the SQL Editor
• Compare two files
• Copy files to another directory

The File Manager has far too much functionality to go into detail here. Let's just say once you use this feature you will never want to use another file manager again! 

Schema Difference Manager

Maintaining multiple instances of your databases can be a very complicated venture. Trying to keep these databases "in sync" can be a compelling task. With dbOrchestra's Schema Difference Manager this task becomes quite manageable.

The following is a demonstration of keeping three database instances "in sync." As part of this workflow the Schema Difference Manager is used to verify the databases are indeed "in sync".
(Note: This demonstration is also presented under the Productivity/ROI page.)

Schema Extractor