the more difficult part of this is that the database access classes in .NET are specific to a particular database server type. For example, the class SqlConnection in the System.Data.SqlClient namespace is for MS SQL Server only, as well as its other classes SqlCommand, SqlDataReader, SqlDataAdapter, etc. That means if you reference these class names directly, you'll be in for a lot of search-n-replace in the code (not to mention that you still have to test it extensively afterwards).

On 4/25/06, Orlando Andico <[EMAIL PROTECTED]> wrote:
it's more complicated than that. simple queries etc. can be done using ODBC. however, if the software is using things like scrollable cursors, then it in all probability Won't Work (TM) with anything except MS SQL. unless the developers are willing to put a good bit of effort into rewriting the DB-specific portions of their code.

also, the existence or nonexistence of .NET Framework drivers is probably irrelevant: most HR/payroll/inventory/etc developers out there are still stuck in the VB6.0 "old skool" mode and haven't done much .NET development yet.

the best bet would be Interbase/Firebird if you're going to be running on windows. mozcom has a lot of these installations out there (MS platform, Firebird DB). oracle and IBM DB2 are too complex for your average HR application.




On 4/25/06, Tito Mari Francis Escaño < [EMAIL PROTECTED]> wrote:
Aside from MS SQL, what does the program vendor explicitly recommend
as database backend?
If you like Oracle-like features and no limitations while still being
FOSS, I suggest you go for PostgreSQL.
Hope this helps. Thanks!

On 4/24/06, MaRViN <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> Our company will be acquiring a new payroll and hr system, the program
> vendor suggests that we use ms sql for the database. Since we want to
> implement open source, I have a few thoughts on MySQL.... (1)how is the
> support compared to sql? (2) how about the stability and upgrade compared to
> the commercial version? (3) is it also vulnerable to sql viruses/hijack?
>
> Thanks.
>
> _________________________________________________
> Philippine Linux Users' Group (PLUG) Mailing List
> [email protected] (#PLUG @ irc.free.net.ph)
> Read the Guidelines: http://linux.org.ph/lists
> Searchable Archives: http://archives.free.net.ph
>
>


--
Tito Mari Francis H. Escaño
Computer Engineer and Free Software Proponent
_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph


_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph


_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph

Reply via email to