Solved

Convert 6.5 SPs to Oracle - Any Tools Out There?

Posted on 1998-12-29
6
196 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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now