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:

Friday Apr 27, 2012

SAP database HANA sales disappoint

Not sure why the analyst thought HANA was going to 'blow it out of the water'. Oracle has had TimesTen for years and their are other in memory database that have been around for ten years or more.

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.

Thursday Dec 01, 2011

Legacy Application Migrations

Mainframe, Sybase Powerbuilder and Lotus Notes are all consider legacy applications:
ComputerWorld Article

Monday Oct 31, 2011

Win a copy of Migrating to the Cloud - 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:
Migrating to the Cloud

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

Thursday Jun 02, 2011

Sybase as the default SAP database engine

Interesting article. The biggest issue, and it is not covered in the article, is the fact that most companies are standardizing on databases other then Sybase. So, why would they then move their SAP database engine to Sybase? http://www.informationweek.com/news/software/enterprise_apps/229700180

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
« April 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
   
       
Today