Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

replace ms sql 2008 with PostgreSQL possible?

Posted on 2012-03-27
5
Medium Priority
?
453 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
5 Comments
 
LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 700 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 700 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
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.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

876 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