pcsoft.us.windevCopyright 2026, PC SOFT28 Jan 2016 10:02:00 Z20 Jan 2016 09:48:00 ZHi Everyone, I m after a bit of advice on how to tackle a project i am working on. A customer uses an off the shelf software package for their everyday running of the business, the software's database is SQL Server. I have created a program that links to the SQL server database so they can extract and manipulate data further, i am not allowed to write to the SQL server DB or create tables etc so u i have created an HyperfileSQL database and change connections, but the SQL server tables are a mess IMO, to get the information the users needs i have to create complex queries which slows it down and changing connections all the time is proving erroneous. So i had the idea: a sync program that runs on the server and copies the SQL Server database into the HyperfileSQL DB What i have done is created 3 queries in the SQL Server database which pretty much gets me all the data i want and created 3 tables in the HyperfileSQL DB which mirrors the structure of the queries. My question is do you think this a good way and also whats the best way to get the data from the SQL queries into the HyperfileSQL tables, The obvious way is to create a memory table that runs the SQL query then a procedure that changes connection and checks each line of the table deciding if its hadd/hmodify, this seems slow to me so was hoping if someone had a better solution? any help appreciated thanks ISO30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-56100/read.awp28 Jan 2016 10:02:00 ZIf they will allow you to create views on the SQL box, that's a good way forward.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-56100/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-56100/read.awpProject Help/Adviceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-56073/read.awp27 Jan 2016 10:51:00 ZThanks for all your advice guys :spos:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-56073/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-56073/read.awpProject Help/Adviceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55954/read.awp20 Jan 2016 11:45:00 ZHi Iso, It's dificult the help you with only this information but i will try. Do you need the data in real time? How big you …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55954/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55954/read.awpProject Help/Adviceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55953/read.awp20 Jan 2016 11:30:00 ZHi all, On SQL Server you can have DB mirroring (between SQL servers). The way to implement that is to activate log shipping …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55953/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55953/read.awpProject Help/Adviceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55952/read.awp20 Jan 2016 10:33:00 ZHi, first thought: a separate Windows Service could take care of the sync between SQL Server and HFSQL. I don't know MS SQL Serv…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55952/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55948-project-help-advice-55952/read.awpProject Help/Advice