Saturday, February 12, 2011

Frelancer DBA Activity

Data Conversion & Data Transformation from Legacy System

Data Conversion from
Non-Oracle Database((Dos,Sybase(ASE),db2,MsSQL,Mysql,Postgresql)) to Oracle Database
Oracle Database to Non-Oracle Database(Dos,Sybase(ASE),db2,MsSQL,Mysql,Postgresql)


===============================================================
On Demand Database Conversion
==>Old Data Transformation and Customize Conversion to New System.
==>Database Code Conversion(T-SQL code to PL-SQL Code and Vica versa)
==>Cross Os Platform Data Conversion(e.g. DOS to Windows or DOS to UNIX/LINUX)
==>Cross Database Support for Data Migration
===============================================================

Oracle RAC Database

We had Setup the 2-node RAC database on Sun Sparc Solaris 10 64 bit OS Platform.

Oracle Streaming Setup

My Goal:
Site-A 2-Node RAC database setup
Site-B 2-Node RAC database setup
How to achieve the two way(Bi-directional) data
synchronization & replication between two sites.


Solution:

Oracle Streaming Bi-directional Setup between RAC databases.

https://sites.google.com/site/gondaliahitesh/home/oracle-stream

Sybase RDBMS: ASE (Adaptive Server Enterprise)

Sybase Database Administration & Tuning
http://groups.google.com/groups/profile?enc_user=QySY5hMAAADgLMXrLe52x6LiQoaGEpvrWMj6vob75xS36mXc24h6ww&pli=1

Types of RDBMS