Active Database Software Products

FlySpeed DB Migrate to SQL Server enables you to transfer the structure and data (fully or partially) onto another database server, or transfer the data to the structure that already exists. In the latter case, there is an opportunity to run this operation many times to sync data. Because the synchronization is done one way, it''s very convenient for recurring "dump" of information, for example, from the web server to the local one. The connection with the source database is done through ADO and ODBC, which is a specialty of FlySpeed DB Migrate and cannot be found in most other products. Support for ADO and ODBC lets admins extract ALL the information about the structure of the source database. Another unique feature is an opportunity to connect to the source MS Access database directly, which speeds up the migration process. In doing this, all images, stored in BLOB-fields as OLE objects, are extracted and put to MS SQL Server correctly. Most competing products fail to do it, and images become unreadable and cannot be recognized at all. Another nice touch in FlySpeed DB Migrate to SQL Server is a possibility to transfer data when there is no connection with the target server. In this case, an SQL script is created to be run later. Migrating a database structure is no easy job. Too often experienced admins decide to move by hand because the tools for automatic migration fail to offer them the required level of control and transparency. With FlySpeed DB Migrate, you gain control you want. The generation of an SQL script that creates the database structure on the target server, is totally controlled by the admin. He can change the structure of the objects using visual tools and make changes by hand. In case errors occur during the execution of the script, the admin can correct an expression that caused an error and continue running the script from where it stopped.

Keywords: database migration to ms sql migrate to sql server ms sql migrate tool data transfer to sql server mssql migration tool base files

Active Query Builder Free Edition

Active Query Builder is a query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful graphical engine that allows you to build queries involving unions and sub-queries. The interface of Active Query Builder is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder for Delphi such as the ability to build queries with unions and subqueries make it the best solution for professional developers. Active Query Builder is a true two-way query builder, so you may combine visual query building with direct SQL query editing. Changes made to the SQL query text will be affected to the query builder immediately. Using the Active SQL Query Builder you can customize SQL code the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line. The component may be integrated into your application with just a few lines of code. Unlike many other query building solutions, Active Query Builder does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible. The product is shipped with detailed help system and a demo application to help you quickly master the product. Active Query Builder is available as a Delphi VCL component, as ActiveX control or as Windows.Forms .NET component, so it can be used in almost any software and it is absolutely free, even for commercial purposes!

Keywords: sql query builder visual delphi component sql server mysql java class library

FlySpeed Data Export

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.

Keywords: data transfer export data export to excel export to access export to xml export to dbf music pitch

Active Query Builder ActiveX Edition

Active Query Builder is a .Net-ready ActiveX visual query builder component to build complex SQL queries via an intuitive visual interface easily. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful and user-friendly GUI that allows you to build queries involving unions and sub-queries. The interface of Active Query Builder is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder such as the ability to build queries with unions and sub-queries make it the best solution for professional developers. Active Query Builder supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and other SQL dialects. The sophisticated Active SQL parser can translate any valid SQL statement into it''s visual representation. ActiveX Query Builder can be used in any software project which supports ActiveX controls as well as in the .Net projects. For example, you can use it with Visual Basic 6.0, Visual Basic .NET, Visual C++ 6.0, Visual C#, PowerBuilder, Delphi and so on. The component may be integrated into your application with just a few lines of code. In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offline mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded. 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.

Keywords: sql visual query builder .net activex component control pc system

Active Query Builder Delphi VCL Edition

Active Query Builder is a true two visual query builder component for Delphi and C++ Builder that allows your end-users to build complex SQL queries via an intuitive visual interface easily. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful and user-friendly interface that allows you to build queries involving unions and sub-queries. The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder for Delphi such as the ability to build queries with unions and sub-queries make it the best solution for professional developers. Active Query Builder supports Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, Informix, Sybase, SQLite, and ANSI-92 SQL dialects. The sophisticated SQL parser with full Unicode support can translate any valid SQL statement into it''s visual representation. You can use full range of database connectivity components as well as generic event-driven metadata provider to get metadata information from any data source. Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects. Using Active Query Builder you''ll be able to retrieve various information about parsed query like lists of tables and fields used in the query. Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to. Using the Active SQL Query Builder you can customize SQL code the way you like it. 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.

Keywords: sql query builder visual delphi component sql server mysql add data

Search for: