IDERA released a new free tool, Rapid Database Extractor, designed to help you gain quick visibility into SQL Server and Oracle databases from a single user interface. Its integrated development environment simplifies exploring and manipulating database content by streamlining and automating common and repetitive tasks, reducing error, and increasing productivity.
With the free tool, connect to SQL Server and Oracle data sources from a single user interface. Register data sources manually or semi-automatically. Log in to multiple data sources. Drill down into the data sources to view registered databases on each server.
Drill down into each database to display its objects and to inspect the structure of individual objects for quick visibility into databases. Navigate and search objects, create new objects, edit existing objects, execute context-sensitive commands, and browse outline views without SQL script. Manage database objects, including tables, constraints, indexes, views, procedures, functions, triggers, and packages. Efficiently navigate databases with many objects.
Edit SQL code in the interactive development environment. Select from a list of context-sensitive suggestions for object and function names, and automatically insert SQL statements from templates to avoid looking up, memorizing, and typing. Prevent and fix common mistakes with SQL code quality markers. Validate SQL syntax and semantics in real-time to avoid parser violations and unresolved references. Automatically format displayed SQL code for easy navigation. Apply and share custom SQL formatting profiles for consistent SQL code layout. Improve queries by viewing the SQL query execution plan.
Associate SQL files with data sources, specify SQL session options, and selectively execute SQL statements in the integrated environment to manipulate quickly database content. Display the resulting data in a convenient grid. View logs of all executed SQL queries to analyze and document past actions. Save extracted data to standard file formats (delimited TXT, HTML, XML, Excel, and SQL INSERT statements) for subsequent analysis and collaboration.
Download the new Rapid Database Extractor today to explore and manipulate your SQL Server and Oracle database content. Refer also to IDERA’s Community Forum for Rapid Database Extractor.