>Hi Troops,
>
>Well, my friendly PowerBuilder associates have asked me to post a question for them. Just goes to show that even they're impressed with the depth and quality of information that can be gained here. Since this will affect me in the future (as I migrate to a backend server), I'm concerned as well. Anyway, here goes...
>
>Currently we're running Sybase System 11 under Novell 4.x and have been having some problems. As a result, we're considering the following:
>
>1. Changing OS platforms to either an NT or Unix box.
>
>2. Change altogether to SQL Server under NT.
>
>Any suggestions? Preferences? Are there any known migration problems? Any known stability problems under these?
>
>TIA,

Most of our servers ar Novell 4.11. I have several apps that have VFP tables and DB functioning just fine on the Novell servers. We also have an IBM Mainframe computer in RTP, North Carolina that we access data from throught Oracle.

Oracle is running on the mainframe, and we have created Oracle views of tables in a DB2 database. We had to take this indirect route because the version of DB2 does not support ODBC. The results are still near-instaneous as long as the queries are fairly reasonable. Of course we are connected via T1 lines. The application uses VFP Tables on the server as well as remote views of those Oracle views.

We also have Oracle on Unix and Novell servers locally. We have had very good results with these combinations as well.

I am not sure about the cost of SQL server, but I do know Oracle is extremely expensive. So are the DBAs needed to support Oracle. Sybase and PB better work together since Sybase took over PB a few years ago. That is why I have a problem with going with PB development with Oracle as a back end. Too much conflict of interest since Oracle is a major competitor of Sybase.