Extract Only Some Information from Traccar to Microsoft SQL Server
You can query only the information you need.
Dear Anton,
Thank you for your reply. My Traccar is installed on Linux. May I know if that can be done in the traccar.xml? If so, could you please assist me on what I should include if I only want to extract the "tc_positions" table to my database.
Best regards,
Castco
No, Traccar cannot do it for you.
Dear Anton,
Thank you for your reply. Therefore, can I confirm that Traccar is unable to send only the "positions" table to my database? If so, the only solution is to manually query the tables that are sent by Traccar, directly from my Microsoft SQL Server?
Best regards,
Castco
I'm sure there are more than one solution, but what you want is not available out of the box.
Dear Traccar,
I hope this message finds you well. I would like to inquire about how I can extract only some information to my Microsoft SQL Server, so that the remaining ones will not show up on my database. For instance, I want to only have the longitude, latitude, devicetime (from tc_positions), and id (from tc_devices) columns in my database.
Thank you for your time and consideration. I look forward to hearing from you soon.
Best regards,
Castco