pcsoft.us.windevCopyright 2026, PC SOFT3 Oct 2016 20:37:00 Z1 Oct 2016 10:40:00 ZHii; Hope Everyone is doing good!!! I have some scenario where one of my Customer where a Windev 20 application is running with HFSQL 20 database with a data load of around 1.3Gb, and now the customer would like to migrate to ORACLE Database. So i would like to know which Oracle Database should i purchase and what all additional licenses should i purchase from PC SOFT like native connectors. I just want to make sure that everything works fine on his HP SERVER( 16GB RAM/1TB HDD/ SERVER 2012 OS) having around 50 concurrent users of which 40 users are connected from remote locations to Server. What all difficulties might i suffer in Developments, Queries, Data migration etc..It would be a great help if my fellow mates could advise on the same. Thanks in advance30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59791/read.awp3 Oct 2016 20:37:00 ZAmal It's an exciting feature of sqlServer 2016 in Linux, if functionality works 100% same in Windows OS, I will rate it 4 o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59791/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59791/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59788/read.awp3 Oct 2016 13:35:00 ZHiii Thanks to everyone for sparing your time with my topic; "KING" How would you rate using SQL Server in LINUX? Also let …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59788/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59788/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59787/read.awp3 Oct 2016 02:46:00 ZHi Darren, Yes. I keep a baseline DB in SQL Server and Navicat has a compare function that builds all the DB scripts for me w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59787/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59787/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59781/read.awp2 Oct 2016 19:46:00 ZHi Amal, I would echo King's comments. Oracle could be seen as a "silver bullet" to solve your DB performance woes, but I wou…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59781/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59781/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59782/read.awp2 Oct 2016 19:29:00 ZHi Steve, Can Navicat replace the need for WDModfic... i.e. external DB's cannot use WDModfic to re-structure data after the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59782/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59782/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59779/read.awp1 Oct 2016 19:21:00 ZHi Amal, If you are going to work with an external DB like Oracle (or MS SQL) I highly recommend making an investment in Navi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59779/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59779/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59778/read.awp1 Oct 2016 16:39:00 Zsorry for my typo and it should be " as it is NOT 100% fully transparent to..."https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59778/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59778/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59777/read.awp1 Oct 2016 16:37:00 ZAmal Actually I am using ML380 with 2x200GB HP Enterprise SSD but with other DB on Linux, it is super fast and other with SS…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59777/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59777/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59776/read.awp1 Oct 2016 15:57:00 ZThanks KING for the Reply!!:cheers: Its my first venture to migrate to an enterprise database like Oracle..What do u advice a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59776/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59776/read.awpMIGRATION FROM HFSQL Database to ORACLE Databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59775/read.awp1 Oct 2016 13:42:00 ZHi You may use Oracle v12.1.0.2 and buy Native Driver from pcSoft that makes life easier for the transitions from hfSql to O…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59775/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59774-migration-from-hfsql-database-oracle-database-59775/read.awpMIGRATION FROM HFSQL Database to ORACLE Database