Author Topic: Migrating from SQL Server to Oracle  (Read 3214 times)

yalla

  • Newbie
  • *
  • Posts: 4
    • View Profile
Migrating from SQL Server to Oracle
« on: March 23, 2009, 06:32:34 AM »
How to migrate from sqlserver to Oracle any information 


Mike

  • Administrator
  • Hero Member
  • *****
  • Posts: 2040
    • View Profile
Re: Migrating from SQL Server to Oracle
« Reply #1 on: March 23, 2009, 07:10:54 AM »
How to migrate from sqlserver to Oracle any information 

This might help:
http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html

"SwisSQL - SQL Server to Oracle Migration Tool helps you migrate MS SQL Server Transact-SQL Procedures, Functions and Triggers to Oracle PL/SQL language. When enterprises migrate from MS SQL Server to Oracle, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating MS SQL Server Stored Procedures to Oracle PL/SQL. Using SwisSQL - SQL Server to Oracle Migration Tool and through AdventNet's superior support, enterprises can realize significant time and cost savings during the migration and testing process."


This also looks like it might work:

http://www.spectralcore.com/fullconvert/tutorials/convert-mssql-sql-server-to-oracle.php

"migrate Microsoft SQL Server database to Oracle in under five minutes"

# Full Unicode support
# Creates all data, indexes and foreign keys
# Data throughput of thousands of records/sec
# Easily handles tens of gigabytes of data
# Advanced command-line support
# Built-in scheduler for recurring conversions
# BLOB and MEMO fields are fully supported
# Runs on all Windows versions