Best ddl software for free download

Apex SQL Script converts databases to scripts, .net exe's and deployment packages. Apex SQL Script creates insert scripts from any Microsoft SQL Server database that can be archived, emailed, checked into source control, run against another database etc. Apex SQL Script handles Identity fields and Apex SQL Script can auto-sequence the scripting order of tables to avoid referential integrity violations even when re-loading an entire database. Apex SQL Script integrates with a variety of source control systems including Visual Source Safe, Source Gear Vault and Microsoft Team System as well as others

Related software: sql, script, package, deployment, database, source, control, integration, tools, tool, scripting, scripts, inserts, structure, ddl, server, sql script, sql package, sql deployment, database deployment, source control integration, sql tools, sql tool, sql scripting, database scripts, sql server, …

Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures from within the database itself (cross-dependencies) and also from client applications (like a VS.NET project). References are created using proprietary technology that doesn't rely on SQL system tables. Apex SQL Clean includes a powerful visual Dependency viewer that converts database dependies into a graphical display. Apex SQL Clean will analyze a client whether it be VB, ASP, Delphi etc to determine what SQL objects are actually being used and what objects aren't. It will also analyze the database itself to see what internal references exist among SQL objects. Based on the Apex SQL Clean analysis it will generate a file of SQL drop statements to Clean your database of these useless objects. Features - Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies - Interface shows Object dependencies and objects with dependencies to it. - Graphical display of number of unreferenced objects. - DDL script for object colorizes referenced object names to allow you to visual spot the dependencies. - Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .cs, .vb, .frm, .aspx, .pas, .cls) - The file processing engine is recursive - simply point to a directory and it will search all subdirectories for files that match the search pattern you create. - Automatic drop statement creation. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references. - Double clicking on any object will script it. - Interface supports grouping/ungrouping by object type.

Related software: sql, tools, tool, unreferenced, objects, unused, dependencies, visual, diagram, dependency, viewer, risk, free, delete, sql tools, sql tool, unreferenced objects, unused objects, visual diagram, dependency viewer, risk free delete, …

DBScribe is a SQL Server sql documentation tool that creates precise technical documentation of every detail of a database schema in just seconds.

It supports:
- a rich set of documentation style and output formats (HTML, CHM, MS Word Document)
- wizard and command line interfaces
- complete database structure documenting
- all SQL object types, their details and properties
- custom documentation profile
- DDL code for all objects documented

DBScribe helps you to:
- Dramatically reduce time and cost necessary to document your databases
- Avoid document updating and synchronization after database changes
- Manage your product/solution knowledgebase
- Optimize communication between your IT team members: database administrators, developers, testers and technical writers
- Increase your customer satisfaction by providing comprehensive, professional looking database documentation

Related software: sql, server, documentation, tool, documenting, database, schema, documenter, documentor, sql server sql documentation tool, documenting database schema sql server, sql server documentation tool, sql server database documenter, sql server db documenter, sql server database documentor, …

DBScribe is an Oracle SQL documentor that creates precise technical documentation of every detail of a database schema in just seconds.

The product supports:
- a rich set of documentation style and output formats (HTML, CHM, MS Word Document)
- wizard and command line interfaces
- complete database structure documenting
- all SQL object types, their details and properties
- custom documentation profiles
- Oracle OLAP Metadata documenting
- DDL code for all objects documented

DBScribe helps you to:
- Dramatically reduce time and cost necessary to document your databases
- Avoid document updating and synchronization after database changes
- Manage your product/solution knowledgebase
- Optimize communication between your IT team members: database administrators, developers, testers and technical writers
- Increase your customer satisfaction by providing comprehensive, professional looking database documentation

Related software: oracle, database, documentation, tool, sql, documentor, documenting, schema, documenter, oracle database documentation tool, oracle sql documentor, documenting oracle database schema, oracle documentation tool, oracle database documenter, oracle db documenter, oracle database documentor, …

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Key Features:

- Full support of SQL Server 2005;
- New state-of-the-art graphical user interface;
- Rapid database management and navigation;
- Easy management of all SQL Server objects;
- Advanced data manipulation tools;
- Effective security management;
- Excellent visual and text tools for query building;
- Impressive data export and import abilities;
- Easy-to-use wizards performing SQL Server administrative tasks.

Related software: ems, sql, manager, server, mssql, msde, sqlmanager, gui, 2005, database, admin, development, query, builder, client, report, designer, export, import, tool, microsoft, explorer, browser, administration, generator, data, editor, hitech, msmanager, windows, …

Database Administrators, rejoice! Business owners and IT managers, take a note! Now there is no need to compare and synchronize databases run by MySQL manually, wasting valuable and quite expensive DBA’s time. SQLBalance compares different databases, highlights the differences and synchronizes them (if necessary) automatically. The program analyzes database contents line by line, object by object, searching for differences in database structure or contents. When any are found, they are highlighted. The information about distinct objects is displayed in the form of table and as a DDL script, so understanding the differences is very easy (two panels, all database entries are side by side). Then, the databases are synchronized. There are two ways to do it – object by object, which takes more time, but gives the administrator more control, or the entire database synchronization (with one mouse click via generated DDL script). The log of all changes is kept, so the administrator can always go back and look how the database was changed. SQLBalance requires very low system resources and disk space, yet runs so fast that it seems to break the speed of light barrier. And at 70 dollars per copy, this is the software that actually pays for itself and saves companies money, because the average pay for a Database Administrator in 2003 in the United States was $28.53 an hour.

Related software: database, tools, mysql, sql, schema, difference, tool, preprocessor, ide, developemnt, environment, management, editor, parser, utility, database tools, mysql tools, schema difference, sql preprocessor, database schema, developemnt environment, schema management, sql editor, sql parser, database utility, …

Abilities of the SQLaps SQL Assistant for Oracle:
1) Supports the Oracle Server version - 8i/9i and 10g support HAS BEEN ADDED!
2) SQL Editor allows execute SQL statements in the separated threads (parallel execution of the long-time queries), scripts and PL/SQL blocks,preview the explain plan, export data to text and SQL*Loader control files, use the code completion and queries history for
quick return to the earlier executed statements.
3) Extract DDL Wizard allows to extract schema objects and generate SQL script for these objects.
4) Management of the Schemas,Functions,Procedures,Packages,simple and partitioned Tables,Indexes,Constraints,Views,
Triggers.
5) Security management (Creating and management roles and profiles, grant and revokes privileges.
Creating and management the users accounts, the checking and recompile the invalid objects).
6) Sessions management, SQL monitoring, start/stop sessions tracing, and show results.
7) Management of the Redologs and Tablespaces. (Creating and checking redogroups,redologs files, management tablespaces,
management and resizing datafiles)
8) Improved, useful and fast interface for the Oracle Logminer (view/run stored statements for the executed
transactions (redo- and archivelogs)), no additional installations require. (Simple and fast analyze of the redo/archivelogs).
9) Preview/save the images into the BLOB/CLOB fields from clipboard.

You can download 15-days trial version of S.Q.Lap's SQL Assistant from links at

http://sqlap.fortunecity.com/

You can find the detail description of application in the users manual (sqlapmanual.doc in the ZIP-archive). Latest version has improvement DBExplorer, Extract Wizard, allows manage FK-ref tables etc.

Please write your questions, suggestions and all contacts to bootstrap@rambler.ru
Thanks,
The SQLap's SQL Assistant
Developers team.


Related software: oracle, management, development, tool, utility, low, cost, database, sql, assistant, logminer, low cost, …

If you use the open source Firebird SQL database, you need this utility! FMS makes migrating changes from one database to another a snap. No loss of data. Quick and easy to use. Compatible with Firebird & Interbase databases, including Firebird v2, FMS let's you create a development database, and easily migrate it to your test server. Or migrate your test database to production. It focuses on migrating just the DDL changes so that your data is left intact. This is a must have utility for any developer who uses Firebird or Interbase SQL databases.

Related software: firebird, sql, database, utility, migrate, delphi, developer, …

Welcome to the ObjectMapper .NET project - an impressive open source project for object persistence, proven in real-world projects. Object relational mappers aim to bridge the gap between object oriented programming and relational database models. The ObjectMapper .NET offers state-of-the-art object mapping functionality, yet it also provides advanced features that set it apart from other o/r mappers.

Tailored to achieve maximum performance and development ease-of-use this technology will give developers the ability to build business components with unprecedented productivity and optimal runtime performance.

The entity model drives the database layout, thus enabling real model driven development.

The business entity model can be designed using the CASE tool of your choice - it may even be designed by business analysts rather than classical developers. The entities and their properties may then be decorated with declarative attributes - either within the CASE tool or within the generated C# code. These attributes may tell the ObjectMapper .NET simple things, such as the length of a text field, or they may provide more complex information, or to allow fields to be picked from another table. In many cases the default behaviour will suffice - reducing the amount of work efficiently.

The ObjectMapper .NET - and this is really a great part, will use the meta information of the model to create a DDL file to create the database - including all constraints. It also supports database versioning.
No need to maintain a separate DDL. No need to manually synchronize properties and database table columns. All contained in one single source, thus eliminating maintenance hurdles and a whole class of error conditions.


Related software: net, mapper, objectmapper, adfactum, object, sql, framework, query, api, localization, persistence, integrated, mechanism, stateless, extracts, possible, provides, stateful, supports, paging, grids, dbms, main, that, with, all, ddl, for, web, …

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Key Features:

- Full support of SQL Server 2005;
- New state-of-the-art graphical user interface;
- Rapid database management and navigation;
- Easy management of all SQL Server objects;
- Advanced data manipulation tools;
- Effective security management;
- Excellent visual and text tools for query building;
- Impressive data export and import abilities;
- Easy-to-use wizards performing SQL Server administrative tasks.

Related software: ems, sql, manager, server, mssql, msde, sqlmanager, gui, 2005, database, admin, development, query, builder, client, report, designer, export, import, tool, microsoft, explorer, browser, administration, generator, data, editor, hitech, msmanager, windows, …

Single file Delphi database with comprehensive SQL support, strong encryption,BLOBs and multiuser mode support. This BDE alternative is fully compatible withstandard and third-party database components and reporting engines. Absolute DBdoes not require any DLLs, drivers or Windows updates. It compiles right into EXEfile and works on any version of Windows from 98 to Vista. Absolute DB is writtencompletely in Delphi, full source code is available. Absolute DB is a great BDEreplacement.Key Features: No BDE; no DLLs; SQL'92 (DDL & DML) support; Single-user andmulti-user mode (file-server); Single database file; Unmatched ease-of-use; 100%compatibility with standard and third-party DB-aware controls; Strong encryption;BLOB compression; Full source code available; Royalty-free; Free for personal use;Ease of Deployment; No BDE, no DLLs; No special installation or configurationrequired; Database engine compiles right into EXE; Single-file database format;High Speed; Advanced cache management and buffering architecture; SophisticatedSQL query and filter optimizer; Special optimized database engine for temporaryresults of SQL queries; Fast B*-Tree indexes with high-speed on thousands and onmillions of records; Buffered transactions for batch inserts, updates and deletes;Optimization for read-only databases, such as databases on CD; SQL support; SELECTwith DISTINCT, INNER LEFT, RIGHT, FULL and OUTER JOIN, GROUP BY and ORDER BYclauses; CREATE TABLE, DROP TABLE, ALTER TABLE statements; CREATE INDEX, DROPINDEX statements; INSERT, UPDATE, DELETE statements; BETWEEN, IN, LIKE, IS NULLoperators; Aggregate functions; Data types conversion by function CAST; SQLscripts; Parameters in queries; Small size of code added into the application bythe database engine units; Small database file size achieved by customizable pagesize, compression of table metadata and other special means; Fast BLOB datacompression; Low memory consumption.

Related software: database, delphi, component, bde, alternative, replacement, single, file, database delphi, delphi database, database component, bde alternative, bde replacement, single file database, …

SQLMemTable is a fast and easy-to-use in-memory table and query components library for Delphi and C++ Builder. It does not require BDE and provides all the TTable functions such as master / detail relationship, filtering, searching, sorting, blob fields, key and range methods, as well as some advanced features like blob fields compression and Unicode support. SQLMemTable provides the following services: SQL (DML & DDL) commands support; Referential Integrity support (foreign keys); BatchMove component; master / detail relationship; creating, renaming, emptying, deleting and restructuring tables; creating, editing, deleting, browsing and searching for records; creating and deleting multiple indexes; calculated and lookup fields; filtering support; BLOB fields compression; Multi-thread access; importing from and exporting to any dataset in fast and easy way; internationalization / localization and Unicode support. SQLMemTable is a fully functional in-memory database system; it includes table and query components as well as useful utility (with source code), demos and comprehensive help. SQLMemTable does not require BDE or any external drivers and has small footprint.

Related software: memory, table, database, sql, query, bde, alternative, replacement, delphi, c++, builder, cpp, kylix, engine, in-memory, …

Query Master is a fast multi-threaded SQL and PL/SQL tool with a script library and an advanced grid for developers and database administrators. Features: script library; SQL and PL/SQL editor; single, multiple and for update statement execution; bind variables; describe objects; powerful grid; SQL statement execution plan; popup window with database objects; script import; transaction queue; oracle home selector; DDL generator, DB object browser.


Related software: sql, pl/sql, oracle, development, tool, developer, dba, database, administrator, free, editor, script, library, scripts, import, execution, plan, bind, variable, alma, opr, project, export, report, download, script library, script import, execution plan, bind variable, it alma, sql editor, sql tool, download pl sql, …

Accuracer is a compact, embedded, single-file, multi-user (file-server and client/server) cross-platform BDE replacement database with SQL support based on a new original BDE alternative database engine that supports the almost all TTable, TQuery, TDatabase, TSession, TBatchMove functions and provides some special ones to give you wide functionality and ease of use. Key features: Multi-user (both Client-Server and File-Server); Multi-thread access; Storing all tables inside the single database file; No BDE, no DLLs; SQL'92 (DML & DDL) support; Fully compatible with standard DB-aware controls; IProvider Support (ClientDataset); Small footprint and low memory usage; In-Memory tables support for the fastest data access; Varchar and BLOB field types with optional data compression; Referential Integrity support (SQL'99 compliance); Strong encryption with wide variety of algorithms and modes; Transactions support with READ COMMITTED isolation level; BatchMove component; Reverse engineering (tables to SQL script export); Backup and Restore database support; Capability of database embedding inside the executable file; ODBC Driver available; No royalties; Full source code available; Windows / Linux cross-platform database engine; Unmatched ease-of-use, comprehensive help, lots of demos and utilities with source code for Delphi/C++Builder and Kylix; No royalties; Full source code available. Accuracer is currently available for the Borland Delphi / C++Builder and Kylix development environments in Single-User (SU), Multi-User (MU), and Client/Server (CS) versions with full source code (Pro) or without one (Std).

Related software: bde, replacement, alternative, delphi, embedded, database, c++, builder, cpp, kylix, engine, multi, user, client/server, single, file, windows, linux, cross, platform, dbms, multi-user, single-file, cross-platform, …

Sync Database is an easy solution to compare and sync MySQL databases. Structure differences are quickly determined and displayed, you can review and modify sync actions, as well as generated SQL script. Sync Database synchronizes column, index, constraint information. Conversion between table types is supported as well.

Related software: mysql, database, synchronization, schema, ddl, versions, versioning, …

Absolute Database - Delphi database system. This BDE alternative is free for personal use. Key Features: No BDE; no DLLs; SQL'92 (DDL & DML) support; Single-user and mutli-user mode (file-server); Single database file; Unmatched ease-of-use; 100% compatibility with standard DB-aware controls; Strong encryption; BLOB compression; Full source code available; Royalty-free; Free for personal use; Ease of Deployment; No BDE, no DLLs; No special installation or configuration required; Database engine compiles right into EXE; Single-file database format; High Speed; Advanced cache management and buffering architecture; Sophisticated SQL query and filter optimizer; Special optimized database engine for temporary results of SQL queries; Fast B*-Tree indexes with high-speed on thousands and on millions of records; Buffered transactions for batch inserts, updates and deletes; Optimization for read-only databases, such as databases on CD; SQL support; SELECT with DISTINCT, INNER LEFT, RIGTH, FULL and OUTER JOIN, GROUP BY and ORDER BY clauses; CREATE TABLE, DROP TABLE, ALTER TABLE statements; CREATE INDEX, DROP INDEX statements; INSERT, UPDATE, DELETE statements; BETWEEN, IN, LIKE, IS NULL operators; Aggregate functions COUNT,SUM,MIN,MAX,AVG; Most of all SQL'92 arithmetic, logical, date-time and string functions and operators; Data types conversion by function CAST; SQL scripts (multiple commands separated by ';'); Parameters in queries; Compactness; Small size of code added into the application by the database engine units; Small database file size achieved by customizable page size, compression of table metadata and other special means; Fast BLOB data compression; Short indexes for string fields; Low memory consumption

Related software: database, delphi, component, bde, alternative, replacement, database delphi, delphi database, database component, bde alternative, bde replacement, …