Thread: Re: postgreSQL as MSSQL2000 server?
no way:)) and there are many many differences between sql language, even in procedures, and calling them. What kind of programs? Can they be rewrite to use a common api to communicate with sql servers, like ODBC or other layers ? C. Dekkers Intermediair wrote, On 3/17/2003 3:53 PM: > Hi all, > > I'm a postgreSQL newbie, with a newbie question: > Is it possible to setup a postgreSQL server on *BSD or linux in such way > that a > Windows 2000 network sees it as an MSSQL 2000 or higher server? > > I want to do this because I've some programs which only will run on > MSSQL2000 and uses stored procedures, but I don't want a MSSQL server, > because I then also need at > least Windows 2000 server. > > Thanks for any responses! > > Dimitry > > >
I think they already use ODBC to connect to the SQL. But of one I know it also installs stored procedures. The software I need the SQL for is: - Worldship of UPS - Exact Compact 2000 (a Dutch administrative/financial package) - Track-It! 5.0 Enterprise of Blue Ocean/Intuit (a Helpdesk/Inventory tool) All of these packages also work on MSDE2000. But to centralize and to be able to backup their databases easily I'll like them to be on one SQL server. Suggestions? Thanks! -Dimitry "CoL" <col@mportal.hu> schreef in bericht news:b55bbp$2i4a$1@news.hub.org... > no way:)) and there are many many differences between sql language, even > in procedures, and calling them. > What kind of programs? Can they be rewrite to use a common api to > communicate with sql servers, like ODBC or other layers ? > > C. > > Dekkers Intermediair wrote, On 3/17/2003 3:53 PM: > > Hi all, > > > > I'm a postgreSQL newbie, with a newbie question: > > Is it possible to setup a postgreSQL server on *BSD or linux in such way > > that a > > Windows 2000 network sees it as an MSSQL 2000 or higher server? > > > > I want to do this because I've some programs which only will run on > > MSSQL2000 and uses stored procedures, but I don't want a MSSQL server, > > because I then also need at > > least Windows 2000 server. > > > > Thanks for any responses! > > > > Dimitry > > > > > > >