pcsoft.us.windevCopyright 2026, PC SOFT16 Jan 2018 13:11:00 Z9 Jan 2018 15:39:00 ZHi, I am converting my database from HFSQL to MSSQL. The IT-guys of one of the companies which uses my software don't like rare and unknown databases as hfscl is, they want a more mature (:)) database so to speak. I loose the automatic modification but that's not a big issue. I wonder if someone did this transition before. So I have a few questions: 1. will I run into known issues? 2. Any handy tool to convert/import all data from HFSQL to MSSQL? 3. Is it advisable to go for the NATIVE driver right from the start? One of the issues I ran into already is that a LOT of fields are NOT defined as "null authorized", which causes troubles. I just opened and ticked hundreds of fields in the analysis to change that :sneg: (Looks like these specific fields/tables came from previous WD versions back to WD9 or so).30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-64030/read.awp16 Jan 2018 13:11:00 ZFYI. In sqlserver you have the option to "SET IDENTITY INSERT ON/OFF" to be able to set the key-fields to a specific value. I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-64030/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-64030/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63939/read.awp10 Jan 2018 18:33:00 ZHi Arie, You might want to look at a program like https://flowheater.net/en/ It's very handy for converting data betwee…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63939/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63939/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63936/read.awp10 Jan 2018 16:29:00 ZFabrice, thank you. No unicode now for me.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63936/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63936/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63935/read.awp10 Jan 2018 14:21:00 ZHi Arie, Quote Arie And what about switching to UNICODE at this point. Would that be smart right now and/or in general? …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63935/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63935/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63934/read.awp10 Jan 2018 13:05:00 ZStefan thanks, looks good!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63934/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63934/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63933/read.awp10 Jan 2018 11:56:00 ZHi Arie, In a memorytable with all the files from the analyse I can select the files to export. The following code treats ea…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63933/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63933/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63932/read.awp10 Jan 2018 09:18:00 ZAnd what about switching to UNICODE at this point. Would that be smart right now and/or in general?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63932/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63932/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63931/read.awp10 Jan 2018 09:17:00 ZFabrice, writing an small conversion tool is an option indeed. I will have to disable all contraints before and also set the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63931/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63931/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63930/read.awp10 Jan 2018 09:14:00 ZStefan, some code would be nice. I did a small test with the sqlmanager data import wizard, using the HFSQL OLEDB driver t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63930/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63930/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63923/read.awp9 Jan 2018 18:56:00 ZHi Arie, 1. will I run into known issues? Yes, if you are using ANYTHING that is HF specific (array of items, stored proce…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63923/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63923/read.awpHFSQL22 - convert to MSSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63922/read.awp9 Jan 2018 17:22:00 ZHi Arie, I've made a procedure in my database management module ones to convert the data in my HFSQL database to scripts for …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63922/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63917-hfsql22-convert-mssql-63922/read.awpHFSQL22 - convert to MSSQL