Data and Schema Management

Data Management

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

Table Data Editor

This advanced feature was demonstrated on our main page. We have repeated the link to the presentation here. The Table Data Editor offers an easy-to-use point-and-click interface that allows you to...

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

Import / Export Data

No database toolset would be complete without the ability to import and export data. dbOrchestra is no exception. However, here is where we stand head and shoulder above the competition.

• Point to a directory and import many files in a single job!
• Import data from an Excel spreadsheet
• Each worksheet in the spreadsheet gets imported as a table!
• Export data for an entire database to a directory, each table as its own delimited file
• Specify the delimiter symbol and other parameters
• Save the results of any query to an Excel spreadsheet

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, there is more...

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

Execute query return selectable record set 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 following image below 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 below 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.

Schema Extractor

This is pretty standard fare to expect in most SQL tools.