Skip to content

Database tool 2

August 6, 2009
tags:
Open Database Connectivity Components:
Open Database Connectivity (ODBC) is Microsoft’s strategic interface for accessing data the heterogeneous environment of relational and non- relational database management systems. ODBC is a core component of Microsoft Windows Open Services Architecture. Apple has authorized ODBC as a key. With growing industry support, ODBC is quickly emerging as an important industry standard for data access for both Windows and Macintosh applications.
1. An ODBC-enabled “front-end” or “client” desktop application, also known as and “ODBC Client.” The computer-user sees this application on the computer screen.
2. An ODBC Driver for a “back-end” or “server” DBMS (Database Management System). This DBMS application resides on a computer that is used to store data for access by several users. This application is not what is loaded on the end user’s computer. This server application is usually more robust (faster, with centralized security, and backups of data, and so forth) than the client application. The ODBC Driver resides between the ODBC Client and the DBMS; however, it is loaded on the front-end computer.
JDBC:
The JDBC API

The JDBC API provides programmatically access to relational data from the Java programming language. Using the JDBC API, applications can execute SQL statements, retrieve results, and propagate changes back to an underlying data source. The JDBC API can also interact with multiple data sources in a distributed, heterogeneous environment.

JDBC Driver Manager

The Driver Manager class is the traditional management layer of JDBC, which can connect Java applications to a JDBC driver. Driver Manager is one of the  backbone of the JDBC architecture.
JDBC-ODBC Bridge:

The Java Software Bridge provides JDBC accesses throw ODBC drivers. First, you need to load ODBC binary code onto each client machine that uses this driver. The ODBC driver is most appropriate on a corporate network where client installations are not a major problem, or for application server code written in Java in three-tier architecture.

ODBC-JDBC Bridge:
An ODBC-JDBC bridge consists of an ODBC driver, which uses the services of a JDBC driver to connect to a database. This driver translates ODBC function calls into JDBC method calls with securable.
Database comparison tools:
1.  These tools enable the end use to compare the schema and data of two databases, report the differences and script the changes required to synchronize one database with another. Identify Data differences between tables in different databases or the same database
2.  Identify structure or metadata differences between databases.
3.  Create an HTML summary report of the differences between specified tables between two databases.
4.  Copy Data from one database to another.
5.  Compares all database objects including tables, views, stored procedures as well as permissions, user defined functions and so on
1. SQL Delta 4.1 for fast SQL database compare tool
2.‘Compare Database’ allow you to compare Access databasesto each other
Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: