Database Tools related scripts & softwares
WebSQL wants to run on every DBMS and wants to give you the chance to have a unique tool to access and manage a DB through a simple web interface.
* Minimal program size is about 30KB
* No installation needed
* User authorization
* Database selection
* Listing tables in a database
* Line editing
* Line removal
* Pagination is supported
* Installation of the order of ACS / DESC
* Display of basic SQL queries
* Execution of its own SQL queries
* Display of the date in the fields containing timestamp
Navicat MySQL GUI is a leading MySQL management tool which features an intuitive interface and provides a set of useful tool to manage and develop MySQL. This Lite version supports SSH and HTTP Tunnel for remote database connection.
Navicat full version includes these features: backup/ restore, import/ export data, create report, synchronize database and connect to remote MySQL server, etc. Navicat major features: - Visual Query Builder - - Database transfer from server to server - Data and Structure Synchronization - Data backup and restore - Import/ Export of most popular data formats to and from MySQL - Reporting - Tasks Scheduling and Easy-to-use wizards tool Navicat supports MySQL 5.0 or above and available for Windows, Mac OS X and Linux. Navicat for PostgreSQL is also available at: http://pgsql.navicat.com
FlySpeed SQL Query is an easy-to-learn-and-operate graphical tool for all database users and developers. It allows you to build queries on different database servers without needing deep knowledge of SQL syntax and performs a wide range of data manipulations. Handy for professionals and essential to newbies, FlySpeed SQL Query includes everything to make your work with data more productive than ever before!
DTM ODBC Manager is a free simple and easy-to-use ODBC Data Sources manager. The program allows you to export data source definitions into a file and then restore it on a local or remote system.
ODBC Manager is an indispensable tool for DBAs or developers who have to transfer data source definitions between computers and is a perfect addition to the system ODBC Administrator. Command line and GUI mode. Download your free copy right now!
I've faced issues in the past, particularly with free or eBay webhosts, where the server just "disappears," leaving me with little or no data from my website. As a lesson learned from these mishaps, I've created a set of scripts to ensure that my data is always backed up. This shell script backs up any or all of your databases and emails and/or FTPs them over to you. With cron, you can have this process automated, leaving you with regular backups, as well as a piece of mind.
A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.
GalaXQL is an interactive SQL tutorial. Follow the instructions by your virtual teacher. The teacher can understand several possible mistakes that you may make, and gives hints on what may have gone wrong. You can skip to any chapter in the tutorial whenever you want. Use the query editor to interact with the database, and to complete the assignments given by the virtual teacher.
Databrid is a browsing, retrieval and manipulation tool designed for the novice to the expert user. Databrid works on MySql and Oracle Database (versions 8 and above although not all functionality in the Browser is available for the lower versions). The core functionality of Databrid revolves around the tabbed areas within the Databrid application. The four main tabs in the main screen of Databrid are: SQL Editor, Browser, File and Jobs.
SQLite GUI is a simple GUI to work with SQLite dB. You can create, delete and update tables a database. All the available tables in the database is shown. The records of various types including BLOB are displayed in the DataGridView. And the data in the DataGridView can be printed. The schema for all the available tables is displayed.
Dependencies
Add the reference SQLite.Net.dll to the project and use the namespace Finisar.SQLite to work with SQLite.
Finisar.SQLite
Finisar.SQLite is an ADO.NET Data Provider for accessing SQLite-Databases using the .NET-Framework. In SQLite a complete database is stored in a single disk file. SQLite is zero-configuration - no setup or administration needed. SQLite itself is "a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine" (quoted from the sqlite.org Website). The Finisar.SQLite Data Provider is an easy way to use the SQLite-Database in .net Languages like C# and VB.net.
|