Best sql software for free download

dotConnect for SQLite is an enhanced data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. As a part of the Core Lab database application development framework, dotConnect for SQLite offers both high performance native connectivity to the SQLite database and a number of innovative development tools and technologies.

dotConnect for SQLite introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.


The following list describes the main features of dotConnect for SQLite:

- High overall performance
- 100% managed code
- Easy to deploy
- Full support of the latest versions of SQLite
- All SQLite data types support
- Full support for ADO.NET Entity Framework
- Powerful SQLiteDataTable component for manipulating individual tables or query result
- Flexible data binding with DataLink component
- Cross-form components cooperation
- Ability of monitoring query execution

dotConnect for SQLite supports SQLite engine version 3 and higher. The provider works with .NET Framework 2.0, 3.0, and 3.5. The current version is compatible with ADO .NET Entity Framework Beta 3, and can be used with the following integrated development environments:

- Microsoft Visual Studio .NET 2008
- Microsoft Visual Studio .NET 2005
- Delphi for .NET and RAD Studio 2007

Delphi for .NET and RAD Studio 2007 are supported in run time only as these environments have no WinForms designers.

Related software: sqlite, development, tool, sql, query, data, provider, .net, access, server, ado.net, asp.net, framework, data provider, …

XlsToSql is a tool to import Excel data to Sql Server. Main features: 1 Read data from excel sheet into an Sql Server table. 2 Run SQL command to see importing results. 3 Support Unicode. 4 Support text, ntext, image type.

Related software: excel, sql, server, xls, import, copy, excel to sql server, xls to sql server, sql server excel, sql server xls, sql server import excel, sql server copy excel, …

ApexSQL Enforce is a revolutionary new solution for Industry Best Practices adherence and Custom Standards enforcement for SQL Server Databases. ApexSQL Enforce empowers users to create complex custom rules by leveraging the power of full programming languages like C# and VB.NET.
With ApexSQL Enforce, you can--
- Ensure adherence to design standards in "real time"
- Facilitate upgrades to new versions of SQL Server by identifying potential conversion problems before the database is ported
- Automatically reverse or fix detected violations using generated "FixSQL" scripts
- Enforce Naming conventions and ensure that SQL reserved words and special characters are not used

Related software: sql, enforce, tools, tool, rules, rulebase, html, reports, fixsql, resultsets, xml, exports, database, sql enforce, sql tools, sql tool, html reports, xml exports, …

SQL Partition Manager is a solution for managing SQL Server partitioned tables. If you work with large databases, SQL Partition Manager greatly simplifies the maintenance of partitioned tables. It will help you to perform any basic or advanced partitioning operations on them. You can create new partitions, delete, split or merge them, and at the same time avoid potential partitioning errors. Besides, the tool partitions existing tables with data and turns them into manageable chunks of data to easily move them in and out.

SQL Partition Manager enables you to do the following:
- convert existing nonpartitioned tables with data to partitioned tables;
- split and merge table partitions;
- switch partitions from one partitioned table to another;
- switch in standalone tables as new partitions;
- create and manage partition functions and partition schemes;
- review and modify the partition objects in a database.

Related software: sql, server, mssql, vldb, database, partition, partitioning, partitioned, table, scheme, sql server, partitioned table, partition scheme, …

Recovery Toolbox for SQL Server can be used to repair data from corrupted databases in MS SQL Server format (files with *.mdf extension). It permits to save critical data and avoid its losing. Recovery Toolbox for SQL Server extracts data step-by-step.
1. This tool can search and pick up housekeeping data, that may be used to repair some data modules.
2. All information, that can be extracted by Recovery Toolbox for SQL Server, is previewed on the screen: System Tables and User Tables, Stored Procedures, Views, User Defined Data Types and Functions. You can preview all of these objects anytime and make sure, that Recovery Toolbox for SQL Server works fine.
3. After this, you should select, how to save recovered data (you can save it to the hard drive or any other removable media as a package of SQL scripts, it is also possible to export the results directly to any database upon your choice), configure the process and start data export.
4. When data recovery process is launched, Recovery Toolbox for SQL Server will analyze and scan the whole database. This process may take some time, it depends on the source file and CPU performance. During this process, Recovery Toolbox for SQL Server repairs all information, that may be extracted successfully. At the same time, it should be noted, that sometimes Recovery Toolbox for SQL Server is unable to recover some pieces of information, in spite of its sophisticated data recovery engine. Sometimes, the source file is heavily damaged, that is why, some data modules cannot be recovered. Recovery Toolbox for SQL Server will never modify the source file, it creates a copy of this file and works with it.
5. When the process is over, Recovery Toolbox for SQL Server will display the results of data recovery process.

Related software: fix, sql, database, mdf, ndf, recover, server, recovery, ecovery, repair, fix sql database, mdf fix, ndf fix, recover mdf, recover ndf, recover sql database, recover sql server, recovery mdf, recovery ndf, ecovery sql database, recovery sql server, repair mdf, repair ndf, repair sql database, repair sql server, sql server, …

OlapCube is a simple, yet powerful tool to analyze data. OlapCube will let you create local cubes (files with .cub extension) from data stored in any relational database (including MySQL, PostgreSQL, Microsoft Access, SQL aServer, SQL Server Express, Oracle, Oracle Express).

You can explore the resulting cube with our OlapCube Reader. Or you can use Microsoft Excel to create rich and customized reports.

The OLAP cube consists of numeric facts called measures which are categorized by dimensions. An OLAP cube is a data structure that allows fast analysis of data. The arrangement of data into cubes overcomes a limitation of relational databases. Relational databases are not well suited for near instantaneous analysis and display of large amounts of data. Instead, they are better suited for creating records from a series of transactions. Although many report-writing tools exist for relational databases, these are slow when the whole database must be summarized.

OLAP cubes can be thought of as extensions to the two-dimensional array of a spreadsheet. For example a company might wish to analyze some financial data by product, by time-period, by city, by type of revenue and cost, and by comparing actual data with a budget. These additional methods of analyzing the data are known as dimensions.

A financial analyst might want to view or "pivot" the data in various ways, such as displaying all the cities down the page and all the products across a page. This could be for a specified period, version and type of expenditure

Each of the elements of a dimension could be summarized using a hierarchy. The hierarchy is a series of parent-child relationships, typically where a parent member represents the consolidation of the members which are its children. Parent members can be further aggregated as the children of another parent. For example May 2005 could be summarized into Second Quarter 2005 which in turn would be summarized in the Year 2005.

Related software: data, analysis, cube, olap, pivot, pivotchart, pivottable, database, relational, services, data analysis, analysis services, …

Do you need to design, visualize or document your Oracle database?
ModelRight 3 for Oracle can reverse engineer your existing database to get a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design up to date.
Do you need to control the most detailed aspects of your Oraclel database? ModelRight 3 for Oracle has more complete and in-depth support for Oracle's most advanced features. Plus, it has a modern user interface that allows for easy diagram editing and navigation.
ModelRight 3 for Oracle provides all of these powerful features (and many more) to help you produce the most complete and efficient database designs possible.
Whether you are a beginner or an expert database modeler, ModelRight 3 for Oracle is your answer when you need a database modeling tool that surpasses the "least common denominator" approach taken by others.
Try yourself and download ModelRight 3 for Oracle. Data Modeling has never been easier or more professional!

Related software: oracle, database, design, data, modeling, diagram, entity, relationhsip, erd, oracle database design, oracle data design, oracle data modeling, oracle database modeling, oracle database diagram, oracle entity relationhsip diagram, oracle erd, …

Active Query Builder is a visual SQL query builder .NET component that allows your end-users to build complex SQL queries via an intuitive visual query building interface easily. It is a perfect choice for both SQL beginners and experienced query writers. Active Query Builder renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with queries.

The interface of Active Query Builder is similar to MS Access and SQL Server’s visual query building interface, so it is already familiar to most database users. Active Query Builder practically eliminates mistakes when writing SQL queries while achieving almost instant results. By embedding Active Query Builder into your product, you can make it easy for beginners and provide a powerful tool for professionals.

Active Query Builder provides maximum flexibility to your users without your software losing control over the operations it performs: the fields and tables the user selects in a query and the data that gets displayed on the screen. No more parameter problems; Active Query Builder lets you find out not only each parameter’s name but also the names of each table and field that each parameter applies to.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. You can edit existing queries or even create new SQL queries in run-time.

Active Query Builder supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and other SQL dialects. There are two editions available: the Standard Edition and the Free Edition. The Free Edition is fully functional, but supports only the ANSI-92 SQL dialect.

Active Query Builder is a special component. It wasn't created for some internal needs, it was made to meet your needs!

Related software: sql, visual, query, builder, .net, activex, component, …

WMSmart-3PL, Invenology's innovative Warehouse, Inventory and Distribution management software, is a powerful logistics (3PL) management system designed specifically for small to mid size businesses. This software package offers an extensive feature base that includes: Inventory Control, Item Catalog, Work Order/distribution, Entry/Lot Inventory, Warehouse Locator, Transfer Tracking/Repackaging, Asset Management, EDI, Contacts Management, Barcodes and Labels Production, Min/Max Quantities, Calendar View/Scheduler, ARN, ASN, FIFO/LIFO Expiration Date and more. WMSmart-3PL offers variety of add-ons including: Web Access Reports and Mobile/ Scanner/Terminal side application. WMSmart-3PL is based on a robust environment (Microsoft SQL Server 2005 (Free Edition), Crystal Reports and .NET development environment) that allows scalability and flexibility. WMSmart is designed and defined as multi-everything (user, customer, warehouse, account). WMSmart is self explanatory and easy to use software package that requires minimum training and implementation time.

Related software: inventory, distribution, management, barcodes, labels, edi, …

SQL Server Recovery Toolbox is used to recover information from damaged MS SQL Server databases (*.mdf files). It allows users to avoid losing important information. SQL Server Recovery Toolbox recovers information in several steps:
- The program searches for and reads system data that can be used to recover the rest of information.
- All data that SQL Server Recovery Toolbox can recover is displayed on the screen: User Tables and System Tables, Views, Stored Procedures, Functions and User Defined Data Types. You can view them and make sure that the tool works.
- Then the user should select the method for saving the recovered information (saving to the hard drive as a package of scripts in the SQL language or exporting directly to a database), configure it and start the export process.
- After the process is started, the tool scans and analyzes the entire damaged database. The time it takes depends on the size of the source file. During this process, the tool recovers from it all information that can be recovered. However, it should be mentioned that in some cases SQL Server Recovery Toolbox cannot extract all data despite its high effectiveness. It depends on what damaged the source file and how badly. It is worth mentioning that Recovery Toolbox does not modify the source database, it only extracts information from it during the scanning process.
- After the export process is over, the program displays the report about what has been done.
Tool has a wide set of features that can be effectively used to recover information from MS SQL Server databases. The following features are particularly worth mentioning:
- Recovering information from large databases with the size of up to 16 TB.
- Recovering information from damaged MS SQL Server databases via the local area network.
- Saving the extracted information as scripts in the SQL language with the possibility of splitting into files of the specified size.

Related software: sql, repair, recovery, mdf, restore, server, microsoft, recover, sql repair, sql recovery, mdf repair, mdf recovery, mdf restore, ms sql server repair, microsoft sql server repair, ms sql server recover, microsoft sql server recover, …

Gutnov MagicSite is effective and functional solution that allows you to build and manage professional Web sites. Powerful professional HTML editor with built-in web-sites designer QuickSite and scripts constructor Magic Script Builder will provide a effective and fast creation the both simple a web-projects, and complex Internet-portals, chats and forums. The integrated utilities of increase of productivity QuickSite and Magic Script Builder will help to create easily and quickly on the basis of templates ready-to-use web-sites, guestbooks, chats and forums. Built-in system AutoUpdate will download via Internet the new updatings, new templates for sites and scripts. The modern environment of development will allow creating and quickly modifying HTML-tags, making various operations with already written code. Gutnov MagicSite supports all modern web-technologies, automatic check and highlighting of syntax HTML, PHP, XML, Visual Basic, Perl, SQL, C/C ++ a code, panel QuickBar for fast entering of tags, tables, frames, forms, Active Server Pages, ActiveX elements and Java Applets. Using Gutnov MagicSite, it is possible to keep parameters of expansion a web-projects, for the further updating and a reuse.

Related software: html, flash, asp, php, java, scripts, website, internet, magic, …

Combine (horizontally) two MySQL tables into one based on a common column of data from each table. The original two tables are not altered but a new table is created with the results.

Related software: sql, mysql, combine, match, union, merge, combining, joining, matching, merging, fields, data, one, many, files, mdb, access, microsoft, unioning, update, updating, existing, new, multiple, 2000, 2007, 2003, single, statement, query, queries, outer, join, inner, outerjoin, innerjoin, querying, database, rows, columns, all, records, both, unmatched, matched, relational, relation, common, value, return, returned, cartesian, full, get, getting, linking, separate, seperate, distinct, accessing, different, same, similar, left, right, more, than, sides, relationship, stored, external, internal, aggregate, upsize, upsizing, flat, identical, diff, design, grid, twice, once, large, small, primary, key, secondary, odbc, link, recordset, append, names, scan, index, type, size, mismatch, tsql, select, from, nested, comparing, special, count, zero, pid, syntax, remove, duplicat, my-sql, ms access, sql statement, outer join, inner join, ms-access, all records, more than, primary key, …

Comfort Paste is a template manager you can use to quickly paste frequently used text fragments and images.

Why do you particularly need Comfort Paste?

Despite the visible simplicity of the interface, Comfort Paste has powerful features that will help to forget about the routine of your work and speed it up.

Comfort Paste will help you to quickly complete the following tasks:
+ Paste frequently used phrases, signatures, smiles, addresses, greetings, passwords, etc.
+ Create all kinds of messages and documents using templates.
+ Paste images from a predefined list.
+ Paste regularly repeated fragments while programming: HTML, SQL, Pascal, etc.

How does Comfort Paste work?

Every template has a name and the manager searches the database for it. Just type the name of the template or only its beginning and press Win+Space (by default).

There are three types of templates:
1. Plain text.
2. RTF (Rich Text Format) - as in MS Word, OpenOffice, MS WordPad, etc.
3. Image.

You can add various macros to text templates: keystrokes, tags for inserting random text from a predefined list, etc.

Comfort Paste includes a mechanism for quick and comfortable template configuration.

It is easy to use Comfort Paste in workgroups. To do it, just save the template file to a network resource and configure it to be used on every workstation.

It is completely compatible with Microsoft Windows Vista, XP and 2000.
http://www.comfort-software.com/template-manager.html

Related software: comfort, templates, input, manager, fragment, repeat, paste, insert, programming, text, graphics, picture, rtf, letter, mail, smiles, phrases, signature, monotony, …

Do you need to design, visualize or document your database?
ModelRight 3 can reverse engineer your existing database to get a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design up to date.
Do you need to control the most detailed aspects of your physical database?
Do you need to control the most detailed aspects of your physical database? ModelRight 3 has more complete and in-depth support for your database.ModelRight 3 has more complete and in-depth support for your database's (currently Oracle, SQL Server, MySQL, and database via ODBC) most advanced features. Plus, it has a sophisticated modern user interface that allows for easy diagram editing and navigation.
ModelRight 3 provides all of these powerful features (and many more) to help you produce the most complete and efficient database designs possible.
Whether you are a beginner or an expert database modeler, ModelRight 3 is your answer when you need a database modeling tool that surpasses the "least common denominator" approach taken by others.
Try yourself and download ModelRight 3. Data Modeling has never been easier or more professional!

Related software: database, design, data, modeling, diagram, oracle, sql, server, mysql, odbc, erd, tool, entity, relationhsip, database design, data design, data modeling, database modeling, database diagram, sql server, modeling tool, entity relationhsip diagram, …

MyDirect .NET, formerly known as MySQLDirect .NET is an enhanced data provider for MySQL that builds on ADO.NET technology to present a complete solution for developing MySQL-based database applications. As part of the Core Lab database application development framework, MyDirect .NET offers both high performance native connectivity to the MySQL database and a number of innovative development tools and technologies.

MyDirect .NET introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.

The following list describes the main features of MyDirect .NET.

* Direct access to MySQL server
* 100% managed code
* High performance
* Easy to deploy
* Supports the latest versions of MySQL server including MySQL Embedded server
* All MySQL data types support
* .NET Compact Framework support
* Operates in both connected and disconnected models
* Powerful MySqlDataTable component as all-in-one table data access solution
* Auxiliary components for SQL scripts and bulk data transfer
* Extra data binding capabilities
* Cross-form components cooperation
* Ability of monitoring query execution

MyDirect .NET supports MySQL server version 5.1, 5.0, 4.1, 4.0 and 3.23. The provider works with .NET Framework 1.0, 1.1, 2.0, 3 Beta and .NET Compact Framework 1.1 and 2.0, and can be used with the following development environments:

* Microsoft Visual Studio .NET 2008 Beta
* Microsoft Visual Studio .NET 2005
* Microsoft Visual Studio .NET 2003
* Microsoft Visual Studio .NET 2002
* Turbo Delphi for .NET Professional
* Turbo C# Professional
* Borland Developer Studio 2006
* Borland Developer Studio 2005
* Borland Delphi 8
* Borland C#Builder

MyDirect .NET can be used together with UniDirect .NET that provides universal access to different databases within a single code.

Related software: mysql, development, tool, sql, query, data, provider, .net, access, server, ado.net, asp.net, framework, data provider, …

FlySpeed Data Export is the must-have tool to export your data quickly and easily. The ability to connect to almost any data source, including all the latest versions of database servers and desktop databases, and exporting to the most-popular office formats makes FlySpeed Data Export a really universal data export tool.

Being originally designed for multiprocessor environment, FlySpeed Data Export achieves the highest transfer rates while working at modern multi-core systems. Take advantage of the real multiprocessor data exporting, and get your data exported like a shot!

FlySpeed Data Export is able to save all export parameters to a file, thus allowing you to repeat the export process in a few mouse clicks. The command line tool lets you automate export process.

Has no experience in exporting data from your database to XML, CSV, Excel or some other format? Let the FlySpeed Data Export help you. The most powerful yet simple tool is a few clicks away from you. Download now and get your data exported in seconds!

Key Features:

* Exporting data from MySQL and MS SQL Server via direct connection.
* Exporting data from Oracle, PostgreSQL, Firebird, DB2, Sybase, Informix, dBASE and any other ODBC or OLE DB compatible data source.
* Exporting data to most popular formats: CSV, Text, MS Excel, MS Access, XML and DBF.
* Exporting data from tables, views and custom SQL queries.
* High performance, low memory utilization, optimized for large databases.
* Wide range of configuration options for each data format.
* Command line tool to automate data export process.
* Simple and convenient graphical user interface.

Related software: data, transfer, export, excel, access, xml, dbf, data transfer, export data, export to excel, export to access, export to xml, export to dbf, …

Syndikut Members Only Area v1 (MOA) is a flat file php script that allows you to have a members area on your web site. MOA has been built from scratch, to include some great features. Members Only Area v1 allows you to have greater control over your free downloads by forcing visitors to register in order to access them. As the administrator, you can add downloads to your members download page via a secure admin control panel. All downloads are protected by MOA to ensure no unauthorized access. All members have to supply a valid email address in order to register and gain access. With the aid of MOA you can keep in touch with visitors by sending them email notifications, news, new products and downloads, with its built in mass mail function. The registration form short has been kept short to only include the major required fields, some of which can even be disabled. Moa comes complete with a lostpassword feature and an option to resend account activation email. View all the feature for more info.

Related software: syndikut, script, scripts, scriptz, php, members, only, moa, flat, file, sql, members only, no sql, flat file, php scripts, php script, …