Saturday Jun 30, 2012

IBM DB2 AIX RISC to Oracle Linux Sun x86

Mentioned RISC to x86 migrations a couple blogs ago and now there is a new white paper out by Oracle on just this topic. The white paper goes into detail on the Oracle Linux and Database installation. It also shows how to use the free Oracle SQL Developer tool to migrate the data:
Migrating from IBM DB2 AIX to Oracle Linux Sun x86

Wednesday Jun 13, 2012

Migrating C/C++ embedded SQL code

When moving from Sybase C Embedded SQL to Oracle C Embedded SQL, there are no tools are process. Since Embedded SQL is a standard it should be pretty straight forward. The biggest challenge is going to be SQL that is Sybase specific. I would map the process out as follows:
1. Change include files from Sybase Embedded SQL libraries to Oracle Pro*C in each module.
2. Make sure the C code does not test for Sybase specific error messages. Fix where needed.
3. Run all modules through the Pro*C pre-compiler. Fix any embedded static SQL that does not make it through the pre-compiler using the SQL Developer scratch pad editor.
4. Compile using C compiler.
5. Test run the application fixing any dynamic SQL that does not work against Oracle using SQL Developer scratch pad editor.
SQL Developer can be downloaded here:

Thursday Jun 07, 2012

AWS EC2 Oracle RDB connection to Oracle Database Instance

Provisioning my Oracle database instance to AWS EC2 RDB was easy. Just a few clicks! However, getting my connection to my Oracle cloud database was not as easy. A couple things that are not obvious (using Oracle SQL Developer):
1. Need to set up a database security group.
2. Need to use end point for the host name.
This video is the best one on the internet to explain both points:
Youtube video on Oracle AWS RDB

Tuesday Mar 27, 2012

SQL Server 2012 price increase - what is the impact to migrations ?

SD Times as well as other publications have been discussing the pricing change that is coming for Microsoft SQL Server 2012 when it was released on March 6th.
SD Times SQL Server 2012 license changes bring new concerns.
It will be interesting to see what impact this has on folks that are considering Oracle or looking to migrate from Sybase to SQL Server or Oracle.

Friday Oct 14, 2011

Win a free Cloud Book - Just follow me on Twitter

Win a copy of this book. All you need to do is starting following me on Twitter Tom Laszewski
After two weeks, I will pick two twitter follows. These two follows will receive a free copy of this book:
Information Integration, Data Migration and Consolidation

Tuesday May 24, 2011

Migrating DB2, Sybase, SQL Server to Oracle Exadata and the cloud

Customers and partners that are migrating from non-Oracle database platforms to the Oracle 'cloud in-a-box' solutions(Exadata) often ask: 'What is the most difficult aspect of the migration?' Is it the processors, applications, application middleware, storage, management software, database, network or something else. The answer is really...it depends. I always hated that answer but it does depend on: 1. Is your network already built to handle a high amount of traffic (high bandwidth) and GB+. 2. How much database logic does your system have. Are there a lot of stored procedures? 3. What is the application built in? Can the language easily be moved to the cloud? 4. Do you want to virtualize the application and use Oracle VM? 5. Does your storage or processors need to upgraded? All these components need to be considered. So, it does depend. More on this soon.
About

Migrating legacy client/server and mainframe technologies to the Oracle cloud.

Search

Categories
Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today