Solved

replace ms sql 2008 with PostgreSQL possible?

Posted on 2012-03-27
5
449 Views
Last Modified: 2012-06-22
For purposes of installing avionte staffing software, their required software specs include Microsoft SQL Server 2008 R2 (64 bit) Standard. Licenses are ridiculous, so is there any way to implement the software on premise server with PostgreSQL instead?
0
Comment
Question by:BitTrekker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 175 total points
ID: 37774162
Not likely.  All the database access code and drivers would have to be changed.  It would not be a "drop-in replacement".
0
 
LVL 24

Accepted Solution

by:
johanntagle earned 175 total points
ID: 37774416
Besides drivers and access codes, the application itself might employ MSSQL-specific features.  And even if everything turned out fine, the application vendor will likely void any warranties due to unsupported infrastructure.  I suggest you either invest on everything or nothing at all, i.e. seek another vendor for your staffing software.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37774593
Ask then if they support SQL Server Express.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37774595
On second thoughts, I would be shocked if they said yes.
0
 
LVL 1

Author Closing Comment

by:BitTrekker
ID: 37774615
I'm going to check to see if small business server 2008 or 2011 will work with the software and if so use ms sql 2008 standard for small business as it looks much more affordable.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question