Data and Schema Management For Database Orchestra

Data and Schema Management For Database Orchestra - Oracle

Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

BUY | Database Orchestra - Oracle Start <See Also: Database Orchestra - MSQL>

Data and Schema Management

Import Multiple Files
PLAY

Easy Data Entry
PLAY

Keep schemas in-sync
Play

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.

Database Orchestra - Oracle Start

Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Data and Schema Management For Database Orchestra - Oracle

Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

BUY | Database Orchestra - Oracle Start <See Also: Database Orchestra - MSQL>