Dealing with different types of databases and tired of switching between different RDBMS software to establish and check connections, execute queries, handle forms and tables, generate reports, etc? Perhaps, a database management solution capable of handling multiple databases would reduce the time and effort involved in managing different types of databases. You may find a handful of database viewers, having the ability to render a range of databases but what about editing and modifying structure of databases? Database Editor is a database explorer and editor which supports all database types of ODBC whilst supporting schemas of Oracle, DB2, SQL Server, MySQL, Access, SQLite, InterBase, etc.
Its major focus is on providing all the essential SQL editing tools with features to create, edit, execute queries. SQL history is also integrated within the application which lets user review previously modified and executed SQL queries. Moreover, you can choose to save most used SQL queries as templates which can be used anytime with other databases. This prevents you from writing somewhat same lines of commands in SQL editor to perform actions over tables. Just select the required template to import into current database.
For the first time, you have to create a couple of database connections, so you can switch between them with a single click. Unlike other Database managers, it doesn’t take too much time to establish and verify connection parameters. Connection can be created in 4 simple ways. You can either use installed providers, custom connection string, system DSN – ODBC connection, or user DSN ODBC connections.
The installed providers option presents all the installed DB servers and clients, letting you choose type of database from the list. By using selected DBMS OLE DB providers, it establish connection with your database within no time.
After the connection is established, it shows table hierarchy in main navigation bar while main MDI based window lets you to edit and execute SQL queries and view and modify database tables. SQL editor toolbar has options to save, print, edit, create new, and SQL execute commands. The pull-down menu lets you switch database connections quickly.
To create a new table in current database, right-click on any table listed in main navigation bar and select Create Table. It presents an extensive database table creator with all the options to specify data type, unique identifier (primary key), default value, data size and so on.
Apart from DB tables, it also allows you to create objects, such as, DB table view, tablespaces, trigger, function, schema, index, package, etc. You can for instance create a new function by specifying required parameters. It can generate SQL commands for your function, so you can use them in database and manipulate in a way you like.
Database Editor certainly provides a complete database editing solution for database managers and administrators. Don’t forget to go through help guide which is available on the product page to understand all the features and functions it has to offer.