x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 76 subscribers
  • Views 1975 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
977
topics
2k
replies
Inventory, Projects, and Departments
337
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
317
topics
995
replies
Reporting and Analytics
206
topics
399
replies
Soutien Technique - Français
626
topics
1k
replies
Year End Activities
223
topics
595
replies
AmyGurl

Has anyone done a multi-year sql data dump from Sage50 Premium?

Posted By

Just as it says. Exact scenario is that the client is switching from Sage50 to an industry specific software and would like to bring in all their transactional history. This is definitely going to require an SQL query across multiple tables and I have no idea how to do this. Is there anyone out there that can? Honestly, I think it's a bad idea, but I have to ask...

Parents
  • 0
    yes have exported MySQL dump of the historical GJ transactions but for GJ transactions you can run the report then export to excel then use excel to tailor the data to import into the accounting application. But if you want invoice details, payroll details, etc. then contact us at bithelp.ca to explore some possible solutions.
Reply
  • 0
    yes have exported MySQL dump of the historical GJ transactions but for GJ transactions you can run the report then export to excel then use excel to tailor the data to import into the accounting application. But if you want invoice details, payroll details, etc. then contact us at bithelp.ca to explore some possible solutions.
Children

*Community Hub is the new name for Sage City