Server Tools

Debugger for MySQL offers a balanced set of advanced debugging features that will help you minimize the time needed for managing and testing even the most complex stored functions and procedures. Its unique capabilities combined with an affordable price and a steep learning curve make it an excellent choice for novices and professionals alike.

If you are looking for a “one-stop” solution that will efficiently satisfy all of your code debugging needs and provide a comfortable development environment, look no further than Debugger for MySQL - your step-by-step guide to flawless code!

Advantages and key features:

• Efficiently debug and manage stored MySQL procedures and functions
• Continue debugging into nested procedures and functions
• Use conditional breakpoints
• Use tooltip expression evaluation
• Run SQL commands in the debugging context
• Debug code without modifying procedures and functions on the server
• Debug anonymous code (similar to anonymous blocks in Oracle)
• Benefit from full Unicode support

CompareData is a native Windows cross-dbms application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve some/all data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare data of two sql queries and dbms metadata.

Features:

• Compare data between two tables/views of the same or different names
• Compare columns having the same or different names and/or data types
• Compare data of two sql queries
• Synchronize table data at row level, table level or folder level
• Compare data of a group of tables/queries or all tables with one command
• Compare resultsets of any size.* See comparing large resultsets
• Compare schema for two tables or a group of tables including: columns, indices, primary key, foreign keys, triggers and table permissions
• Compare stored procedures/functions
• Command line or internally schedule comparisons and data synchronization
• Multi-threaded, multicore-ready design. Native 64-bit version is available.
• Free for comparing table/view data. New evaluation period with each new release.

KeyAccess is a light-weight Object-Relational Mapping (ORM) tool, using existing databases as the starting point to generate a domain model. The main goal is reduce and sometimes eliminate manual updating between your domain object model and the underlying databases, while still being able to use arbitrarily complex SQL queries. In addition, KeyAccess doesn’t mandate a special architecture or framework – it will work in any application using JDBC.

New in this Version:

• Added support for Character large object (Clob) to java.lang.String conversions
• Added support for ORDER BY clauses in the generated query methods

SOASYNC is a global data synchonization software based on Service Oriented Architecture. Once running on a Java Applicaiton Server, SOASYNC is ready to serve the authorized users to perform data synchronization globally across over 24 presently supported databases over the Internet.

Create a mapper to map source and target column by column, datatype by datatype or map cross datatypes or one-to-one, one-to-many, many-to-one, and many-to- many maps and hit Sync. Or have the sync scheduled whenever you like. SOASYNC can even map the entire source database to the target database with a click of a button even if the source and the target databases are not identical. Auto generated maps may be customized and edited at any time. Syncing in batch is also supported.

Features:

• Synchronization Engine: SOASYNC is a complete solution to data synchronization. In addition to JDBC type API, SOALIB have strong support for Text, Binary, XBase, and Memory databases. SOASYNC does not make complete use of JDBC drivers as many drivers are incomplete. Instead SOASYNC uses the driver as a gateway to get database information from the system tables. SOASYNC synchronization uses the database specific features to get the most from the synchronization. Using the powerful API of SOALIB, SOASYNC goes deep inside the database and does what it is good at: Synchronize source with target both uni- or bi-directionally.
• Security: SOASYNC web services work with SSL, 128 bit strong encryption, secure user authentication, encrypted data storage, fault tolerance in synchronization, 512 bit service instance handles, automatic no-activity service timeout and user locking. Future version will have read-only, write-only database table and columns and more precise control of sync.
• Eclipse Client: SOASYNC client is based on the Eclipse technology with a beautiful graphical layout, drag and drop support, multiple viewers, context sensitive help, built-in browser, and multi-os ready. SOASYNC client is designed to become productive from day one, even though it is based on SOA, a new and complex technology. SOASYNC hides away most of the complexity behind the scene. The user of SOASYNC sees it just like any other graphical application.
• Additional Features: SOASYNC may be used to transfer files from PC to server, and vice versa acting SOASYNC as a backup software. Save your secure data in the safe environment of SOASYNC server. The File service engine also have remote file comparator, which can be used to find identical files. When it comes to generating reports, SOASYNC have powerful report generation API which can be used to generate HTML and PDF reports. All reports are generated on the server. SOASYNC also have a Query Editor to view or change data from the client.
• Multi-platform Client: SOASYNC client work on Windows, Linux, Machitosh, and Solaris. The server works on even more platforms. SOASYNC may be used remotely using SOALIB's client API available in Java, Java Micro Edition, C# and C++. These API may be used in your own applications, for example to, synchonize your mobile data that take advantage of SOASYNC features. Backup your mobile data in SOASYNC server and much more.