There is only one way to find out for sure and that is to setup sapdb and test it. Beyond that you will have to tweak *any* native mssql or oracle schema/d*l scripts to fit sapdb...for instance:
(if my memory serves me) mssql stored procedures look like this - create procedure ... where sapdb looks something like - create dbproc ... One thing to note is the dbmgui is built using VB, so there is a good chance that with a little tweaking and praying that the sw vendor did not hard code any show stoppers in, you may be able to use it instead of ms or oracle which in my mind is worth a shot to save your company a wad of cash. You may want to find another package to present as an alternative that is more flexible on the db side. The package may not say it supports db X but rather depend upon on how it was designed...ask those sales weenies the tough questions! Most of all ... Good Luck! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Randall Hinton Sent: Wednesday, February 12, 2003 6:00 PM To: [EMAIL PROTECTED] Subject: SAP DB and MSSQL The Organization that I work for is currently using a MSSQL database to store Document Management data, We are In the process of Upgrading to some new servers and have found that to upgrade the Licensing on MSSQL will cost from $6000 to $10000, We have been looking at the alternatives as a result, possibly moving to a Mysql or Postgresql backend when I remembered hearing about SAP, Our vendor currently supports only MSSQL or Oracle, What kind of steps would be needed to Use SAP instead, would there be problems with data types, or SQL syntax.... the application would be accessing it through ODBC and Requires the Database to be ADO Compliant, Any Thoughts?? Thank you for your time and Help, Randall Hinton _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
