Database management Tools comparison // IT Management Solutions

Database management Tools comparison

AdminerThis article lists 10 of the best free tools for managing, comparing, administering and developing databases. Even if you may have heard of some of these tools before, I’m confident that you’ll find a gem or two on this list.

Adminer is a database management tool that allows you to manage databases, tables, columns, relations, indexes, users, permissions, and more from a web-based user interface. It is packaged as a single PHP file (similar to phpMyAdmin) and has support for popular database management systems like MySQL, PostgreSQL, SQLite, MS SQL, Oracle and MongoDB. Different UI designs are available for you to download as CSS files.

When you load the Adminer page, you are asked to choose a database management system to connect to, along with the server name, database name and user credentials. Once you successfully login you are shown the database tables and can begin managing the database.

DBComparerDBComparer is a database comparison tool for analysing the differences in Microsoft SQL Server database structures from an easy-to-use UI. Amongst others, you can compare database objects such as tables, columns, indexes, foreign keys, users, roles, schemas and stored procedures.

When you launch DBComparer, you choose which database to display on the ‘left side’ and which database to display on the ‘right side’ of the comparison window. You can explicitly specify what objects and properties you’d like to compare from the Compare Options tab. Once the comparison process is complete you are shown both databases side-by-side (with the differences highlighted in red or blue).SQLManagerLite When you select an object, the data is shown on the Properties window and the SQL syntax is shown in the SQL Differences window at the bottom.

EMS SQL Manager Lite for SQL Server allows you to create and edit SQL Server database objects and create, edit, execute and save SQL queries. It has a user-friendly interface and a lot of the functionality is wizard driven. It makes a good alternative to Microsoft SQL Server Management Studio.

Note: EMS provide Lite versions for other RDBMS’ as well, so if you have Oracle or MySQL you can get the same tool to manage these databases.

When you run EMS SQL Manager Lite for SQL Server, you’ll first need to register a database to manage. Once you’ve done that, you begin by navigating through the DB Explorer window on the left hand side or by opening a SQL script.

FlameRobin SquirrelClient SQLLiteBrowser ExecuteQuery
See also:

You might also like

VFP, VB, .NET company I RAGGED on

by GMoneyJones

I found this position on a job board and sent them this email blasting the cheap bastards:
--- Their ad ----
1. Develop and support document imaging applications to scan paper files for Web hosting, and access using VB. Net.
2. Develop interface software applications between VFP data capture module at remote sites to be imported into main office SBT-ACCPAC Accounting Software.
3. Create and maintain required database queries, design and maintain data reports for various users.
4. Review and support firewall, backup procedures and network management

互联网时代的网络自动化运维  — 中关村在线
CMDB(Configuration Management Database) 配置管理数据库(以下简称:CMDB),将IT基础架构的所有组件存储为配置项,维护每个配置项的详细数据,维护各配置项之间的关系数据以及事件、变更历史等管理数据。通过将这些数 ..

Related Posts

Copyright © . All Rights Reserved