pcsoft.us.windevCopyright 2026, PC SOFT17 Nov 2015 16:09:00 Z17 Nov 2015 11:42:00 ZHi, I have a requirement to fill a datawarehouse from my application. We use hfsql in our application. For every project there is an separate database. I need to upload part of the data to an mssql server, using the same table structure with one difference. It will be used as a datawarehouse for reporting software (not WD). Every table in mssql gets an extra "project" field and the data of all hfsql-database (projects) is then stored in this one mssql-database. Could the replication mechanism of pcsoft be usefull? @ Fabrice: could your replication mechanism be usefull? It must be rock solid. I also need some mechanism to detect errors (i.e. no database connection, index corrupt or whatever fault may happen during the process) and send an email to certain users. I even consider using triggers and 'sync' the data on-the-fly. (hfsql and mssql are on the same network) . Any caveats here?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55007/read.awp17 Nov 2015 16:09:00 ZFabrice, I agree about the replication as kind of real time thing. Making a dump every night is a different approach I was t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55007/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55007/read.awpuniversal replicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55005/read.awp17 Nov 2015 15:19:00 ZHi Arie, there is no risk in changing autoID by GUID, and for that I have a step by step guid available on my site, in the wxre…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55005/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55005/read.awpuniversal replicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55004/read.awp17 Nov 2015 14:42:00 ZFabrice, atm I do not have GUID in all tables but 'regular' auto-IDs. To change that it will take considerable time (and risk…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55004/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55004/read.awpuniversal replicationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55002/read.awp17 Nov 2015 14:22:00 ZHi Arie, I would really NOT use pcsoft replication (any of them), as rock solid is definitely NOT what comes to mind. As f…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55002/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54986-universal-replication-55002/read.awpuniversal replication