Steps to transfer Tally data into MySQL
1) Download and install DX-Fusion from :-
http://www.rtslink.com/images/dx-fusion-fe-v1.0.exe
2) Download and install MySQL driver from :-
http://www.rtslink.com/images/mysql-connector-odbc-3.51.27-win32.zip
3) Make changes in the c:\wamp\www\dx-fusion\dx-fusion.ini file
DATABASETYPE="MYSQL"
CONNECTIONSTRING="Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=tally; User=root;Password=;Option=3;"
4) Start Internet Explorer and type out :-
http://localhost:90
5) Click on myphpadmin
6) Click on databases tab and create a database named Tally.
7) Start Tally, Open your Company and then select option "DX-Fusion >> Ctrl+K" to export Tally data into MySQL database
Hello, I followed your procedure,
ReplyDeleteBut i see this error
--- Error Log ---
2011-10-10T15:04:53+05:30
INSERT INTO LOGDATA Error: Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [MySQL][ODBC 3.51 Driver][mysqld-5.5.8-log]Table 'tally.logdata' doesn't exist
And no table is created,
It looks like schema isn't created.
Thank you
Rishish
Hi even i got the same error
ReplyDeleteWhen i just run tally it's give me the error below
ReplyDeleteExisting Tally !
Error in 'TDL'
Could not find new section
Failed line 'SBD'
File: c:\Tally\DX-Fusion.TCP(Line 1)
not creating tables in database.. No error messages occured
ReplyDeleteHi sree,
ReplyDeleteI have faced same issue. did u got any solution. plz suggest me.
Hi All,
ReplyDeleteSome tables are migrated from tally to MySQL but we are unable to find voucher number in those migrated tables.
Does this DX-Fusion load meta data from tally to MySQL or actual data?