I recently did analysis on a ms sql 2000 to oracle 8i and 9i migration...
the oracle migration tool on the oracle website is where you need to start,
it will identify all the stuff in your DB that cannot be converted
automatically and provided a good starting point. It also identifies all
incompatibilities in table names and column names, etc, etc, etc...
Your cfqueries might not work depending on how you have written them. Other
than testing them one by one, I did not find any solution to this. Another
big issue is stored procedures, as PL/SQL is very different than T-SQL.
Some stored procedures are converted automatically with the Oracle Migration
Workbench, but most need some level of human intervention. So your efforts
are going to be greater depending on the complexity of your stored procs,
and how your sql db was designed.
Gabriel
-----Original Message-----
From: Michael Hodgdon [mailto:[EMAIL PROTECTED]
Sent: November 4, 2003 10:16 AM
To: CF-Talk
Subject: FW: Not Subscribed: OT: SQL Server to Oracle migration
I have an Off Topic question for the list.
I have a few databases that I was thinking of migrating from SQL 2000 to
Oracle 8.1.7.1.5 . I am wondering two things:
1) Will the SQL in my CF Templates still work after the migration?
2) Are there any major pitfalls or recommendations you could give me in
terms of the actual migration?
Any help is appreciated.
Michael
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
