Solved

Convert 6.5 SPs to Oracle - Any Tools Out There?

Posted on 1998-12-29
6
248 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

622 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