SQL Server and Oracle 10g 1

[andy2325]

Is is possible to concurrently use SQL Server 2005 and Oracle 10g together in the same web application. Say SQL Server will be used for the user's and logging actions and then Oracle 10g will be used for the information that is to be displayed to the user.

 

[HarleyQuinn]

It should be absolutely fine, just seems to lengthen things a bit from the web app programming point of view. Is there a particular reason you want to use both?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[andy2325]

Well our in house data collection system stores information to Oracle 10g and with Visual Studio 2005/2008 when creating user's and roles it seems they use SQL Server.

 

[andy2325]

Would it be better to copy data periodically from Oracle 10g to SQL Server instead of using both?

 

[HarleyQuinn]

I can imagine that set-up.

As I say, it shouldn't cause a problem at all for you.

Cheers

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

It's up to you, the web app would have to be changed eventually to only use the SQLServer DB, but if it works in the current situation as I say, it's completely up to you.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.