Hello guys, suppose we an asp application that has different version , one the works on sql server and the other works on oracle. Giving that the database structure, procedures parameters are exactly both on the same. If move an crystal report file for sql
server application to the oracle application, would there be a problem? do I need to do anything extra?
C#.Net Developer
"my software never has bugs. it just develops random features"
thanks man, that should be a problem as I'm doing this for a customer and I don't have oracle database installed (only sql server) at the moment and can't get one soon too :(... is there any other way ?
C#.Net Developer
"my software never has bugs. it just develops random features"
Member
13 Points
38 Posts
Moving Crystal report...
Mar 05, 2012 11:08 AM|InsaneDev|LINK
Hello guys, suppose we an asp application that has different version , one the works on sql server and the other works on oracle. Giving that the database structure, procedures parameters are exactly both on the same. If move an crystal report file for sql server application to the oracle application, would there be a problem? do I need to do anything extra?
"my software never has bugs. it just develops random features"
Member
434 Points
279 Posts
Re: Moving Crystal report...
Mar 05, 2012 12:56 PM|Inayat Rasool|LINK
There should not be any problem with it however you need to change the provider in crystal reports.
DATABASE--->SET DATABASE LOCATION ---> CREATE NEW LOCATION --->OLEDB(ADO) ---->Microsoft OLEDB Provider for ORACLE.
and
In C# Code if you are referencing SQL SERVER connection like connection string and database name.
Apart from that, everything should be good.
------------------------------------------------------------------------------------------------------------------------------------------------------
* If my post solves your problem, please mark as answer.
Member
13 Points
38 Posts
Re: Moving Crystal report...
Mar 05, 2012 12:58 PM|InsaneDev|LINK
thanks man, that should be a problem as I'm doing this for a customer and I don't have oracle database installed (only sql server) at the moment and can't get one soon too :(... is there any other way ?
"my software never has bugs. it just develops random features"
Member
434 Points
279 Posts
Re: Moving Crystal report...
Mar 05, 2012 05:33 PM|Inayat Rasool|LINK
I don't think you should have anyother problem other than you get Oracle and have similar database schema.
------------------------------------------------------------------------------------------------------------------------------------------------------
* If my post solves your problem, please mark as answer.