Hi All
I have Laserfiche Rio 10 on SQL Server 2008, I decided to switch database to Oracle Database 10gR2.
How can I do that?
Why would you want to change to Oracle? I have been trying to get the resources to switch OFF of Oracle for years. Laserfiche's support for Oracle is lacking compared to SQL.
Its about 10% more expensive, plus paying Oracle for licensing, and you will run into bugs and performance issues far more often.
I recommend you ask around and weight the pros/cons.
Hi Kenny Fox
because We use sql server with MSDN License(not full license ) , our Internal Auditor send us report to get sql server license or using your Oracle License - we already have Oracle License used in Main System
You would have to pay the Laserfiche licensing for Oracle and work with LF tech team to get a migration utility.
There are far fewer end users on Oracle, so as Kenny stated, you will see more issues that with the SQL edition. Even though you have Oracle already running, it is my opinion that long term, you are ahead to invest in a MS SQL server.
I agree with Bert. You should consider getting a full SQL license. Depending on the load, you could probably use it for other databases on the same server.
Long and short term, I don't think investing in Oracle as your Laserfiche back end is wise. When I asked for the numbers a few years ago, Oracle-Laserfiche customers made up just over 0.01% of the user base. If you add up the additional support challenges, bugs, and the additional maintenance, it will likely be cheaper to stick with SQL.
Hi Ahmed,
There is actually a Laserfiche license change to switch from SQL to Oracle. Your VAR should be able to provide more details and pricing etc.
As for a migration path, I'm not sure there is anything from Laserfiche, but I'm sure there must be tools provided from Oracle for such a migration (seeing as it's in their interest!).
Hope this helps point you in the right direction! 
