For example, if you need to connect to one database and issue a few SQL. However, I'm not sure of the required ports on either of those. Select a tool based on the type of administration and reporting that you need to do. Other remote control products include NetMeeting (with Remote Desktop Sharing) and VNC, both of which are free. The article talks about the minimum required to connect to SQL Server across a firewall.Īndy spoke about using PCAnywhere. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned. DB4S is for users and developers who want to create, search, and edit databases. It is one of the best SQL tools which has. Here's an article I found on the Technet site which details these things in a little more detail: DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. Interactive SQL for MSSQL is a handy tool for working with Microsoft SQL tables, views and queries. Adminer is a SQL management client tool for managing databases, tables, relations, indexes, users. Also, by setting the aliases there, I would think EM would then automatically resort to TCP/IP, thereby reducing the NetBIOS calls. By setting aliases there, you can also specify to only use port 1433, rather than have the client try and dynamically determine what port to use. The way around this is once again with your Client Network Utility. That's why you are seeing the UDP 1434 traffic bouncing around. MySQL Workbench is available on Windows, Linux and Mac OS X. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. Maestro is the premier PostgreSQL management tools, database management. MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. Ok, port 1434 for UDP is what the client is using to try and determine what ports SQL Server is listening on, what instances are available (if SQL2K), whether it's clustered, etc. database engineering Oracle Admin Tools - Oracle DBA Tools by SQL Maestro Group.

Sql admin tools