Projects tagged ‘java’ and ‘mssql’

Apache Cayenne is an open source persistence framework licensed under the Apache License, providing object-relational mapping (ORM) and remoting services. With a wealth of unique and powerful ... [More] features, Cayenne can address a wide range of persistence needs. Cayenne seamlessly binds one or more database schemas directly to Java objects, managing atomic commit and rollbacks, SQL generation, joins, sequences, and more. With Cayenne's Remote Object Persistence, those Java objects can even be persisted out to clients via Web Services. Or, with native XML serialization, objects can be even further persisted to non-Java clients - such as an Ajax-capable browser. [Less]

LiquiBase is a DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based ... [More] descriptive manner and checked into source control. LiquiBase aims to provide a solution that: * Supports merging of changes from multiple developers * Works well with code branches * Allows you to manage production data as well as various test datasets * Works in an environment where multiple machines will be attempting to migrate the database concurrently * Supports automated change-applying or generation of SQL scripts that can be approved and applied by a DBA * Supports rolling back changes * Database "diff" tool [Less]

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the ... [More] hierarchy of database tables via child and parent table relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. [Less]

Apatar is an open source data integration application to help join your desktop data with the web. Apatar effectively integrates data and applications, and provides visual job designer and mapping ... [More] , joins, filtering, data cleansing and validation capabilities. Connectors include MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SalesForce.Com, SugarCRM, Compiere ERP, Goldmine CRM, XML (local and web-based), flat files (CSV, TXT), Webdav, Buzzsaw, LDAP, Amazon, RSS and even Flickr; more connectors are under way. [Less]

SymmetricDS is web-enabled, database independent, data synchronization/replication software. It supports bi-directional and partial synchronization across heterogeneous databases in near real time. ... [More] The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage. It was first built to replicate changes between "Retail Store" (POS) databases and a "Corporate" central database. [Less]

SchemaCrawler is a command-line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is ... [More] also an API that improves on the standard JDBC metadata. [Less]

benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or ... [More] configuration files. Data can be imported from and exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options. [Less]

Simple to use library that handles a lot of things for you.

A vendor neutral system that appears to work exactly the same way in PHP, ColdFusion, ASP.NET or Java. It gives content providers some control over the style of their content. If the server is ... [More] changed from one of these languages to another the users will not notice. [Less]

MotivationMany power users and developers ofter face problem with multiple datasources running on different database engine. This tool should help with the following scenarios. ScenariosMoving data ... [More] from one database to another within the same database architectureOracle to Oracle or MSSQL to MSSQL NativeMode Moving data from one database to another with different database architectureOracle to MSSQL or vice versa PortableMode [Less]