Freeware Downloads

ZIPCodeWorld United States Free Edition includes 5-Digit ZIP code, state code and state name. The database provides the ZIP codes and state code in the United States of America. The complete database contains over 42,000 unique records updated every month. The database is available in CSV (text) format and can be imported into other formats easily. This database is free for both personal and commercial usage. You can use the list for automated data validation or other purpose. If you need to have a complete list of United States ZIP codes, this is the right database for you.

dbForge SQL Complete Express is a free intellisense add-in for SQL Server Management Studio 2000, 2005 and 2008 that offers powerful autocompletion and formatting of T-SQL code.

Besides extending List Members, SQL Formatting, Complete Word and Parameter Info features, SQL Complete Express adds Quick Object Info that shows essential information about database objects.

Key features:

* Smart filtering:
SQL Complete filters the suggestion list based on various criteria:
- first typed symbols,
- a whitespace,
- camel case,
- a square bracket.

* Quick Object Info:
Essential information about a database object is shown in the popup window
when the mouse cursor is over the identifier.

* List members:
List members for major objects: database, schema, table, view, procedure, user and table-valued function (including CLR), built-in function, synonym, CLR aggregate;

* Parameter information for user-defined and built-in procedures/functions:
When you are typing names of user-defined and built-in functions and procedures, SQL Complete displays their parameter information in a hint.

* SQL formatting:
Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc.

* Determining a database context:
SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query.

* Word autocomplete;

* Context-sensitive suggestions of DML statements: INSERT, UPDATE and DELETE;

* Manual refreshing of the suggestion list.

dbForge SQL Complete is a useful add-in for SQL Server Management Studio 2000, 2005, and 2008 that offers powerful autocompletion and formatting of T-SQL code features.
Besides extending List Members, Complete Word, and Parameter Info features, SQL Complete adds SQL Formatter to enrich the developer toolkit and provide the fastest T-SQL query typing ever possible.

Key features:

* Context-based code completion:
dbForge SQL Complete has a feature to offer code completion
lists based on context instead of simply listing object attributes and methods.

*Quick object info:
Essential information about a database object is shown in the popup window when the mouse cursor is over the identifier. For tables users can see column names with data types, additional column properties, primary, unique, and foreign keys. For other objects, the quick info includes object type and an available user description.

* Customizable SQL formatting:
Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc.

* Quick parameter info for functions:
When you type names of user-defined and built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint.

* Suggesting conditions for JOIN statements:
dbForge SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.

* Automatic alias generation:
The tool can generate an alias for each table object in the FROM list of SQL document automatically.

* Suggestions of T-SQL statements in procedures and functions:
SQL Complete supports:
– DECLARE statements for local variables, cursor variables, and table definitions;
– cursors (declared with the help of DECLARE CURSOR statements) in OPEN, CLOSE, DEALLOCATE statements;
– context for such control-of-flow as BEGIN…END, GOTO, IF…ELSE, RETURN, BREAK, CONTINUE, WHILE, WAITFOR, TRY…CATCH, CASE, RAISERROR.

Years ago, the DBF file format was used in dBase II, the first truly popular and widely used database management system,s and since then has been adopted by numerous dBase variations, commonly referred to as xBase. This fact makes DBF one of the most popular database formats underlying thousands of applications, from simple data management tools to geographic information systems. If you are a database developer or deal with DBF databases on a regular basis, you know very well how important it is to have a reliable and multifunctional tool for viewing and editing DBF data files. And if you still haven’t found one, it’s time for you to take a look at DBF Viewer 2000!
DBF Viewer 2000 is a sophisticated, yet compact and easy to use solution for viewing, editing and optimizing database files of the .dbf format. The software also enables you to delete duplicate records, run queries, sort and print database records and export data into a variety of formats (DBF, TXT, CSV, Excel, HTML, XML, PRG, SQL, RTF). The main advantage of DBF Viewer 2000 is speed. No matter how big the database you are working with is, your commands will be executed instantly. The software supports editing and viewing of memo fields in several formats, including dBase III, dBase IV, FoxPro, VFP and dBase Level 7, and dynamically generates visual dialogs based on the file structure, which provides a more natural and convenient way of working with various database formats. DBF Viewer 2000 does not require any external drivers for opening database files and can be run under all versions of Windows – from 95 to Vista, Windows 7 and server editions. Advanced users will find it very convenient to use the command line mode to automate database optimization and batch processing routines.
Try DBF Viewer 2000 to discover a tool that delivers far beyond your expectations. Truly versatile and full of useful features, it is an obvious choice for professionals who value their time and appreciate comfort at work

Concerning net reports, FastReport.Net is a full-featured .net reporting solution for developers who use Microsoft Visual Studio 2005 and 2008 or any other development tool that works with .NET Framework 2.0 and higher.
With FastReport.Net, you can create application-independent reports. In other words, FastReport.Net can be used as a standalone reporting tool. See yourself:
* you can connect to any database, use any table from it or create a query;
* you can add dialogue form(s) to your report to ask some parameters before running a report;
* using built-in script, you can manage interaction between dialogue form’s controls, perform complex data handling;
* finally, you can view the result, print it and export to many common document formats.

dbForge Schema Compare for Oracle is a powerful schema comparison and synchronization tool for Oracle databases. It can compare multiple database schemas at once, completes the comparison process in seconds, provides a clear grid to analyze differences, and generates an update script for accurate further synchronization.

dbForge Schema Compare provides an accurate way to compare and synchronize schemas between different Oracle versions. You can compare as many schemas as you need at once and select required object types for comparison.

Key features:

* High performance of comparison
Usually schema comparison and synchronization process is time-consuming, but dbForge Schema Compare for Oracle completes it two times faster then other comparison tools do.

* Compares wide range of object types in Oracle databases
dbForge Schema Compare for Oracle allows you to compare the following principle object types:
tables, views, functions, procedures, packages, triggers, sequences, synonyms, user types (object types, collections types), XML schemas.

* Compares schemas in multiple documents at once
Unlike most schema comparison tools, dbForge Schema Compare for Oracle has ability to compare schemas in multiple documents at once.

* Generates schema comparison reports
When schema comparison process is completed, you can generate HTML and Excel comparison reports to keep records of schema changes.

In addition, dbForge Schema Compare for Oracle can work without Oracle client, generates SQL*Plus-compatible synchronization scripts, saves schema comparison settings for the next usage, and has a convenient UI.

Visual Importer Professional automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Full support for Excel, MS Access, DBF, XML and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite or any ODBC compliant database.

Here is simple usage example: Download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed.

One of the major benefits of using Visual Importer Professional that it can also add new and update old records based on user defined primary key.

Let’s say, for example, you work at university and must publish results of exams from different departments. Visual Importer Professional can help you automate data processing without the need for more staff. It will enable you to process data sent via email and FTP without user intervention. Simply create a dedicated email account, design a package and that’s it – start processing data!

Another unique benefit of using Visual Importer Professional its ability to load data from multiple files or tables using mask.

If there is a problem it is very easy to resolve: Every package execution is logged. In case of loading errors, Visual Importer Professional writes a detailed message into the log and writes a record into the rejected records file.

On top of that there are several wizards to make your life easier so you can automate your routine tasks today and spend more time sitting in the bar watching football and drinking beer!!!

Visual Importer ETL Enterprise is a platform for building high performance data integration solutions, Including extraction, transformation, and load (ETL) packages for data warehousing and business automation. Visual Importer ETL Enterprise includes graphical tools and wizards for building and debugging automation packages; Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Full support for Excel, MS Access, DBF, XML and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite or any ODBC compliant database.

Here is simple usage example: Download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer Enterprise can also add new and update old records based on user defined primary key.

Let’s say, for example, you work at university and must publish results of exams from different departments. Visual Importer Enterprise can help you automate data processing without the need for more staff. It will enable you to process data sent via email and FTP without user intervention. Simply create a dedicated email account, design a package and that’s it – start processing data!

Another unique benefit of using Visual Importer Enterprise its ability to load data from multiple files or tables using mask.

If there is a problem it is very easy to resolve: Every package execution is logged. In case of loading errors, Visual Importer Enterprise writes a detailed message into the log and writes a record into the rejected records file.

The Enterprise version includes execution agent, which can be run as a Windows service.

Now You Can Load 14,347 Records A Second With The Easy-To-Use Visual Importer ETL

If you regularly export, transform or load database data, Visual Importer ETL is designed to
Save you time.

It does this in three ways:
Time Saver #1: Processing Speed

Using Visual Importer ETL Standard version 4.9.1.4, you can load a delimited text file into
MS SQL Sever via BCP 500000 lines in… 34 seconds!

That’s 14,347.58 records per second.
Time Saver #2 Compatibility and Versatility

Processing speed is important, but it’s not much use if you have to fiddle around with your data to get it into the right format.

So, we made sure Visual Importer works with almost all data formats you might be using.
It works with…

* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel Spreadsheets
* Multiple MS Access Databases + Multiple Tables
* Multiple DBF Files
* Multiple Tables
* MS Sql Server
* Oracle Database
* MySql
* PostgreSql
* Interbase/Firebird
* SQLite
* XML
* Any ODBC Database

Visual Importer is a simple ETL tool

And…
The latest version now allows you to load data from Utf8, Utf16BE, Utf16LE files with or without BOM.
There is full support for international characters for ODBC connections, MS SQL Servers and Oracle databases.
Unlike Oracle SQL loader, BCP, DTS or SSIS Visual Importer ETL can also add new and update old records based on user-defined key.

Time Saver #3 Ease Of Use

Because Visual Importer ETL was especially designed for non-technical users, it can be picked up in as little as 10 minutes…

I had my first upload running within 10 minutes of installing Visual Importer ETL"
Gene Kovacs, Director of Technical Business Operations, A2B

Source Data Filtering, Multiple source tables and files. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer can also add new and update old records based on the user-defined key.

DataLadder announces the release of DataMatch 2011

DataMatch 2011 is a powerful and comprehensive data cleansing, matching, and deduplication DESKTOP tool.

Designed to be used by anyone, not just IT professionals, it has an intuitive interface that shows the modifications you are making to your data in real time so you can experiment and undo actions.

Why do I need DataMatch?

Save Time and Money
DataMatch cuts the amount of time needed to clean, match, and deduplicate a data set by up to 90%.
Duplicate records and incorrect data costs the average Fortune 500 Firm several Million dollars per year.
Cost of duplicate mailings
Cost of incorrect decisions made on bad data
Cost of employee time trying to clean data repetitively without the necessary tools or training.
Save your cleansing work as a project that you can reuse later.
DataMatch has a very fast processing time. Deduplicate large data sets in a very short period of time.
Features of DataMatch are typically only found in very expensive custom based software solutions.

Free trial available

For more information visit www.DataLadder.com

Promo SMS Sender provides solutions to send bulk SMS messages and vCard via SMS using the GSM modem or mobile phone. This is software for SMS advertising and SMS marketing. It supports long and flash SMS, 7-bit, UCS2 (16-bit unicode) character encoding. Support all international characters. Import phone number list from CSV files. The SMS editor displaying information about the total length of your text message. Send personalized SMS message to each recipient. No internet connection is required to send SMS.

TOPOWIN is a state-wide register of the German Topographic Cartographies, the German Basic Cartography and of localities with geo references in different coordinate systems. It is also a topographic information system. In the division of planning and execution of economical and scientific projects frequently topographic documents are used. The program TOPOWIN makes information available of the official topographic cartographies and the German Basic Cartography from the entire national territory in suitable graphic views. It accomplishes different coordinate transformations and inquiries. The program was developed under co-operation of the land surveying authorities of many German Federal States. For the first time in the previous version TOPO (for DOS) and later in TOPOWIN state-wide topographic information were arranged for the data technical evaluation. The program is for consulting engineers, planning authorities and users of topographic maps a useful and versatile tool. The topographical maps of different standards, required for a project, can be determined by the entering of known parameters or by the direct selection from overview graphics and from sorted lists. By the investigation of topographical records on the basis of known places, a data base with more then 105.000 places and residential districts is available. The program TOPOWIN calculates with Gauss Krueger coordinates and Geographic Coordinates refering to the Potsdam Datum (Bessel ellipsoid with central point Rauenberg). It also works with UTM coordinates and UTMRef coordinates in the NATO standard, which refer to the datum ETRS89 (GRS80 / WGS84, geocentric).

MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. MyOra?s MDI (Multi Document Interface) framework handles multiple sub-windows opened at same time. Allows multiple connections to the same database or different database. Users can open any number of Performance Monitors, SQL Editors, Schema Explorers, Session Managers etc and view them vertically or horizontally. Real Time Performance Monitoring using graphs, bar charts and pie charts. Top 5 SQLs (SQL details and Explain Plan) using interactive 3-D bar charts. Top 5 Resources (Sessions Statistics) using interactive 3-D bar charts. DB Activity in real time using Six interactive graphs. Tablespace used/free pie charts. Session Manager to monitor sessions. Multiple SQL Editors with auto complete feature for Table names and Column names and many more features.

Export Table for Microsoft SQL Server helps to save table’s data to text file. The program supports delimited or fixed length formats. Export utility has easy to learn and to use wizard interface. All modern versions of Microsoft SQL Server are supported. This handy utility helps database users to create text file for selected table within seconds.

Export Table for IBM DB2 helps to save table’s data to text file. The program supports delimited or fixed length formats. Export utility has easy to learn and to use wizard interface. All modern versions of IBM DB2 are supported. This handy utility helps database users to create text file for selected table within seconds.

ORTWIN is a program for the state-wide inquiry of the localities, postal codes and telephone selections in Germany. It finds postal zip codes, telephone pre selections, coordinates and ground level elevations. The program determines municipal codes, local center points, car license codes, topographic maps, Unlocodes and much more. It arranges localities hierarchically into the structures federal state, administrative district, rural district, town, municipality, local quarter and domicile. The program performs perimeter searches and distance calculations. It finds landscapes on different levels, natural units and snow- and wind load zones of all localities. In a radius around a place or around a postal code area covered localities and postal areas can be clearly represented by a comfortable perimeter search. They can also be arranged in a list, stored as a file and printed. For the local inquiries and perimeter searches a data base with more than 120.000 geo coded localities is available. The program represents local data, determined by local inquiries and perimeter searches, in graphic overviews and data lists. The program supports conversions between different coordinate systems and the distance calculation between the places. It calculates with Gauss Krueger coordinates referring to the Potsdam Datum (Bessel ellipsoid, Rauenberg) and with Geographic Coordinates on the geodetic datum WGS84. It also works with UTM coordinates, which refer to the datum ETRS89 (GRS80, geocentric). The functionality of the program is described in a detailed electronic manual. The program can be run on most common networks and it is possible to use Terminal Services on WINDOWS Servers. The client installations are done automatically.

Mailing list and label software. Ideal for personal or small business use. Maintain an unlimited number of name/address records. Maintain an unlimited number of separate address lists. Print mailing labels. Print hard copy reports. Import records from DBF (dBase) and ASCII files. Set filters to work with any sub-set of records.

ORTWIN is a program for the state-wide inquiry of the localities, postal codes and telephone selections in Germany. It finds postal zip codes, telephone pre selections, coordinates and ground level elevations. The program determines municipal codes, local center points, car license codes, topographic maps, Unlocodes and much more. It arranges localities hierarchically into the structures federal state, administrative district, rural district, town, municipality, local quarter and domicile. The program performs perimeter searches and distance calculations. It finds landscapes on different levels, natural units and snow- and wind load zones of all localities. In a radius around a place or around a postal code area covered localities and postal areas can be clearly represented by a comfortable perimeter search. They can also be arranged in a list, stored as a file and printed. For the local inquiries and perimeter searches a data base with more than 105.000 geo coded localities is available. The program represents local data, determined by local inquiries and perimeter searches, in graphic overviews and data lists. The program supports conversions between different coordinate systems and the distance calculation between the places. It calculates with Gauss Krueger coordinates referring to the Potsdam Datum (Bessel ellipsoid, Rauenberg) and with Geographic Coordinates on the geodetic datum WGS84. It also works with UTM coordinates, which refer to the datum ETRS89 (GRS80, geocentric). The functionality of the program is described in a detailed electronic manual. The program can be run on most common networks and it is possible to use Terminal Services on WINDOWS Servers. The client installations are done automatically.

With MS SQL Recovery, all types of MS SQL databases can be recovered, even those which are stored on damaged, formatted or otherwise inaccessible disks. The software, provided by one of the industry leaders in recovery software, allows database administrators to either manually or automatically recover and rebuild databases. Using the automatic mode, the software can locate and restore lost databases using its powerful recovery algorithms. The program can also repair all of the tables and the structure of the database, even when only certain parts of the database can be located. With the manual mode, more severe damage can be repaired by more experienced users. There is also the possibility of previewing all recoverable information from the database, including a blob preview feature which supports images, text and office-type documents. As much as 2 GB of data for a single record can be exported for recovery. All versions of MSSQL from version 2000 and 2008 are supported, including 64-bit and Express editions. To find out more, visit http://www.diskinternals.com/mssql-recovery/.

Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.

Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.

Advanced ETL Processor works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite or any ODBC compliant database.

Another benefit of using Advanced ETL Processor its unique ability to load data from multiple files or even tables using mask

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.