[Vtigercrm-developers] vTiger with SQL Server has backend ?

[Sutharsan Jeganathan]

HI

We had with 5.4.0 :).  It is just the effort rather than complex. That
means you should modify wherever the SQL queries to support MSSQL query
everywhere in the vtiger code.

Why do you need an MSSQL? If it is only for the purpose of integrating
other tools such as Reporting and big data, I recommend to use MySQL to
MSSQL Replication. Where you can keep vtiger database as MySQL, but
replicate its data to a MSSQL databasse as mentioned below


   - Write triggers in MySQL that capture insert, update, and delete
   statements in a log table (same as binlog)
   - Poll/Read the log table from MSSQL using ODBC and execute them, then
   delete those log entries.


Thanks

Sutharsan Jeganathan

On Wed, May 24, 2017 at 12:26 PM, crmtiger <info at crmtiger.com> wrote:

> Hello,
>
> Anybody tried vTiger with SQL Server as a backend ?
>
> Our Team is trying to implement that.
>
> Any suggestion or something do let us know
>
> Regards,
> CRMTiger.com team
>
>
>
> --
> View this message in context: http://vtiger-crm.2324883.n4.
> nabble.com/vTiger-with-SQL-Server-has-backend-tp20778.html
> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20170524/0d88cd23/attachment.html>