[Vtigercrm-developers] MS SQL Installation Walkthrough so far...

[Minnie]

Dear Joey,

           In DatabaseSchema.xml, some of the tables has specified withautoincrement field. But in vtiger CRM, we are not using theautoincrement while inserting entries in the tables, instead we areusing the method called getUniqueID() which is provide by ADODB library that simplifies many database-related tasks in PHP. 

In future, we need to review the DatabaseSchema.xml file and remove the unwanted autoincrement fields and test whether it works fine with MySQL.

Thanks & Regards,
Minnie.

----On Wed, 12 Sep 2007  Joey Novak <joey.novak at gmail.com> wrote ---- 

                                                                                    Enrico,

  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.

  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.

  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%.

  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).

  http://www.joeynovak.com/wiki/index.php/VTiger_on_MSSQL

  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.

    Joey

On 9/12/07, Enrico Weigelt <weigelt at metux.de> wrote:* Joey Novak <joey.novak at gmail.com> schrieb:

Hi,

> So, the company I am working for has decided to implement a CRM,
> and they have budgeted a significant amount of money to do so.
> We like all the features of vTiger.

Cool. Maybe your company could provide some funds for completing
several outstanding things :)
(some of us are freelancers who mostly contribute during their
customer projects and can be hired ;-))

> The only thing that would stop us, is the lack of MSSQL support.
> We may go with it ontop of MySQL, however a significant portion of
> our companies money machine is composed of MSSQL DTS Jobs.

Well, I clearly can understand you don't want MySQL, the SQL-enabled
cardfile ;-P. But WTH MSSQL ?

We've got PostgreSQL support. Instead of burning so much money w/
M$ license fees and the whole (Windows-generated) troubleshooting,
you can get an complete machine w/ pgsql on GNU/Linux or xBSD
and build evrything optimized for your hw.

> We have to decided and prepare a plan by the end of the week (this
> has been in the works for a while).  And in an effort to make the
> decision easier, I have spent some time working through the issues
> I see that prevent vTiger from running on MSSQL.

One of the major points (IMHO) is that MSSQL's understanding of SQL
is even crappier than MySQL's.

I *personally* wouldn't suggest porting to another homebrewn SQL dialect.
Better spend a day for becoming confident w/ PostgreSQL ;-P


cu
--
----------------------------------------------------------------------
 Enrico Weigelt, metux IT service -- http://www.metux.de/

 cellphone: +49 174 7066481   email: info at metux.de   skype: nekrad666
----------------------------------------------------------------------
 Embedded-Linux / Portierung / Opensource-QM / Verteilte Systeme
----------------------------------------------------------------------
_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com




-- 
---
    http://www.joeynovak.com

    C) 803-409-9969 (Work Cell)
    W) 757-233-0834
"Very funny, Scotty. Now beam down my clothes."

Be nice to nerds. Chances are you'll end up working for one. 
    --Bill Gates

Your most unhappy customers are your greatest source of learning.  
    --Bill Gates

Cope with Life, go buy a slurpee!
http://www.slurpee.com/games.html_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 
                                                         
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20070914/9bfd196d/attachment-0003.html