Sql

	web based msde dba tool - Shusheng SQL Tool  License: Freeware
	web-based MS SQL Server(MSDE)2000 client tool, query analyzer and dba utility to design, create, query, backup, manage and monitor database from a web browser. Pure ASP script, no installation needed. Freeware for Educational and Personal usage. For DBA ( Database Admin ) o Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. o Monitor connections, locks and performance of SQL server. Kill bad process. o Administrate security for server logins (Windows and SQL accounts), database users and roles. o Assign permission to user(s), role(s), object(s). Support column level permission. o Backup, Restore and Repair database. Compress Transaction Log. For Developer ( Database application ) o Color-coded Editor for View, Stored Procedure, User function, Inline function and Trigger. o Create and modify database, table, index, constraint (default, check and foreign key). o Automatic Duplication and Orphanage check. o Database-wise search for a specific value (number, datetime or text format). o Database-wise search for a specific object (table, view, stored procedure, user / inline function and trigger). o Automatic database documentation / dictionary. o Automatic Parent / Child Key tracking and Object Dependency tracking. For End User ( Specific permission might required from DBA ) o Query any data with a color-coded SQL panel. o Edit table data in a spreadsheet-like Editor. (with row/column copy/paste/reset, fill down feature) o WYSIWYG Editor to edit and store large plain/HTML document in the database. o Create user table, view, function, trigger, index and constraint. o Execute any SQL script (multiple, compound query), MS DOS command. o Save and open SQL script from local disk. For all o Secure login from Internet as a Window. o Streamlined query process for large query (return millions of rows without freeze). o Virtual MS DOS prompt window. o Current running Query cancellation. Author: Shusheng Zhou| Date: 01-03-2003 | Size: 819 KB
	-

	TOAD  License: Freeware
	TOAD® empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. TOAD is a powerful, low-overhead tool that makes PL/SQL development faster and easier and simplifies database administration tasks. Advanced editors allow users to work on multiple files simultaneously even different file types such as SQL, PL/SQL, HTML, Java, and text. Hot keys, auto-correct, type-ahead, syntax highlighting, version control and numerous other productivity features speed development, while editing and testing are made easier with integrated result sets, explain plans, tracing, and DBMS_OUTPUT views. Author: Jim McDaniel| Date: 01-07-2001 | Size: 2048 KB
	-

	Database Manager  License: Freeware
	This tool will support you in your database management activities for dBase-compatible tables, especially if you are a user of Vista Software's Apollo Database engine or the Advantage TDataSet descendant or MySQL tables. Supported functions are: Table creation (generates table creation source code for BDE engine, Apollo driver, Advantage driver), converts between Windows and DOS charset, XML export of tables for easy, standardized data exchange, table encryption, packing tables (permanent removes "deleted" (hidden) records), supports deletion, adding, editing and converting database records, displays table statistics, displays and prints table structure, displays index keys and orders, changing of active index order, undeletion of individual or groups of records, supports Clipper-, FoxPro-, and HiPer-SIx indexes and more! Author: Richey F.| Date: 20-01-2001 | Size: 816 KB
	-

	CuteSQL  License: Freeware
	CuteSQL is a freeware utility for all database fans. It allows you to execute SQL commands and queries against any database. Available connections: Native, via ODBC or via ADO. Directly supported databases: Oracle, MS SQL, Interbase, DB2, MySQL and more...Key features: user-friendly interface; tabular displaying of SQL queries; running of saved scripts; history of used scripts; autocommit configuration;terminators settings. Author: CHARONWARE s.r.o.| Date: 16-01-2002 | Size: 1442 KB
	-

	The Query Tool  License: Freeware
	The Query Tool is a powerful data mining application. It allows you to perform data analysis on any SQL database. It has been developed predominately for the non technical user. No knowledge of SQL is required, all actions are data driven. Author: Tyson Software Ltd.| Date: 04-12-2003 | Size: 217 KB
	-

	SQLTools  License: Freeware
	SQLTools is a light weighted and robust tool for database development. It includes a text editor, an sql console and a couple of sql utilities. You can use it for dial-up connection and it will work as fast as SQLPlus. It is small and not required an installation so SQLTools will help you anywhere because it is small enough for floppy and available for downloading on the Web. Key features: * Powerful editor, which supports drag & drop, syntax highlighting, code template expansion, etc. Context sensitive help provides information about the current sql statement. * SQL console, it supports DML & DDL statements and provides additional information about database statistics and timing. * Object Browser is designed for getting any object DDL definition. One of useful features is support group operations, for example, you can select and disable a set of constraints in one operation. * Extract Schema utility, which loads all objects definition and stores on local disk. Author: Aleksey Kochetov| Date: 17-11-2003 | Size: 865 KB
	-

	ODBC View  License: Freeware
	ODBCView is a free SQL query tool to view and export data from any OBDC compliant database. Connect to an ODBC data source and enter a SQL statement to execute. The data is then displayed on a read-only grid or it can be exported to a external CSV or HTML report file. Any valid SQL statements can be executed including UPDATE, DELETE and calls to database procedures. Run it from the command line to open a data source and export a query to a file. Author: SLIK Software Ltd| Date: 01-08-2002 | Size: 4077 KB
	-

	Open QueryBuilder  License: Freeware
	Freeware with full source code! The Open QBuilder (OQBuilder) is a simple "visual query builder". You can use OQBuilder in your Borland Delphi and Borland C++Builder applications to make easier SQL-code generation. OQBuilder allows you to easy work with local and server databases via BDE, ADO, IBO, IBX, DBX, FIBPlus, etc. All versions of Open QBuilder are available as freeware with full source code and samples. You can create new TOQBEngine-descendants to work with any DataSet-oriented sources (for example - OCI engine, etc.). If you create your own OQBEngineXXX - contact us to share them with Delphi and C++Builder developers community. We will place your engines on our web-page. Please, save the style of your engine-component's .dcr-icons and deploy your components as freeware with full source code. OQBuilder allows you to save and load query models. OQBuilder query format looks like ".ini file" and defined (and may be customized by you) in methods procedure TQBForm.btnSaveClick (model saving) and procedure TQBForm.btnOpenClick (model loading). The first limited public version of QBuidler for Delphi 1&2 was released in 1996. Author: Sergey Orlik| Date: 15-10-2003 | Size: 1002 KB
	-

	TOAD for SQL Server  License: Freeware
	TOAD® for SQL Server empowers database developers and administrators (DBAs) to be more productive by providing an intuitive graphical user interface to the Microsot SQL Server 2000 database. TOAD for SQL Server is a simple and powerful yet low-overhead Windows client tool that makes SQL development much easier and greatly simplifies database administration tasks. It provides an advanced browser interface with visual object editotors for creates and alters, plus a rich SQL editor with SQL syntax highlighting and robust data grid options. Plus the SQL editor will actually function with any ODBC database connection, thus it supports many other popular databases like Oracle, DB2, Informix, Ingres, Access, MySQL, Sybase, PostgreSQL, etc. Author: Mark Lerch| Date: 01-01-2004 | Size: 1006 KB
	-

	myLittleAdmin  License: Freeware
	myLittleAdmin is a web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager. Author: myLittleTools.net| Date: 02-06-2003 | Size: 154 KB
	-

	pgAdmin III for PostgreSQL  License: Freeware
	Administration Centre for the PostgreSQL database, freeware. Includes a graphical administration interface, an SQL query tool, a procedural code editor and much more. pgAdmin III is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. Available in more than 30 languages and for several operating systems, including MS Windows, GNU/Linux and FreeBSD. Author: | Date: 27-01-2004 | Size: 4821 KB
	-

	web sql tool - Shusheng SQL Tool  License: Freeware
	web-based MS SQL Server(MSDE)2000 client tool, query analyzer and dba utility to design, create, query, backup, manage and monitor database from a web browser. ASP, no installation needed. Freeware for Educational and Personal usage. 1. Spreadsheet-like Table/Query data editor. (support fill down). 2. Syntax highlight. 3. Login as Windows user or SQL user. 4. Streamlined query for large query (return millions of rows without freeze). Author: CELC| Date: 01-03-2003 | Size: 819 KB
	-

	MySQL Snap  License: Freeware
	MySQL Snap program is intended for creation backup copies of MySQL databases as well as for transport it from one server to another. The program advantages: - full compatibility of the result dump with the dump produced with the help of standard MySQL database management system utility - mysqldump! - standard mysqldump utility keys support; - absence of using standard libmysql.dll library. All information processing is with using API level.. Author: Art-media| Date: 10-12-2002 | Size: 812 KB
	-

	Ariacom Business Reports  License: Freeware
	Easy-to-use database reporting and multi-dimensional analysis tool with dynamic SQL generation. -Native line, bar, point and pie charts -Integrated security management limiting user access -Fully multilingual design (currently in English, French, German, Spanish) -Report results in various formats (html, csv, txt, xml with conversion to pdf) -Output to various devices (file, printer, fax, email) Author: Ariacom| Date: 14-05-2003 | Size: 5592 KB
	-

	Toad for SQL-Server  License: Freeware
	Quest Software's Toad® for SQL Server leverages the knowledge gained from our past experience with database development tools and empowers SQL Server developers and administrators of varying skill levels to rapidly create and execute queries, automate database object management and create T-SQL code more efficiently with an intuitive graphical interface. Toad for SQL Server also provides a data export utility and allows users to view basic database statistics. This free database development and administration tool increases user productivity and offers access to a solid community for interactive support. Author: Quest Software Inc.| Date: 10-11-2004 | Size: 1 KB
	-

	Ariacom Report Manager  License: Freeware
	Ariacom Report Manager is a COM component allowing database reporting and multi-dimensional analysis with dynamic SQL generation. - Native line, bar, point and pie charts - Integrated security management limiting user access - Fully multilingual design - Report results in various formats (html, csv, txt, xml with conversion to pdf) - Output to various devices (file, printer, fax, email) Author: Ariacom| Date: 20-06-2003 | Size: 5719 KB
	-

	jWorkbook  License: Freeware
	jWorkBook: Get Database information directly into your spreadsheet Now a quick way to get the information that is currently in your system databases directly into your spreadsheet. jWorkbook is an Excel Add-In that enables you to build powerful queries to access the information directly and see the information in your Excel Spreadsheet. You can build reports quickly and interactively using the power of single or multiple SQL So.... the information you need is stored in the Oracle, Access or SQL database and you need to look at it and do some calcs and write a quick report? What are your options? Simple, find a programmer, tear him or her away from the thousand other jobs on the go and try to explain what you want. They will put your request into a queue and hey presto 3 months later you get the information you want...if you are lucky! <http://sjslive/products/images/HandIcon.gif> Enter jWorkBook: start up Excel, enter a simple SQL command....bang the information is there! Not quite what you want? No problem, refine the command and run it again. Or add another command and run them both. Format the output in your spreadsheet, add a chart and you have your data in the format you want in a couple of minutes. Really that simple? You bet. SQL is by far the most popular database language available today. It is used as the main form of communication by every database of note. It is extraordinarily powerful. But best of all, to do the vast majority of tasks, it is extremely simple. Unlike languages like C or Basic, you can do most of your data retrieval commands in a single statement. It is a fact that if you understand the English-like Select statement, you are probably 99% of the way to being self sufficient in retrieving your data from the database. Granted, as you get proficient in SQL, you will naturally extend your skills to more exotic structures but from day one, you are productive. But don't take our word for it, run through the tutorial and give it a try. Author: Nicholas Hurley| Date: 01-01-2002 | Size: 1536 KB
	-

	dbSaint  License: Freeware
	dbSaint is a powerful application development and DBA tool built around an advanced SQL and PL/SQL editor. Using dbSaint, developers can build, test and tune SQL statements. The powerful. PL/SQL developer module helps quick and easy development of packages, procedures, triggers, and functions. The schema browser module allows you to quickly view and edit all aspects of your database objects. You can create and edit many database objects using a very powerful and intuitive graphical interphase (Tables, Views, Indexes, Constraints, Triggers, Users, Roles just to mention a few). dbSaint lets you view the Oracle Dictionary, tables, indexes, stored procedures, and more- all through a multi-tabbed browser. Code can be created from shortcuts and code templates. You can also create your own code templates. dbSaint SQL Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view, edit and save Database data. You can download, install and get started with dbSaint in less than 5 to 10 minutes! Our intuitive GUI developed by actual Developers and DBAs according to industry standards means your learning curve is practically zero!. Due to ultra compact design/codebase dbSaint has a small footprint and is very efficient in resource consumption. dbSaint provides hundreds of features for the developer and DBAs. For example with DbSaint you can: Create, browse, or alter objects using powerful GUI. Build, execute and tune queries. Create and Edit PL/SQL stored programs (packages, procedures, functions, triggers and Types). Manage your common database tasks from one central window. Find and fix database problems with constraints, triggers, extents, indexes, and grants. Compare files using DbSaint's compare files feature. Manage database sessions etc. Author: Saint Technologies Corp.| Date: 20-09-2004 | Size: 7812 KB
	-

	Shop-Script FREE  License: Freeware
	Free comprehensive PHP shopping cart software Shop-Script FREE. Our turnkey ecommerce solution is search engine friendly, comes in 100% open source, Smarty template design based, can be installed in 5 minutes, works on most operating systems and provides many facilities including: No programming required, Multi-database compatible: MySQL, MS SQL Server, Interbase, Easy-to-use web-based control panel, User friendly front-end, 100% template based design (Smarty), Multi-language support, Easy design integration to an existing web-site, Products and categories thumbnails, CSS-compatible design, Front-end homepage, Auxiliary information pages, Support for dynamic images, Unlimited number of product categories, Unlimited number of products, Hierarchical category tree, Product stock level control, HTML descriptions, Three types of product images, List price markdowns, Customers' products ratings, Special offers (marketing tools), Enable/disable products, Category HTML description and thumbnail, Shopping cart, Shopping cart feature can be turned off, thus giving you an ability to create an online web catalog, Basic ordering system, All orders are stored in the database, E-mail notifications, Search engine optimized, Outlined product info (headings, ALTs, etc). PLUS free customer support and free access to product updates! Author: WebAsyst, LLC| Date: 21-10-2004 | Size: 463 KB
	-

	Component Conversion Utility  License: Freeware
	The CCU is designed to minimize the time needed to create skeleton code in a variety of languages. It allows users to define objects in a friendly GUI or to import code from a text/binary file or a database. Once components have been created or imported, the CCU can output many flavors of source code. The app is perfect for n-tier development in which coders are generally forced to redefine objects in several languages (SQL, HTML/JavaScript, Java, etc.). Beyond just creating table definitions, forms and accessor/mutator methods (respectively), the CCU propagates validation code across several languages. Use the CCU to define basic constraints (String length, number range/precision, regular expressions, etc.) and the appropriate check constraints, JavaScript validation and exception handling code (respectively) will be created. The CCU is also useful for creating backwards compatible or cross-platform versions of code. A handy SQL script, for instance, might have different syntax for various databases. Instead of managing multiple scripts, updates can be made in one place and multiple versions of the code will be output automatically. Of course, it is impossible to do perfect translation of certain algorithms or concepts. It's much easier to debug CCU output than to rewrite something from scratch, though. The app will remember which of its guesses you wish to override. This means that when you make a slight update to your code, you won't need to re-address any of your previous output customizations. And when new languages are released, you can be reasonably sure that new versions of the CCU will allow you to extrapolate from your legacy code. If you're developing an app server or a proprietary language, contact JShift ([email protected]) for licensing information. It's much easier to sell a product if prospective customers have a way to port their existing code. JShift developers can create plug-ins for new languages in as little as a few months. Author: Hollis Waite| Date: 25-07-2003 | Size: 2415 KB
	-

	sqlDESKTOP  License: Freeware
	sqlDESKTOP is a computerized manual filing system arranged just like an office. Users can organize information (files, data on CD ROM or DVD, WEB pages, emails, newsgroups etc... ) they access regularly using familiar, everyday office supplies (folders, binders, filing cabinets, etc.). It's easy because you don't have to remember the exact name of the document or where you put it. Just visually locate it in an ordinary office environment. Author: P.I.M.| Date: 04-03-2003 | Size: 19401 KB
	-

	DbControl  License: Freeware
	With DbControl.dll (Intelligent DataSource .Net Componenet) And DbControl Form Wizard Generate Advance Data Form in C# or Vb.Net And SQLServer ,Oracle ,Accesss DataBase Without writing any code. The type of DBControl is data source, So you can bind any control which has data binding properties to it. For example you can bind controls such as TextBox,CheckBox, ListBox, ComboBox, DataGrid… to DBControl. Also, DBControl has a powerful wizard which name is "DBControl Form Wizard" that covers all steps for generating .ready to run forms without writing any line of code - DBControl Features: 1-Inserting, updating and deleting records in two ways: Single update or Batch update. 2- Navigating Records, using these shortcuts on the keyboard: - Up arrow : previous record - Down arrow : next record - Page up : previous 20th record - Page down : next 20th record - Ctrl-Down arrow : last record - Ctrl-up arrow : first record 3- Automatically diagnosing primary key fields and also checking values of those fields to be unique at data entry or update time. 4- Automatically diagnosing Not Null fields. 5 - The facility of searching field values in "Query by Form" order, just like ORACLE environment. By using F11 key, values of fields will be empty. Then after setting one or many of search parameters, and pressing F12 key or CTRL+F12(inverse query), search result will be filtered within data on the form form. 7- Automatically setting maximum permissive Field length, refer to defined field data types in table. 8- Automatically checking range of numeric fields. 9- The facility of duplicating values of current record to create a new record. 10 - Automatically identifying numeric and characteristic fields and setting limitations for numeric fields at data entry and update time. 11- The ability of settling Access rights, refer to user qualifications and determining Add, delete or update. - … And over a 50 useful property, Method and Event Author: vbiran| Date: 25-11-2004 | Size: 1247 KB
	-

	Free SQL Compare  License: Freeware
	The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them. You can compare databases online or you can take snapshots of the structure of the databases and compare them off-line, which is ideal for when you have a regularly update database and want to check if the all the changes to the database were committed successfully. Author: StarInix Software| Date: 30-11-2004 | Size: 435 KB
	-

	ATAF-CON  License: Freeware
	ATAF can automatic convert the database design and copy the data from a MS-Access database and create it on a mySQL server in one of the 4 following ways Manually script, you have to run the script on your ISP web server ( for this you can use ATAF) If you are connected to the same network as your mySQL server, you can convert the database design directly to the mySQL server, and then copy the all the database records afterwards If you Author: Christian C. Rasmussen| Date: 01-06-2002 | Size: 6550 KB
	-

	DB3NF - Rapid Web Application Development platform (RAD)  License: Freeware
	DB3NF is a Rapid Web Application Development platform (RAD) designed for fast and easy creation of high performance, maintainable and scalable Web applications of virtually any kind. It also dramatically reduces development and QA time and provides a consistent look and feel throughout the application. Author: Interapple, Inc| Date: 25-02-2002 | Size: 1581 KB
	-

	Ariacom Business Reports  License: Freeware
	Ariacom Business Reports is a database reporting and multi-dimensional analysis tool with dynamic SQL generation. Non-technical end-users can run and edit complex reports from any SQL relational database. The product is able to meet a whole range of reporting requirements, from publishing a directory over the intranet to multi-dimensional analysis on a data-warehouse. The product's main features are: - Dynamic and optimized SQL queries - Generation of complex reports integrating pivot tables - Native line, bar, point and pie charts - Integrated security management limiting user access - Fully multilingual design (currently in English, French, German, Spanish) - Report results in various formats (html, csv, txt, xml with conversion to pdf) - Output to various devices (file, printer, fax, email, ftp) - Cascade reports allowing multi-dimensional navigation - Publication and sharing of reports and results - Simple to install and configure - ActiveX to be integrated into any Win32 applications Functions limited in the free version: Report Scheduler, Web Report Server, Drill navigation, Running totals, Ranking, Formulas, Custom Templates Author: Ariacom| Date: 14-07-2004 | Size: 6439 KB
	-

	Code Library for .NET (SQL Server/MSDE)  License: Freeware
	The CodeLib is an application that helps you to easily find and use the code snippets. As a result, you can build a programs faster. Support Code Snippet, File, Note, Web, Picture save. 5 in 1 Utility. Author: fish| Date: 13-08-2004 | Size: 1390 KB
	-

	MyGeneration  License: Freeware
	MyGeneration is an extremely flexible development tool written in Microsoft .NET. MyGeneration generates code from templates that can be written in C#, VB.NET, JScript, and VBScript. MyGeneration is great at generating ORM architectures or O/R Mapping files for architectures such as Gentle.NET, NHibernate, and others. The meta-data from your database is made available to your templates through the MyMeta API. MyGeneration supports Microsoft SQL, Oracle, IBM DB2, MySQL, PostgreSQL, Microsoft Access, FireBird, Interbase, SQLite and VistaDB. MyGeneration also ships with a very popular .NET architecture available in C# and VB.NET known as dOOdads Author: MyGeneration Software| Date: 01-12-2004 | Size: 1496 KB
	-

	ODBscript  License: Freeware
	ODBscript is the world's easiest scripting language for developing interactive, database-enabled Websites, even for non-programmers. Fast application development also makes it ideal for Rapid Prototyping. Runs as a CGI (or offline) to process HTML files with embedded script programming. Uses ANSI SQL through ODBC. (Works with MS-Access, SQL Server, MySQL, Paradox, FoxPro, or any database with an ODBC driver.) A registered version is available with more functionality, and an ISAPI version is available for improved efficiency. Author: ODBscript| Date: 03-12-2004 | Size: 228 KB
	-

	AzDGDatingLite  License: Freeware
	AzDGDatingLite is a Free dating script working on PHP and MySQL. Multilanguage, 35 registering fields, 3 photos, quick/simple search, feedback with webmaster, who is online, statistics, Very customizable (Can add new genders (man, woman, couple), categories (seeking for and more), securely working on sessions (temporary cookies) and more... Author: AzDG| Date: 20-07-2004 | Size: 644 KB
	-

| 1 | 2 |