Here are a few gotachas you want to look at:
1) Dates. Not only is the syntax different, but also the functions are quite a bit differnt as well. The getdate() function is sysdate() for example. Functions for adding and manipulating dates are different as well.
2) Join syntax: SQL Server will often add SQL Server specific text when you create a join through its wizards. As long as you're writing toward the ANSI SQL spec you should be OK.
3) Stored Proceedures. You will need to rewrite all stored proceedures as referential cursors. (Referenal coursor is a special type of Oracle package). You will also need to change the way CF accesses the stored proceedure as well.
4) Views,Indexes, Triggers and Primary (and forgien)Key Columns: You will need to create those as well. If you're using SQL+ you need to programatcally use the alter table command to deal with these items.
5) Identety Columns are called sequences and are created programatcally if you're using SQL+ using the CREATE SEQUENCE command
6) SQL +. Although there are GUIs such as Toad out there that will help manage your database, one fine day you might encounter a project that can only be accessed in SQL+. In comparison MS Query Analizer is more feature rich. (I'm sure that a few of my fellow CF Talkers will say how wonderful SQL+ is and how it provides hard access to everything on e needs from a simple command line)
7) Security: SQL Server provides the options of using NT authentication for development machines... No such option for Oracle.
8) Loading data. Loading data into oracle is always intesting if you're using SQL Loader. If you're using SQL+ you will need to create a package to load data from a comma delimited file and use SQL Loader to interpret the data.
Oracle is a great database (and sometimes expensive)for high traffic sites that works on many differnet platforms besides for windows.... however, its not for the feight of heart... and requires a long term commitment to the product.
Jeremy
>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]
