SQL Server - transfering data to tally

Asked By PRAVIN on 21-Jan-11 12:31 AM
We wish to transfer data from sql server2005  to tally erp for sales and purchase transactions only. pl suggest
Anoop S replied to PRAVIN on 21-Jan-11 12:46 AM
we can't directly export sql to tally.we can export sql data to excel or word format.then we can import into tally.
otherwise use some 3rd party tool like UDI-Magic, its not a free version, refer this
http://www.rtslink.com/sql-server-to-tally.html
E Y replied to Anoop S on 21-Jan-11 07:05 AM
Hello,

If it is possible to directly import data from Tally ERP database, you can even connect with SSIS or http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx.

But I did a similar data transfer in SAP system recently, I had to use a ABAP program and a Function Module for this transfer.
And I think this seems to be a correct way if the business logic running is complex on top of the ERP database.