SwisSQL Helps Communications Management Company in migrating their
database from Sybase ASE to Oracle
Snapshot
The Communications Management
Company is a leader in design, population,
and management of communication system
data warehouses. The company offers
database development and administration
for mission critical applications
from satellite system control to publishing
and manufacturing systems.
Business Challenge
The Communications Management Company
wanted to migrate 38000 lines of code
in Cellular Communication Management
application from Sybase ASE to Oracle.
The Company wanted automated, reliable,
and affordable Stored procedure migration
solution.
The name of the Communications Management
Company has not been revealed on request
considering the competitive environment
prevailing in that segment.
SwisSQL Solution
SwisSQL automated more than 90% of
the database migration, saving cost
by 73%. It offered a productive, predictable,
and controlled migration environment
at an affordable price.
SwisSQL Benefits
Simple and reliable migration
ensuring application and data Integrity Cuts cost and time drastically,
offering greater than 90% automation
Move rapidly to deployment
Manual
Migration
Lines
of code
38000
Team
size
4
Total
Duration
3
months
Person
months
12
Cost
$84,000*
*
- calculated at $7K per person
per month
SwisSQL helps Communications Management Company
in migrating their database from Sybase ASE to
Oracle
The Communications Management company saved
over $ 61,600* and 9 person months,
migrating their Cellular communications management
applications from Sybase ASE (Adaptive Server
Enterprise) to Oracle using SwisSQL
Business Challenge
The Communications Management Company, a leader
in the design and communication system data warehousing.
The company developed a mission critical Java
based n-tier application with Sybase ASE to manage
cellular communications. The solution was designed
to manage all the aspects of cellular communication
such as government compliance, financials, lease
terms, and rent.
As the customer was consolidating to Oracle 9i,
there was an immediate need to migrate their database
from Sybase ASE to Oracle 9i. With the application
having around 248 Sybase ASE Transact-SQL stored
procedures, around 38000 lines of code were to
be migrated from Sybase ASE Transact-SQL to Oracle
PL/SQL. The Communications Management Company
faced the challenge of migrating all the stored
procedures to Oracle and ensuring all stored procedures
retained their application logic.
Exploring all the Migration Options
The Communications Management Company wanted
to use the best-stored procedure migration methodology.
The Company’s Migration team did a quick
evaluation of manual migration and automated migration
considering migration coverage, migration efficiency,
time, and cost.
Migration Options
The Communications Management Company planned
to explore all migrations options
Manual Database Migration
Automated Migration
The Communications Management Company ruled out
manual migration in the initial analysis phase,
as it was obviously not a feasible solution due
the following factors
Increased complexity of migration
Re-writing stored procedures manually is error-prone
as it depends solely on the developer’s individual
logic with a set of related complex and repetitive
bugs that increase the complexity for migration.
High Cost and Expenditure
Manual migration required more experts from both
Sybase ASE and Oracle domains for accurate conversion.
With increased time and migration complexities
in manual migration it proportionately increases
the cost of migration.
SwisSQL Solution
After detailed analysis, the Communications Management
Company chose SwisSQL as it emerged to be productive,
timesaving, and cost-effective migration solution with
highly responsive technical support.
The Communications Management Company used SwisSQL
to execute an efficient and controlled database migration
project well ahead of schedule due to the following
factors:
Simple and productive migration solution
SwisSQL’s simple and intuitive solution helped
the Communications Management Company all through the
complete migration cycle. Starting from fetching objects
from a live Sybase ASE database or loading object scripts
from local directory, migrating database objects and
deploying the converted objects into the Oracle database,
SwisSQL was able to handle every step effectively.
SwisSQL automated more than 90% of the migration without
any need for manual intervention. With most of the complex
migrations automated, it reduced the need for additional
expensive database migration experts.
Easy Deployment of the Migrated Objects
With SwisSQL, the migrated objects can be directly
compiled in oracle, this helped the Communications Management
company fix most of the runtime issues and helped them
reduce the application testing effort while deploying
the migrated objects.
Move Rapidly to Deployment
90% automated conversion of the migrated code drastically
reduced the deployment effort (that includes compilation,
testing, bug fixing and release of the migrated code)
by 50%. This helped the Communications Management Company
to get into production faster.
The Communications Management
Company Time and Cost Savings
Project
Details
Manual
Migration
SwisSQL
Migration
SwisSQL
Benefits
Lines of Code
38000
38,000
-
Team size
4
2
-
Total Duration
3 Months
1.5
Months
-
Person
months
12
Months
3
Months
9
Months
Cost
$84,000
$22,400
$61,600
* - Resource cost calculated at $7K per person
per month
Cost Working
SwisSQL
Sybase to Oracle Migration Tool- License for 50,000
lines:
$ 1,400
Migration
Team Resource Cost:
$ 21,000
Total
$ 22,400
SwisSQL Solution Benefits
SwiSQL helped the Communications Management Company
to execute an efficient database migration project saving
cost, time and realize market benefits immediately.
Complete and Reliable Migration: SwisSQL
offered the Communications Management Company a complete
and reliable solution that helped them to migrate
and deploy the migrated objects efficiently.
Efficent and Cost Effective Solution: SwisSQL's
90% automated migration environment helped
the Communications Management Company save 73 %
of possible cost to have spent on manual migration.
Time and Cost Savings with SwisSQL: SwisSQL
helped the Communications Management Company save
about $61.6 K* and also saving 9 person
months effort.
Responsive Technical Support: SwisSQL's responsive
technical support helped the Communications Management
Company in resolving and closing technical issues
during migration. Responsive technical support was
crucial for the project success, other free migration
solutions from database vendors themselves do not
offer technical support. Without technical assistance,
the migration pace tends to slow down to manual migration
levels.
