SQL management Software Downloads, Free SQL management Software Downloads

Home
Search Software:Search
    SQL management in Name
  • Navicat Essentials for SQL Server (Mac OS X) - SQL Server GUI tool - MS SQL management
    Navicat Essentials for SQL Server (Mac OS X) - SQL Server GUI tool - MS SQL management

    Navicat is an ideal solution for SQL Server administration and development. Navicat Essentials for SQL Server works with SQL Server 2000, 2005, 2008R2 and SQL Azure, and supports most of the latest features including Trigger, Function, View and others. It also comes with the import/export tools that assist you import/export txt and xml files to/from your SQL Server databases. Latest SQL Server Versions Support * Only available for two platforms - Microsoft Windows and Mac OS X. Support SQL Server 2000 or above. Support SQL Azure. Support all SQL Server objects: tables, views and functions. Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers. Managing linked servers, server triggers. Managing assemblies, partition functions, partition schemes and database triggers. Managing indexes, synonyms and triggers. Support of character set and unicode. If you are looking for supporting various file formats in Import and Export together with other advanced features like Data Modeling, Visual SQL Builder, Data Transfer, Data and Structure Synchronization, Backup and Batch Job Scheduling. Navicat for SQL Server Enterprise edition is your solution. Navicat is the number 1 MySQL database administration shareware in Download.com with over 2,000,000 downloads.Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson, Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ...Navicat delivers a personal experience, simplifying the way you work.

    Size: Download
  • Navicat Essentials for SQL Server (Windows) - SQL Server GUI tool - MS SQL management
    Navicat Essentials for SQL Server (Windows) - SQL Server GUI tool - MS SQL management

    Navicat is an ideal solution for SQL Server administration and development. Navicat Essentials for SQL Server works with SQL Server 2000, 2005, 2008R2 and SQL Azure, and supports most of the latest features including Trigger, Function, View and others. It also comes with the import/export tools that assist you import/export txt and xml files to/from your SQL Server databases. <br/> Latest SQL Server Versions Support * Only available for two platforms - Microsoft Windows and Mac OS X. Support SQL Server 2000 or above. Support SQL Azure. Support all SQL Server objects: tables, views and functions. Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers. Managing linked servers, server triggers. Managing assemblies, partition functions, partition schemes and database triggers. Managing indexes, synonyms and triggers. Support of character set and unicode. If you are looking for supporting various file formats in Import and Export together with other advanced features like Data Modeling, Visual SQL Builder, Data Transfer, Data and Structure Synchronization, Backup and Batch Job Scheduling. Navicat for SQL Server Enterprise edition is your solution. Navicat is the number 1 MySQL database administration shareware in Download.com with over 2,000,000 downloads.Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson, Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ...Navicat delivers a personal experience, simplifying the way you work.

    Size: Download
  • SQL Pretty Printer Add-In for SQL Server Management Studio
    SQL Pretty Printer Add-In for SQL Server Management Studio

    SQL Pretty Printer Add-In for SQL Server Management is a plugin to beautify sql code inside SQL Server Management Studio. Features * Format SQL inside SQL Server Management Studio with just one mouse click. * Convert SQL to C#, VB and vice versa quickly. * Convert monochrome sql code into colorful HTML, easy to put it into blogs and forums. * Able to customize color of different SQL element such as Idenfier,Operator and Number etc. * More than 60 format options and still growing. * Batch file convert on the fly. * Command line api can be used in your own program.

    Size: Download
  • Navicat - The World's best SQL Server GUI tool - MS SQL management
    Navicat - The World's best SQL Server GUI tool - MS SQL management

    Navicat is an ideal solution for SQL Server administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports Microsoft SQL Server (2000 to 2008R2) and let you converts Access to MS SQL, MS SQL to MySQL, Excel to MS SQL, synchronizes and backups database in a snap through helpful wizards. Major features include Data Modeling Tool, SQL/DDL Script Generation, Database Wide Search, SQL Code Minifier, Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries), printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges. With Navicat Data Modeling Tool, it allows user to create graphical representations of a relational database. The Reverse Engineer in Navicat Data Modeling Tool allows user to create a conceptual model from an existing database and graphically visualize and edit the structure of the database. Or, user can graphically create a conceptual model, and generate a database that supports the model. Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson, Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ...Navicat delivers a personal experience, simplifying the way you work. The program is available for Windows and Mac OS X and supports multiple languages.

    Size: Download
  • EMS SQL Management Studio for SQL Server
    EMS SQL Management Studio for SQL Server

    A complete solution for database administration and development EMS SQL Management Studio is a complete solution for database administration and development. With components that focus on all critical database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering databases and managing database objects as well as for database migration, extraction, data import, export and comparison. SQL Studio unites these tools in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, EMS SQL Management Studio offers all essential tools to make you more productive than ever before! SQL Studio Additional Features: - Handy launch of utilities and services - Storing all templates in a single repository - Common data source list for all services and utilities - Creating complicated tasks and scheduled tasks execution - Ability to run external applications from scheduler - Storing all task execution logs in one database - Creating customized notifications with a variety of delivery options - Ability to set visual interface style uniquely for all SQL Studio apps - Fast access to EMS Technical Support Service

    Size: Download
  • SQL Management Studio for SQL Server
    Size: Download
  • SQL Management Console
    Size: Download
  • BASIC SQL Management
    Size: Download
    SQL management in Tags
  • SQLAlchemy
    SQLAlchemy

    A SQL toolkit and object relational mapper for Python. SQLAlchemy is a SQL toolkit and object relational mapper for Python.The Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.- extremely easy to use for all the basic tasks, such as: accessing thread-safe and pooled connections, constructing SQL from Python expressions, finding object instances, and commiting object modifications back to the database. - powerful enough for complicated tasks, such as: eager load a graph of objects and their dependencies via joins; map recursive adjacency structures automatically; map objects to not just tables but to any arbitrary join or select statement; combine multiple tables together to load whole sets of otherwise unrelated objects from a single result set; commit entire graphs of object changes in one step.- built to conform to what DBAs demand, including the ability to swap out generated SQL with hand-optimized statements, full usage of bind parameters for all literal values, fully transactionalized and consistent updates using Unit of Work. - modular. Different parts of SQLAlchemy can be used independently of the rest, including the connection pool, SQL construction, and ORM. SQLAlchemy is constructed in an open style that allows plenty of customization, with an architecture that supports custom datatypes, custom SQL extensions, and ORM plugins which can augment or extend mapping functionality.SQLAlchemy's Philosophy:- SQL databases behave less and less like object collections the more size and performance start to matter; object collections behave less and less like tables and rows the more abstraction starts to matter. SQLAlchemy aims to accomodate both of these principles.- Your classes aren't tables, and your objects aren't rows. Databases aren't just collections of tables; they're relational algebra engines. You don't have to select from just tables, you can select from joins, subqueries, and unions. Database and domain concepts should be visibly decoupled from the beginning, allowing both sides to develop to their full potential.- For example, table metadata (objects that describe tables) are declared distinctly from the classes theyre designed to store. That way database relationship concepts don't interfere with your object design concepts, and vice-versa; the transition from table-mapping to selectable-mapping is seamless; a class can be mapped against the database in more than one way. SQLAlchemy provides a powerful mapping layer that can work as automatically or as manually as you choose, determining relationships based on foreign keys or letting you define the join conditions explicitly, to bridge the gap between database and domain.SQLAlchemy's Advantages:- The Unit Of Work system organizes pending CRUD operations into queues and commits them all in one batch. It then performs a topological "dependency sort" of all items to be committed and deleted and groups redundant statements together. This produces the maxiumum efficiency and transaction safety, and minimizes chances of deadlocks. Modeled after Fowler's "Unit of Work" pattern as well as Java Hibernate.- Function-based query construction allows boolean expressions, operators, functions, table aliases, selectable subqueries, create/update/insert/delete queries, correlated updates, correlated EXISTS clauses, UNION clauses, inner and outer joins, bind parameters, free mixing of literal text within expressions, as little or as much as desired. Query-compilation is vendor-specific; the same query object can be compiled into any number of resulting SQL strings depending on its compilation algorithm. - Database mapping and class design are totally separate. Persisted objects have no subclassing requirement (other than 'object') and are POPO's : plain old Python objects. They retain serializability (pickling) for usage in various caching systems and session objects. SQLAlchemy "decorates" classes with non-intrusive property accessors to automatically log object creates and modifications with the UnitOfWork engine, to lazyload related data, as well as to track attribute change histories.- Custom list classes can be used with eagerly or lazily loaded child object lists, allowing rich relationships to be created on the fly as SQLAlchemy appends child objects to an object attribute.- Composite (multiple-column) primary keys are supported, as are "association" objects that represent the middle of a "many-to-many" relationship.- Self-referential tables and mappers are supported. Adjacency list structures can be created, saved, and deleted with proper cascading, with no extra programming. - Data mapping can be used in a row-based manner. Any bizarre hyper-optimized query that you or your DBA can cook up, you can run in SQLAlchemy, and as long as it returns the expected columns within a rowset, you can get your objects from it. For a rowset that contains more than one kind of object per row, multiple mappers can be chained together to return multiple object instance lists from a single database round trip. - The type system allows pre- and post- processing of data, both at the bind parameter and the result set level. User-defined types can be freely mixed with built-in types. Generic types as well as SQL-specific types are available. Requirements: · Python What's New in This Release: [ read full changelog ] · new features · general · Documentation has been converted to Sphinx. In particular, the generated API documentation has been constructed into a full blown "API Reference" section which organizes editorial documentation combined with generated docstrings. Cross linking between sections and API docs are vastly improved, a javascript-powered search feature is provided, and a full index of all classes, functions and members is provided. · setup.py now imports setuptools only optionally. If not present, distutils is used. The new "pip" installer is recommended over easy_install as it installs in a more simplified way. · added an extremely basic illustration of a PostGIS integration to the examples folder. · orm · Query.with_polymorphic() now accepts a third argument "discriminator" which will replace the value of mapper.polymorphic_on for that query. Mappers themselves no longer require polymorphic_on to be set, even if the mapper has a polymorphic_identity. When not set, the mapper will load non-polymorphically by default. Together, these two features allow a non-polymorphic concrete inheritance setup to use polymorphic loading on a per-query basis, since concrete setups are prone to many issues when used polymorphically in all cases. · dynamic_loader accepts a query_class= to customize the Query classes used for both the dynamic collection and the queries built from it. · query.order_by() accepts None which will remove any pending order_by state from the query, as well as cancel out any mapper/relation configured ordering. This is primarily useful for overriding the ordering specified on a dynamic_loader(). [ticket:1079] · sql · RowProxy objects can be used in place of dictionary arguments sent to connection.execute() and friends. [ticket:935] · dialect · Added a new description_encoding attribute on the dialect that is used for encoding the column name when processing the metadata. This usually defaults to utf-8. · mssql · Added in a new MSGenericBinary type. This maps to the Binary type so it can implement the specialized behavior of treating length specified types as fixed-width Binary types and non-length types as an unbound variable length Binary type. · Added in new types: MSVarBinary and MSImage. [ticket:1249] · Added in the MSReal, MSNText, MSSmallDateTime, MSTime, MSDateTimeOffset, and MSDateTime2 types · sqlite · Table reflection now stores the actual DefaultClause value for the column. [ticket:1266] · bugfixes, behavioral changes · general · orm · Exceptions raised during compile_mappers() are now preserved to provide "sticky behavior" · if a hasattr() call on a pre-compiled mapped attribute triggers a failing compile and suppresses the exception, subsequent compilation is blocked and the exception will be reiterated on the next compile() call. This issue occurs frequently when using declarative. · property.of_type() is now recognized on a single-table inheriting target, when used in the context of prop.of_type(..).any()/has(), as well as query.join(prop.of_type(...)). · query.join() raises an error when the target of the join doesn't match the property-based attribute · while it's unlikely anyone is doing this, the SQLAlchemy author was guilty of this particular loosey-goosey behavior. · Fixed bug when using weak_instance_map=False where modified events would not be intercepted for a flush(). [ticket:1272] · Fixed some deep "column correspondence" issues which could impact a Query made against a selectable containing multiple versions of the same table, as well as unions and similar which contained the same table columns in different column positions at different levels. [ticket:1268] · Custom comparator classes used in conjunction with column_property(), relation() etc. can define new comparison methods on the Comparator, which will become available via __getattr__() on the InstrumentedAttribute. In the case of synonym() or comparable_property(), attributes are resolved first on the user-defined descriptor, then on the user-defined comparator. · Added ScopedSession.is_active accessor. [ticket:976] · Can pass mapped attributes and column objects as keys to query.update({}). [ticket:1262] · Mapped attributes passed to the values() of an expression level insert() or update() will use the keys of the mapped columns, not that of the mapped attribute. · Corrected problem with Query.delete() and Query.update() not working properly with bind parameters. [ticket:1242] · Query.select_from(), from_statement() ensure that the given argument is a FromClause, or Text/Select/Union, respectively. · Query() can be passed a "composite" attribute as a column expression and it will be expanded. Somewhat related to [ticket:1253]. · Query() is a little more robust when passed various column expressions such as strings, clauselists, text() constructs (which may mean it just raises an error more nicely). · first() works as expected with Query.from_statement(). · Fixed bug introduced in 0.5rc4 involving eager loading not functioning for properties which were added to a mapper post-compile using add_property() or equivalent. · Fixed bug where many-to-many relation() with viewonly=True would not correctly reference the link between secondary->remote. · Duplicate items in a list-based collection will be maintained when issuing INSERTs to a "secondary" table in a many-to-many relation. Assuming the m2m table has a unique or primary key constraint on it, this will raise the expected constraint violation instead of silently dropping the duplicate entries. Note that the old behavior remains for a one-to-many relation since collection entries in that case don't result in INSERT statements and SQLA doesn't manually police collections. [ticket:1232] · Query.add_column() can accept FromClause objects in the same manner as session.query() can. · Comparison of many-to-one relation to NULL is properly converted to IS NOT NULL based on not_(). · Extra checks added to ensure explicit primaryjoin/secondaryjoin are ClauseElement instances, to prevent more confusing errors later on. [ticket:1087] · Improved mapper() check for non-class classes. [ticket:1236] · comparator_factory argument is now documented and supported by all MapperProperty types, including column_property(), relation(), backref(), and synonym() [ticket:5051]. · Changed the name of PropertyLoader to RelationProperty, to be consistent with all the other names. PropertyLoader is still present as a synonym. · fixed "double iter()" call causing bus errors in shard API, removed errant result.close() left over from the 0.4 version. [ticket:1099] [ticket:1228] · made Session.merge cascades not trigger autoflush. Fixes merged instances getting prematurely inserted with missing values. Two fixes to help prevent out-of-band columns from being rendered in polymorphic_union inheritance scenarios (which then causes extra tables to be rendered in the FROM clause causing cartesian products): · improvements to "column adaption" for a->b->c inheritance situations to better locate columns that are related to one another via multiple levels of indirection, rather than rendering the non-adapted column. · the "polymorphic discriminator" column is only rendered for the actual mapper being queried against. The column won't be "pulled in" from a subclass or superclass mapper since it's not needed. · Fixed shard_id argument on ShardedSession.execute(). [ticket:1072] · sql · Columns can again contain percent signs within their names. [ticket:1256] · sqlalchemy.sql.expression.Function is now a public class. It can be subclassed to provide user-defined SQL functions in an imperative style, including with pre-established behaviors. The postgis.py example illustrates one usage of this. · PickleType now favors == comparison by default, if the incoming object (such as a dict) implements __eq__(). If the object does not implement __eq__() and mutable=True, a deprecation warning is raised. · Fixed the import weirdness in sqlalchemy.sql to not export __names__ [ticket:1215]. · Using the same ForeignKey object repeatedly raises an error instead of silently failing later. [ticket:1238] · Added NotImplementedError for params() method on Insert/Update/Delete constructs. These items currently don't support this functionality, which also would be a little misleading compared to values(). · Reflected foreign keys will properly locate their referenced column, even if the column was given a "key" attribute different from the reflected name. This is achieved via a new flag on ForeignKey/ForeignKeyConstraint called "link_to_name", if True means the given name is the referred-to column's name, not its assigned key. [ticket:650] · select() can accept a ClauseList as a column in the same way as a Table or other selectable and the interior expressions will be used as column elements. [ticket:1253] · the "passive" flag on session.is_modified() is correctly propagated to the attribute manager. · union() and union_all() will not whack any order_by() that has been applied to the select()s inside. If you union() a select() with order_by() (presumably to support LIMIT/OFFSET), you should also call self_group() on it to apply parenthesis. · engine/pool · Connection.invalidate() checks for closed status to avoid attribute errors. [ticket:1246] · NullPool supports reconnect on failure behavior. [ticket:1094] · Added a mutex for the initial pool creation when using pool.manage(dbapi). This prevents a minor case of "dogpile" behavior which would otherwise occur upon a heavy load startup. [ticket:799] · _execute_clauseelement() goes back to being a private method. Subclassing Connection is not needed now that ConnectionProxy is available. · documentation · Tickets [ticket:1200] [ticket:1149]. · Added note about create_session() defaults. · Added section about metadata.reflect(). · Updated `TypeDecorator` section. · Rewrote the "threadlocal" strategy section of the docs due to recent confusion over this feature. · Removed badly out of date 'polymorphic_fetch' and 'select_table' docs from inheritance, reworked the second half of "joined table inheritance". · Documented `comparator_factory` kwarg, added new doc section "Custom Comparators". · mssql · Refactored the Date/Time types. The ``smalldatetime`` data type no longer truncates to a date only, and will now be mapped to the MSSmallDateTime type. [ticket:1254] · Corrected an issue with Numerics to accept an int. · Mapped ``char_length`` to the ``LEN()`` function. · If an ``INSERT`` includes a subselect the ``INSERT`` is converted from an ``INSERT INTO VALUES`` construct to a ``INSERT INTO SELECT`` construct. · If the column is part of a ``primary_key`` it will be ``NOT NULL`` since MSSQL doesn't allow ``NULL`` in primary_key columns. · ``MSBinary`` now returns a ``BINARY`` instead of an ``IMAGE``. This is a backwards incompatible change in that ``BINARY`` is a fixed length data type whereas ``IMAGE`` is a variable length data type. [ticket:1249] · ``get_default_schema_name`` is now reflected from the database based on the user's default schema. This only works with MSSQL 2005 and later. [ticket:1258] · Added collation support through the use of a new collation argument. This is supported on the following types: char, nchar, varchar, nvarchar, text, ntext. [ticket:1248] · Changes to the connection string parameters favor DSN as the default specification for pyodbc. See the mssql.py docstring for detailed usage instructions. · Added experimental support of savepoints. It currently does not work fully with sessions. · Support for three levels of column nullability: NULL, NOT NULL, and the database's configured default. The default Column configuration (nullable=True) will now generate NULL in the DDL. Previously no specification was emitted and the database default would take effect (usually NULL, but not always). To explicitly request the database default, configure columns with nullable=None and no specification will be emitted in DDL. This is backwards incompatible behavior. [ticket:1243] · postgres · "%" signs in text() constructs are automatically escaped to "%%". Because of the backwards incompatible nature of this change, a warning is emitted if '%%' is detected in the string. [ticket:1267] · Calling alias.execute() in conjunction with server_side_cursors won't raise AttributeError. · Added Index reflection support to Postgres, using a great patch we long neglected, submitted by Ken Kuhlman. [ticket:714] · oracle · Adjusted the format of create_xid() to repair two-phase commit. We now have field reports of Oracle two-phase commit working properly with this change. · Added OracleNVarchar type, produces NVARCHAR2, and also subclasses Unicode so that convert_unicode=True by default. NVARCHAR2 reflects into this type automatically so these columns pass unicode on a reflected table with no explicit convert_unicode=True flags. [ticket:1233] · Fixed bug which was preventing out params of certain types from being received; thanks a ton to huddlej at wwu.edu ! [ticket:1265] · mysql · "%" signs in text() constructs are automatically escaped to "%%". Because of the backwards incompatible nature of this change, a warning is emitted if '%%' is detected in the string. · Fixed bug in exception raise when FK columns not present during reflection. [ticket:1241] · Fixed bug involving reflection of a remote-schema table with a foreign key ref to another table in that schema. · associationproxy · The association proxy properties are make themselves available at the class level, e.g. MyClass.aproxy. Previously this evaluated to None. · declarative · The full list of arguments accepted as string by backref() includes 'primaryjoin', 'secondaryjoin', 'secondary', 'foreign_keys', 'remote_side', 'order_by'.

    Size: Download
  • sqlcmd
    sqlcmd

    A Cross-platform, Cross-database SQL Command Line Tool sqlcmd is a Python-based SQL command line tool, similar in concept to tools like Oracle's SQL*Plus, the PostgreSQL psql command, and MySQL's mysql tool.In short, sqlcmd is a SQL command tool that attempts to provide the same interface for all supported databases and across all platforms.sqlcmd has been tested on the following platforms:* Mac OS X, version 10.4 (Tiger), using MacPython* Linux (Ubuntu, Gutsy and Hardy)* FreeBSD* Windows XP, using the non-Cygwin Windows version of Python and pyreadline Here are some key features of "sqlcmd": · Connection parameters for individual databases are kept in a configuration file in your home directory. · Databases can be assigned multiple logical names. · Command history management, with GNU Readline support. Each database has its own history file. · Supports retrieving database metadata (getting a list of tables, querying the table's columns and their data types, listing the indexes and foreign keys for a table, etc.). · Supports Unix shell-style variables. · Standard interface that works the same no matter what database you're using. · Uses the enhanced database drivers in the Grizzled API's db module. (Those drivers are, in turn, built on top of standard Python DB API drivers like psycopg2 and MySQLdb.) Supports: · MySQL (tested with MySQL 5 on Linux, Mac OS X, and FreeBSD) · Oracle (tested with Oracle Database 10g Express Edition for Linux) · PostgreSQL (tested with versions 8.1 through 8.3 on Linux and Mac OS X) · SQL Server (tested with SQL Server Express 2005, using pymssql) · SQLite (tested on Linux and Mac OS X) · You will have to install Python DB API drivers for all but SQLite. · Written entirely in Python, which makes it very portable (though the database drivers are often written in C and may not be available on all platforms). Requirements: · Python

    Size: Download
  • CSQL
    CSQL

    CSQL (Compact SQL) is a light weight, high performance main memory database system with minimal set of features. CSQL (Compact SQL) is a light weight, high performance main memory database system with minimal set of features. It gives throughput of 50K inserts/sec and 100K selects /sec.Compiling the sourceGo to the root directory and enter the following commands.$ export JDK_HOME=< path of jdk home >$ ./configure --prefix=`pwd`/install CXXFLAGS="-I$JDK_HOME/include -I$JDK_HOME/include/linux"$ make$ make install$ ./csqlinstall.kshNote:setupenv.ksh script is available at the root directory which shall be used toset the necessary environment variables.This will create "install" directory under the current directory and places all the executables created in bin directory and libraries in lib directory.Starting the ServerNote: kernel.shmmax should be set to more than 500 MB before starting the serverIn linux for setting 1GB enter$sysctl -w kernel.shmmax=1000000000You should find csqlserver executable under the bin directory of the installation.Change csql.conf file under the installation root directory if necessary.Set the CSQL_CONFIG_FILE environment variable to absolute path of csql.conf file.For example, if csql.conf is available at /tmp directory, then$export CSQL_CONFIG_FILE=/tmp/csql.confStart the server using csqlserver executable$./csqlserverThis starts the server and creates the database file.Note:Refer UserManual.pdf available in docs folder to know how to work with csqlShutting down the ServerPressing Ctrl-C on the terminal where csqlserver is running, is safe and will stop the server gracefully by removing the database file. What's New in This Release: [ read full changelog ] · Logical Undo logging for Tree Index · Auto increment key · Command history for CSQL tool · cachetable tool option to display cached table information · Bug Fixes

    Size: Download
  • StelsMDB
    StelsMDB

    A MDB JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on Microsoft Access database files. StelsMDB is a MDB JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on Microsoft Access database files (MS Access 2000, 2002, 2003, XP versions).The driver is completely platform-independent and does not require installing additional client or server software to provide access to MDB files. StelsMDB can be effectively used to create, process and export Microsoft Access databases in your Java applications. Here are some key features of "StelsMDB": · It supports most keywords of ANSI SQL'92 · It supports inner and outer table joins · It supports CREATE, INSERT, UPDATE and DELETE statements · It supports transactions · It supports aggregate, numeric, string, conversion and user-defined SQL functions · It is platform independent

    Size: Download
  • Aqua Data Studio
    Aqua Data Studio

    Aqua Data Studio is a database query tool and administration tool that allows developers to easily create, edit, and execute SQL Aqua Data Studio program is a database query tool and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures.Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from one application. Here are some key features of "Aqua Data Studio": Query Analyzer/Window: · Aqua Data Studio's sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test SQL scripts. Other features to speed up development include SQL automation, auto-describe and sortable multi-grid results. The query analyzer also provides client side variable binding, allowing a user to execute stored procedures or functions with local variables binded to receive out parameters. The query window also provides two modes of operation, using a SplitPane View or a MultiTab View for the editor and the query results. Schema Browser & Visual Editing: · Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema with a single mouse click. The schema browser also allows you to visually edit any schema object with a graphical design form to CREATE, ALTER or DROP the object. Visual editing supports Tables, Indexes, Procedures, Data Types and other schema objects. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation. Schema Extraction & DDL Scripting: · Its graphical browsing allows you to extract the structure definition of all schema objects and to script the SQL DDL and DML (eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE) syntax for database schema objects (including Tables, Views, Triggers, Stored Procedures and Functions). Table Data Editor: · A powerful Table Data Editor allows you to modify your results graphically and save them. By writing a single table SELECT statement in the Query Analyzer and clicking on the 'Execute Edit' button, a separate window is opened with the query results for you to edit and save. You may also browser to a table in the schema browser and select the Edit Table from the popup menu to edit the first 1000 records in a table. What's New in This Release: [ read full changelog ] · Version 8.0 of Aqua Data Studio now includes improved memory optimization methods than previous versions. One of these techniques is a memory compression method for optimizing resultsets which includes redundant data such as numeric data. Querying for large results in data warehousing environments with large quantities of numeric data will yield dramatic memory reductions. Long term use of Aqua Data Studio in these environments will keep memory usage low and in turn keep performance of the application high. The optimizations are most apparent in the Query Analyzer, Query Builder, Saving Results and Exporting of data. · Below are simple examples of a single query on two different types of result sets. One is of redundant numeric and text data, and the other is non-redundant data. The memory optimizations depend on the datasets, but these examples show some relative numbers which can be used to compare optimizations on different datasets. · Version 8.0 uses less memory than its predecessors on queries with large resultsets of "redundant" data in the Grid results. Older versions require 220% | 455% more memory. · Version 8.0 uses less memory than its predecessors on queries with large resultsets of "non-redundant" data in the Grid results. Older versions require 12% | 64% more memory. · Version 8.0 uses less memory than its predecessors on queries with large resultsets of "redundant" data in the Text and Grid results. Older versions require 24% | 97% more memory. · Version 8.0 uses less memory than its predecessors on queries with large resultsets of "non-redundant" data in the Text and Grid results. Older versions require 17% | 20% more memory.

    Size: Download
  • SQL Construction Kit
    SQL Construction Kit

    Data Manipulation Language generator SQL Construction Kit aims to provide a simple Builder pattern and Factory pattern based approach to generating DML (Data Manipulation Language) SQL for all the popular RDBMS systems. Included builders are SelectBuilder, InsertBuilder, UpdateBuilder, DeleteBuilder. It is much lighter weight than any of the ORM tools available, and is 100% Java, no other special configuration language or query language to learn.This code has been in production use since its first incarnation around 2001. Also included is a Facade patterned Database object that wraps a Datasource object. This provides an execution framework for the results of the Builder objects which includes simplified transaction and batch management as well as the ability to transparently handle sql exceptions in a default manner. The Database object also provides a simple object oriented approach via wrappers around the database metadata.There are no DDL (Data Definition Language) builders. This library is aimed at creating runtime dynamic sql easy. The DDL for the different databases is so varied that trying to abstract it out to a single generation framework would be counter productive. There are no plans to address DDL any time in the future.Developer commentsThis is a very active project, come back often as I work on either the code/javadoc or wiki documentation on a daily basis. What's New in This Release: [ read full changelog ] · This release fixes a bug in the AbstractDeleteBuilder object where it did not override the toString() method correctly.

    Size: Download
  • sqlDoInstall
    sqlDoInstall

    Will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. sqlDoInstall will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. It allows you to rerun a failed script and restart from the point where it has failed in a previous run. The sqlDoInstall application does not apply a driver+script combination that has been installed successfully. The "driver" and the supplied SQL uniquely identifies your script across the database.It'll create two tables: driverinst contains details, and driverinst_head contains a summary of the installation process. SQL installation, schema upgrades, and version tracking are easy. Requirements: · Java 2 Standard Edition Runtime Environment What's New in This Release: [ read full changelog ] · Incorrect handling of "create type statement" has been fixed. · Installation is no longer marked as FINISHED when a procedure, function, etc. was created with errors. · This release will check whether the object created is valid and exit with an error if not (trigger, procedure, etc.). · It stops the installation with an error if the required termination character is not found. · Do not use "--" in the text of a "create comment" statement, as the rest of the line will be treated as a comment and the statement will fail.

    Size: Download
  • SILVERCODERS SqlSync
    SILVERCODERS SqlSync

    SILVERCODERS SqlSync utility gives you the ability to compare data stored in two SQL databases, and synchronize it. SILVERCODERS SqlSync utility gives you the ability to compare data stored in two SQL databases, and synchronize it. Results contain list of records that differ, records that are missing and records that are additional. SqlSync can generate SQL queries that will change second database in such a way, that it will be identical to first database.Generated queries can be executed automatically. It will synchronize selected objects in databases or whole databases.You can control the process using command line arguments, and results are readable for user, but on the other hand, easy for future processing using shell scripts. There is a C language library included in the package, that allows comparing databases from other applications.SqlSync supports at least following SQL servers: PostgreSQL 8.1.x, MySQL 5.0.x, FirebirdSQL 1.5.x, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Oracle 10g. Two databases that are being compared can be driven by two different SQL servers.

    Size: Download
  • hiberlite
    hiberlite

    hiberlite is a C++ object-relational mapping for SQLite 3. hiberlite is a C++ object-relational mapping for SQLite 3. Its design and API are inspired by the Boost.Serialization, which means there is almost no API to learn. In contrast to most serialization libraries with SQL serializers, C++ objects mapped with hiberlite behave similar to active record patterns: you are not forced to follow the "read all your data/modify some small part/write everything back" path. It is for people who need reliable data storage, ACID transactions, and simple random access to their data files, and don't like coding in SQL. What's New in This Release:· Transaction support was added.

    Size: Download
  • SQLOrm
    SQLOrm

    SQLOrm is software created to set the standard for the next generation ORMs. SQLOrm is software created to set the standard for the next generation ORMs. It is based on the best properties of Ibatis, Toplink, Hibernate, Spring and our experiences using raw SQL.As an outset, SQLOrm is designed to be simple, easy to learn, and not solve every problem on the planet. The more a framework offers, the longer it takes to learn, and the more you have to fight it should you want to use it in a different way than the framework was envisaged used.Like the simplicity of Spring revolutionized the EE development, we hope to achieve the same with SQLOrm, no less.SQLOrm consists of 4 modules all of which can be combined or used in isolation, depending on your needs.Quite deliberately, features often found in ORMs such as database connection pooling and transaction handling, has been omitted. You can create your own connection pool in around 200 lines of code, or you can take advantage of any of the 1000s of connection pools already written. Some databases now even has connection pooling in the drivers. Similarly for transaction handling, you can use Spring, or Java's JTS. The most light-weight approach, though, is to use Mr. Persister's connection pool and transaction mechanisms. What's New in This Release:· More fluid < tt >SelectBuilder< /tt >. Now you can chain e.g. an < tt >ORDER BY< /tt > on an < tt >and()< /tt >. See the test cases for more details.

    Size: Download
    SQL management in Description
  • SQL Server Management Software
    Size: Download
  • SQL Server Management Studio Express
    Size: Download
  • SQL Management Studio for Oracle
    SQL Management Studio for Oracle

    EMS SQL Management Studio 2011 for Oracle is a powerfull software collection that allows you to manage Oracle databases. With components that focus on all critical Oracle database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering Oracle databases, managing database schema and objects as well as for Oracle database design, migration, extraction, Oracle query building, data import, export and database comparison. SQL Studio unites these database tools for Oracle in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing Oracle database administrators and Oracle application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for Oracle offers all essential Oracle tools to make you more productive than ever before! Main features: [ul][li]Basic features:[/li] [li]Support of Oracle versions from 8.2 to 10.2[/li] [li]Simple management of all Oracle objects (including create/edit/ drop operations)[/li] [li]Easy-to-work integrated environment uniting all SQL Studio capabilities[/li] [li]DB registration and connection:[/li] [li]Multiple home/database connections[/li] [li]Connection to Oracle Server through SSH[/li] [li]Registering selected databases to work with[/li] [li]Grouping/Ungrouping registered databases[/li] [li]Single repository for all DBs registered with EMS Software Development applications.[/li] [li]DB management:[/li] [li]Back Up any registered database[/li] [li]Restore previously backed up database[/li] [li]Powerful job manager to administer jobs[/li] [li]Grant manager displaying all database object grants in the form of a grid[/li] [li]Data manipulation:[/li] [li]View, edit, search, group, sort, filter any data stored in registered database[/li] [li]Export data in many formats (MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.)[/li] [li]Export data stored in different DBs in a single operation[/li] [li]Import data from many sources (MS Excel, DBF, TXT, CSV, XML, MS Access)[/li] [li]Import data from different sources to different DBs in a single operation[/li] [li]Convert database structure and data from OLE DB/ODBC data sources[/li] [li]Generate test data to several database tables at the same time[/li] [li]Console versions for all data manipulation utilities[/li] [li]Data Analysis:[/li] [li]DB comparison and synchronization ability[/li] [li]Data comparison and synchronization ability[/li] [li]Console versions for all data analysis utilities[/li] [li]Template management:[/li] [li]Create new templates for SQL Studio utilities[/li] [li]Edit existing templates for SQL Studio utilities[/li] [li]User friendly template manager. Fast access to the needed template.[/li] [li]Launch the utility for the selected template in one click[/li] [li]Scheduler:[/li] [li]Scheduled execution of data manipulation tasks (Import, Export, etc.)[/li] [li]Scheduled execution of any external applications[/li] [li]Creation and execution of complex tasks[/li] [li]Storage of logs for executed tasks[/li] [li]Flexible system of task execution results notifications (e-mail, net send, Application Log)[/li] [li]Log management:[/li] [li]Storage of logs for applications run by Scheduler[/li] [li]Ability to search, view, delete, export existing logs[/li] [li]Report designer:[/li] [li]New Create Report Wizard allows you to create simple reports in a few clicks[/li] [li]Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree[/li] [li]Other tools:[/li] [li]Extracting metadata and data into text files or SQL script editor[/li] [li]Extracting metadata and data from different DBs in a single operation[/li] [li]Console version of Extract metadata tool[/li] [li]Powerful print metadata module for creating customizable metadata reports[/li] [li]HTML report generator to create a detailed HTML report about your database quickly[/li] [li]SQL Monitor[/li] [li]SQL Query[/li] [li]Saving favourite queries[/li] [li]Saving query history[/li] [li]Ability to create diagrams based on queries[/li] [li]Visual Database Designer:[/li] [li]Two diagram notations (IDEF1x and IE)[/li] [li]Reverse engineering[/li] [li]Ability to create/edit/drop tables and table fields, visually set links between them[/li] [li]Saving as image or printing database diagram[/li] [li]New state-of-the-art graphical user interface:[/li] [li]Office 11 and Windows XP visual schemes support[/li] [li]Customizable toolbars for all program windows[/li] [li]Fully customizable program interface[/li] [li]Localizable program interface[/li] [li]Keyboard templates[/li] [/ul]

    Size: Download
  • SQL Server Monitoring Management Pack
    SQL Server Monitoring Management Pack

    The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios. In addition to health monitoring capabilities, this management pack includes dashboard views, extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues. What's new in this version: Fixed sql injection security issues.

    Size: Download
  • SQL Management Studio for PostgreSQL
    Size: Download
  • web based sql management tool-Shusheng
    Size: Download
  • SQL Management Studio for MySQL
    Size: Download
  • Allocation SQL Server Management Studio Add-in
    Size: Download
  • EMS SQL Management Studio for Oracle
    EMS SQL Management Studio for Oracle

    [ul] [li] Size: [b]117.37 MB[/b] [/li] [li] License: [b]Shareware[/b] [/li] [li] OS: Windows [/li] [li] Price: [b]$518.00[/b] [b]Buy full version[/b] [/li] [li] Publisher: EMS Database Management Solutions, Inc [/li] [li] Updated: 28 Jun 2010 [/li] [li] Downloads: 17 (1 last week) [/li] [/ul] EMS SQL Management Studio for Oracle is a complete solution for Oracle database administration and development. With components that focus on all critical Oracle database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering Oracle databases, managing database schema and objects as well as for Oracle database design, migration, extraction, Oracle query building, data import, export and database comparison. SQL Studio unites these database tools for Oracle in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing Oracle database administrators and Oracle application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for Oracle offers all essential Oracle tools to make you more productive than ever before! SQL Studio Additional Features * Handy launch of utilities and services * Storing all templates in a single repository * Common data source list for all services and utilities * Creating complicated tasks and scheduled tasks execution * Ability to run external applications from scheduler * Storing all task execution logs in one database * Creating customized notifications with a variety of delivery options * Ability to set visual interface style uniquely for all SQL Studio apps * Fast access to EMS Technical Support Service

    Size: Download
  • EMS SQL Management Studio for MySQL
    EMS SQL Management Studio for MySQL

    [ul] [li] Size: [b]146.39 MB[/b] [/li] [li] License: [b]Shareware[/b] [/li] [li] OS: Windows [/li] [li] Price: [b]$468.00[/b] [b]Buy full version[/b] [/li] [li] Publisher: EMS Database Management Solutions, Inc [/li] [li] Updated: 28 Jun 2010 [/li] [li] Downloads: 230 (1 last week) [/li] [/ul] EMS SQL Management Studio for MySQL is a complete solution for MySQL database administration and development. With components that focus on all critical MySQL database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering MySQL databases, managing database schema and objects as well as for MySQL database design, migration, extraction, MySQL query building, data import, export and database comparison. SQL Studio unites these database tools for MySQL in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing MySQL database administrators and MySQL application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for MySQL offers all essential MySQL tools to make you more productive than ever before! SQL Studio Additional Features * Handy launch of utilities and services * Storing all templates in a single repository * Common data source list for all services and utilities * Creating complicated tasks and scheduled tasks execution * Ability to run external applications from scheduler * Storing all task execution logs in one database * Creating customized notifications with a variety of delivery options * Ability to set visual interface style uniquely for all SQL Studio apps * Fast access to EMS Technical Support Service

    Size: Download

Free Software

Our Picks

© Copyright 2004-2015 www.ccmsoft.com All rights reserved.

Private Policy| Free Software Downloads|Free Software Downloads| Software Download| Software Downloads| Download Software