God bless your great efforts in this channel. I have a simple question to ask as a newbie sql learner. Could i manage to channel or extract all sql data generated from an accounting program (based on sql) to our new sql server. The reason that we are bounded with the graphical interface of this accounting software as we cant come up with any solutions regarding analytics and automation, unless we can tailor and rearrange this sql database based to our specific needs. Thanks for helping me.
Thank you! I guess you can export this data into for example csv file and then import it to the sql server. Here you need to watch out for example for formats of dates and timestamps. I don't know what is the sql server you mentioned also but here software similar to SQL Developer should have such import functionalities.
God bless your great efforts in this channel.
I have a simple question to ask as a newbie sql learner.
Could i manage to channel or extract all sql data generated from an accounting program (based on sql) to our new sql server.
The reason that we are bounded with the graphical interface of this accounting software as we cant
come up with any solutions regarding analytics and automation, unless we can tailor and rearrange this sql database based to our specific needs.
Thanks for helping me.
Thank you! I guess you can export this data into for example csv file and then import it to the sql server. Here you need to watch out for example for formats of dates and timestamps. I don't know what is the sql server you mentioned also but here software similar to SQL Developer should have such import functionalities.