postgreSQL as MSSQL2000 server?
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
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:
Show quoted text
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
In the long run switching completely to open source will save you lots
of $$$$$.
--
Daniel R. Anderson
Chief Lab Rat and Helper Monkey
Great Lakes Industries, Inc.
80 Pineview Ave.
Buffalo, NY 14218
(716) 691-5900 x218
"Never let your schooling interfere with your education"
-- Mark Twain
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...
Show quoted text
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