Enrico,<br><br> Have you looked at MySQL 5 lately? It has advanced far far beyond it's SQL Enabled Card File Status. While it doesn't posses many of the easier to use options of MS SQL, I feel it is a serious competitor in the DBMS Market.
<br><br> No chance I can get them to go with Postgres, we have no one with experience, and we have 2 MySQL DBA's and a MSSQL DBA, so it just won't happen, we would be wasting those resources if we switched to Postgres.
<br><br> If we can get vTiger running on MS SQL, then it is definatly a go to switch to vTiger, and there are LOTS of customizations we will need. The largest being an Integrated Billing System. My manager is supportive of aiding the OpenSource community, so there is a fairly good chance that we could contribute financial support to parts of vTiger that are lacking to us. But, if it won't run on MS SQL, then the odds of us adopting it are less then 20%.
<br><br> I have spent just a few hours on the vTiger MSSQL problem, here is what I have so far (It looks like such a meager amount for the time spent).<br><br> <a href="http://www.joeynovak.com/wiki/index.php/VTiger_on_MSSQL">
http://www.joeynovak.com/wiki/index.php/VTiger_on_MSSQL</a><br><br> I wonder why the faq table has an autoincrement for the foreign key to the crmentity table. While this makes it work fine in MySQL, it doesn't float with MS SQL. Which makes sense, I mean, the Auto Incremented value that MySQL generates can almost never be used as the CRMEntity key, as there are so many other tables that must have entries in crmentity as well. While it is theoreticaly possible that all the faq keys would not bump into any other keys, I expect that in the code, there isn't a single place that the faq key's autoincrement value is used.
<br><br> Joey<br><br><div><span class="gmail_quote">On 9/12/07, <b class="gmail_sendername">Enrico Weigelt</b> <<a href="mailto:weigelt@metux.de">weigelt@metux.de</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
* Joey Novak <<a href="mailto:joey.novak@gmail.com">joey.novak@gmail.com</a>> schrieb:<br><br>Hi,<br><br>> So, the company I am working for has decided to implement a CRM,<br>> and they have budgeted a significant amount of money to do so.
<br>> We like all the features of vTiger.<br><br>Cool. Maybe your company could provide some funds for completing<br>several outstanding things :)<br>(some of us are freelancers who mostly contribute during their<br>customer projects and can be hired ;-))
<br><br>> The only thing that would stop us, is the lack of MSSQL support.<br>> We may go with it ontop of MySQL, however a significant portion of<br>> our companies money machine is composed of MSSQL DTS Jobs.<br>
<br>Well, I clearly can understand you don't want MySQL, the SQL-enabled<br>cardfile ;-P. But WTH MSSQL ?<br><br>We've got PostgreSQL support. Instead of burning so much money w/<br>M$ license fees and the whole (Windows-generated) troubleshooting,
<br>you can get an complete machine w/ pgsql on GNU/Linux or xBSD<br>and build evrything optimized for your hw.<br><br>> We have to decided and prepare a plan by the end of the week (this<br>> has been in the works for a while). And in an effort to make the
<br>> decision easier, I have spent some time working through the issues<br>> I see that prevent vTiger from running on MSSQL.<br><br>One of the major points (IMHO) is that MSSQL's understanding of SQL<br>is even crappier than MySQL's.
<br><br>I *personally* wouldn't suggest porting to another homebrewn SQL dialect.<br>Better spend a day for becoming confident w/ PostgreSQL ;-P<br><br><br>cu<br>--<br>----------------------------------------------------------------------
<br> Enrico Weigelt, metux IT service -- <a href="http://www.metux.de/">http://www.metux.de/</a><br><br> cellphone: +49 174 7066481 email: <a href="mailto:info@metux.de">info@metux.de</a> skype: nekrad666<br>----------------------------------------------------------------------
<br> Embedded-Linux / Portierung / Opensource-QM / Verteilte Systeme<br>----------------------------------------------------------------------<br>_______________________________________________<br>Reach hundreds of potential candidates -
<a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a><br></blockquote></div><br><br clear="all"><br>-- <br>---<br> <a href="http://www.joeynovak.com">http://www.joeynovak.com</a><br><br> C) 803-409-9969 (Work Cell)
<br> W) 757-233-0834<br>"Very funny, Scotty. Now beam down my clothes."<br><br>Be nice to nerds. Chances are you'll end up working for one. <br> --Bill Gates<br><br>Your most unhappy customers are your greatest source of learning.
<br> --Bill Gates<br><br>Cope with Life, go buy a slurpee!<br><a href="http://www.slurpee.com/games.html">http://www.slurpee.com/games.html</a>