 |
Altova MAPFORCE 2004 Enterprise Edition is the premier XML/database/EDI mapping tool for advanced data integration projects. It is an award winning, visual data mapping utility that auto-generates custom mapping code in multiple output languages, including XSLT, Java, C++, and C#, enabling programmatic exchange of enterprise data in any data integration application. With the power to map any combination of XML, database, and EDI data into XML and/or databases, Altova MAPFORCE 2004 is the definitive tool for data integration and information leverage. Altova MAPFORCE 2004 began winning awards and rave reviews as soon as it was released. This graphical data integration tool is just so powerful and so easy to use that it will soon rival Altova XMLSPY in popularity. You simply open your information source(s) and target(s) then drag connecting lines between the elements that you wish to associate. MAPFORCE 2004 automatically connects matching child elements. Data processing functions can be easily dropped into your mapping projects, and your data sources and targets can be linked through them for alteration on the fly. Popular function libraries come standard with MAPFORCE 2004, and you can now add existing XSLT files as custom function libraries. Once your mapping is defined you can instantly preview your output. Mappings to a target XML Schema produce XML documents, while mappings to a target database produce SQL scripts as output. In addition to supporting XML sources and targets, MAPFORCE 2004 Enterprise Edition is the first data integration tool to support EDI data sources and all major relational databases as both the source and/or target of a mapping, allowing EDI-to-database, EDI-to-XML, XML-to-database, database-to-XML, and database-to-database mappings. Altova MAPFORCE 2004 Enterprise Edition is the essential tool for data architects, database developers, and systems integrators working to programmatically integrate data cost-effective standards-based way.
xml xml mapper xml software xsl transformation schema xml schema w3c schema dtd xsl xslt xsd
|
 |
Create large entity relationship diagrams with CASE Studio 2 LITE database design tool and generate complex SQL scripts automatically. Key featueres include: Visual creation of Entity Relationship Diagrams (database design), definition of referential integrity rules, generation of complex SQL scripts, generation of detailed HTML and RTF reports, model explorer, to-do list etc.
Supported databases: Access, Advantage Database Server, Clipper, DBISam, DB2 UDB, Firebird, Informix, Ingres, InterBase, MaxDB, MSSQL, MySQL, Oracle, Paradox, Pervasive, PostgreSQL, Sybase ASE.
database design tool software modeling entity relationship diagram database design tool
|
 |
Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses naitive API.
Data targets:
Oracle 7-9i database (using OCI API)
SQL server 7- 2000 (using BCP API)
ODBC source (using ODBC API)
Data sources:
Text files
Any ODBC source
Repository:
MS Access
Oracle
MS Sql Server
Interbase
MySQL
PostgreSQL
This product features:
Great performance - hundreds of records per second
Comprehensive logging
Rejected records file
Integrated Expressions builder
Allows the user to perform calculation during the loading process such as splitting fields, concatenations, data formatting, and loading cross/pivot tables.
Oracle
There are two ways of loading available:
Oracle direct path loading
Conventional path
MS SQL server
This software uses the same API as Microsoft DTS service.
ODBC
Any ODBC compliant database.
Other features are:
Easy Repository switching
Data Preview
Mapping editor
Exports
SQL scripts editor
Packages editor
Integrated Scheduler
Logging
Lookups
Email Notifications
File Operations
Check Files
Compare Files
FTP Downloads
Applications
oracle ms sql server bcp sql loader odbc etl datawarehouse repository ms access oracle ms sql server
|
 |
Minutes are worth more than money. Spend them wisely.
Thomas P. Murphy
It is common knowledge, that working with databases is time- and energy-consuming. At times it can really get on your nerves, when you have to do the routine work of picking out necessary information from databases, sorting, comparing the data and forming pages for printing! And all these operations take away the most valuable thing we all have ? THE TIME OF OUR LIFE.
To release you from the trivial round described above and to save your time, DESKTOP Company presents to your attention and evaluation a new product - SQL Mage for MySQL. It is a powerful and easy-to-use SQL editor, which provides various essential possibilities for database users, developers and administrators.
To make work with databases more convenient, the program uses profiles, which can be edited, renamed, duplicated etc. according to the user?s desire. This program enables the user to perform all standard operations with the databases: look through tables, fields or data, pick out necessary information using SQL scripts (SQL syntax highlighted), sort data according to the necessary criteria. Besides that, SQL Mage for MySQL allows to print out the list of databases, the list of fields of the specified table, data and even SQL scripts, preserving their original font and colour.
The editor itself is implemented as a set of tabs, each of which works like a separate SQL editor. Every single tab has its own history, can be added, deleted or cleared.
SQL Mage for MySQL has an intuitively understandable and user-friendly interface, which makes work with the program easy and pleasant. 15-days trial period will give you a possibility to fully enjoy the magic of SQL Mage for MySQL.
So, as Benjamin Franklin said: ?Well done is better than well said?. Don?t lose your time, try SQL Mage for MySQL right now!
database tools sql tools mysql my sql schema difference database compare tool sql preprocessor sql preprocessor database database schema
|
 |
DTM SQL Editor is a set of powerful database management tools that allow you to achieve two goals - to have unified access to different types of databases and to have a set of solutions that makes processing your data easy.
DTM SQL Editor gives database users, developers and administrators an ability to access different databases, whether desktop or client-server ones (provided you have ODBC or IDAPI driver or OCI interface installed).
This is very convenient, since most organizations use several different types of databases installed and each stores data in different formats and with varying parameters. Having a program that can get data from various sources is often essential. Furthermore, in addition to letting you quickly switch between different data sources, DTM SQL Editor lets you see database schema and results of the query execution.
The program gives you a powerful set of tools to edit sql scripts and to build sql statements, utilizing convenient wizard-like interface. The program also contains connections manager, database schema viewer, option to view execution history and a lot of other handy tools conveniently tied in a single user interface. The application supports clipboard and data export tools and can export data to plain text, HTML or XML documents, and Microsoft Excel spreadsheets. You can also save the results of your query as a set of SQL statements.
The other advantages of DTM SQL Editor include one-click access to the file history and the history of the scripts you executed, syntax highlighting, multilevel Undo/Redo features and integrated searching and replacement tools. Program's step-by-step SQL builder (query builder) is the most intuitive and natural way to build complex SQL statements visually without submersing into SQL.
This program supports plug-ins and comes with SDK (software developer kit), which gives you an opportunity to significantly increase the range of possible applications for the program.
sql editor query builder export schema script execution vss odbc set
|
 |
Speed SQL IDE is a full-featured integrated development environment (IDE) for Microsoft? SQL Server 2000 or 7.
SQL IDE enhances SQL database developer and programmer productivity by providing all the functionality of a database development and management tool, and a featured-packed SQL Editor, all within the one easy to use application.
Powerful programming and editing features enable both the beginner and expert database developer to quickly achieve results. SQL IDE comes complete with features to:
Speed code development (Auto Complete, Copy Object, Automatic Object Scripting, Create Templates)
Store and share code (Code Repository, Code Snippets, Groups)
Ensure code accuracy and suitability (Code Complete, Auto Correct, Syntax Checking, Verify)
SQL IDE's Object History - which stores a record of every object change - ensures that nothing is lost. Review and switch back to any version of any object.
Seamless integration with Microsoft? Visual SourceSafe? and other SCC compliant version control systems allows object check out and check in directly from within SQL IDE, eliminating the need for manual check out/in processes.
Benefits:
All-in-one integrated development environment obviates need for multiple database development tools .
Enhanced productivity through simple to use interface with powerful programming and editing features suitable for beginner and power users alike.
Integrates with version control and automates version control functions such as check out and check in.
Store SQL Scripts with the database to which they belong - no more searching for scripts
Use Code Snippets to store commonly used bits of code. Anyone can then drag and drop a code snippet into their script
Use code templates to create consistent scripts that are familiar to the workgroup
Use Groups to categorise and group objects - that way everyone can find the objects they need
And so much more.
sql source control sql ide sql development sql version control query analyser visual sourcesafe visual source safe vss version control speed sql
|
 |
SQL Batch Executor will run SQL scripts for any database with an ODBC compliant driver.
free sql odbc database db script editor access ms access microsoft access sql server
|
 |
Advanced SQL Code Collection (ASCC) is a powerful but easy to use tool for application programmers, database designers and database administrators who need to keep track of and reuse SQL source code fragments.
With its intuitive user interface, ASCC delivers a nice functionality and ease-of-use for a authoring tool. Queries, functions, other SQL code fragments of your past and curent projects can be stored, annotated, organized and easily retrieved. All these objects are displayed in a hierarchical tree format and are represented by icons. Using this hierarchical tree structure you can organize your code fragments in a way that makes sense to you.
The ASCC incorporates a powerful editor that enables you to write your SQL scripts efficiently. It includes SQL syntax highlighting, SQL code templates, power search engine and convenient bookmarks. A set of advanced Cut, Copy, Paste commands will help programmers with tedious repetitive chores like retyping text strings several times or moving text to and from the Windows clipboard. If you perform even a small amount of SQL programming, ASCC is a valuable addition to your toolset.
sql source code sql editor sql code collection xfilez sql template editor sql code collection
|
 |
Orbital's SQL Decryptor is the first product to decrypt SQL triggers, views, user defined functions and stored procedures in an easy to use Enterprise Manager-like graphical interface. It works quickly to decrypt items in Microsoft® SQL Server 7.0, SQL Server 2000 and MSDE. Orbital's SQL Decryptor allows for easy viewing of decrypted code with T-SQL syntax highlighting and multiple format exportation.
Features Include:
Works with Microsoft® SQL Server 7.0, SQL Server 2000 and all versions of the Microsoft® Database Engine (MSDE). No more loading up multiple programs and having to manipulate different scripts for each server.
Decrypts Objects of any size
Uses Unicode technology during the decryption process which allows for International use.
Simple point-and-click decryption. Does not require any T-SQL scripting knowledge.
Full T-SQL syntax highlighting for faster, easier reading.
Exports decrypted objects to SQL scripts or Rich Text Format (RTF) with syntax highlighting for easy portability and display to others.
Employs intelligent wizard technologies that allow for the decryption of entire databases with just a few simple mouse clicks.
Fully integrated WYSIWYG printing capabilities with T-SQL syntax highlighting.
Reduces time and money spent restoring lost source code to encrypted SQL objects. Never pay another developer to recreate and debug all of your lost SQL source code.
decrypt sql unencrypt decryptor unencryption decryption decode trigger view udf user defined function
|
 |
pcpmSqlGen Component generates SQL INSERT statements from SELECT statements and runs SQL Scripts from within your application. Use it to create test data, save data prior to test and then restore it after, distribute lookup tables or schema changes to remote databases. Quickly generate INSERTs without needing to remember column names.
database sql component programming development tools component generates sql inserts sql
|
|
|
