Solved

Convert 6.5 SPs to Oracle - Any Tools Out There?

Posted on 1998-12-29
6
230 Views
Last Modified: 2010-03-19
We are preparing to convert from SQL 6.5 (stored procedures and data) to Oracle due to the lack of a y2k compliant patch for 6.5.  
Are there any tools out there to help convert?
0
Comment
Question by:snydero
  • 3
  • 2
6 Comments
 
LVL 1

Author Comment

by:snydero
ID: 1092394
Edited text of question
0
 
LVL 2

Expert Comment

by:tschill120198
ID: 1092395
SP5 is listed as addressing y2k issues ("compliant with minor issues"):  
    "It is recommended to update SQL Server to Service Pack 5
     when available to meet Year 2000 compliance requirements.
     Service Pack 5 for the English version of SQL Server 6.5
     is scheduled for release in Dec ’98."
     (http://www.microsoft.com/technet/topics/year2k/product/user_view9796EN.htm)

Unless these minor issues are showstoppers, and y2k-compliency is the only reason you are converting to Oracle, converting seems like overkill.

0
 
LVL 1

Author Comment

by:snydero
ID: 1092396
Thanks for the SP5 info.  It is a business decision (risk assessment) that may drive the conversion.
For now, I'm still seeking tools to make conversion an alternative.
I'd like to invite more answers please.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 3

Expert Comment

by:joao_patrao
ID: 1092397
0
 
LVL 1

Author Comment

by:snydero
ID: 1092398
Thanks, several have pointed me to the Oracle page for Transparent Gateway.  
It does not appear to be available as a trial download.  I have sent a message to Oracle.  Does anyone know how to get a trial copy?
Thanks all!
Please post as an answer so I can give the points.
0
 
LVL 3

Accepted Solution

by:
joao_patrao earned 100 total points
ID: 1092399
You are right about the trial period...they dont have a trial copy of Transparent Gateway.

I hope i could help you.

bye and good luck.

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Virtual SQL Server 2014 Standard 35 93
TSQL XML Namespaces 7 24
SQL Group By Question 4 20
SQLCMD Output to file from xpcmd_shell 6 18
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question