| |
| Publicado el 10,octubre 2016 - 07:20 |
Hi All,
Is HChangeDir() works with other databse's like PostgreSQL and oracle. I tried but no directory created in database. Currently am converting my existing HFSQL database to PostgreSQL and oracle. In HFSQL database i had several sub directories with same datafiles.
Please Suggest is there any Solution to manage this.
Thank you
Shijo S Philip |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 08:05 |
| Hi, I explicitely warn you to use subdirectories in any database and yes, in HFSQL too. I've had some very unpleasant experiences which taught me to stay with the single directory of the database. Advice: make other databases besides the one which you're using, use a naming scheme for accessing them, but do not start to make "trees" of database directories! (I found out - the hard way - that several commands did not work as expected with subdirectories of a database directory) |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 08:28 |
Hi Guenter Predl,
Thanks for your reply.
In HFSQL am using this sub directories and its working good. There is no issue reported since from my existing customers. I done this because of heavy data. Currently i want to move PostgreSQL and Oracle. Can u please suggest any solution for this.
Thank You
Shijo S Philip |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 09:12 |
Can u please suggest any solution for this.
No. Sorry. I do avoid any subdirectories in all databases ...
Hi, the only solution is to make other database directories and use proper naming conventions to connect to them. If it's impossible in Oracle or Postgresql to switch to a subdirectory then this should be a hint to you that subdirectories are not a good way there. What's so difficult in switching from \MyDatabase\MyData2015 to \MyDatabase and \MyData2015 ? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 09:49 |
Thanks Guenter Predl for your suggestion.
Shijo S Philip |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 10:14 |
Hi Shijo,
I think you have "confused" everyone with what you are asking - and probably Guenter also.
There are 2 types of HFSQL databases:
1. The Classic one - where you can use HChangeDir(). Everything here is BASED on directories etc ..
2. The C/S one - where you DON'T use HChangeDir etc. Everything is CONTROLLED by the HFSQL C/S Engine - you just POINT to a DATABASE.
Where these DATABASEs are stored is NOT of ANY VALUE to our program logic.
Now with ANY type of C/S Engine (like ORACLE or PostgreSQL) it works the same as [2] - HFSQL C/S
I thing it is better for you to first do a HFSQL C/S implementation of your HFSQL Classic implementation - to see how things work - and then MOVE to Oracle etc
Steven Sitas
www.alpha360.biz
The Open Source ERP |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 10:24 |
Hi Steven Sitas,
Am already working in HFSQL C/S and that work good. The problem is when i move to other databases HChangeDir() is not working.Cant create Directory in other databases and Cant change Directory. I need solution for this.
Thank You
Shijo S Philip |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 10:55 |
Hi Shijo,
totally lost you ..
Where are you using HChangeDir() with HFSQL C/S ?
Steven Sitas
www.alpha360.biz
The Open Source ERP |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 15:15 |
Hi Steven,
in fact it is possible to make subdirectories of a database directory. As an example, for accounting like for 2011, 2012, 2103, ..
\GenLedger <- herein you have all those datafiles which will not change by the year
\GenLedger\2011
\GenLedger\2012
\GenLedger\2013
...
and to make and change directories by using HChangeDir(...)
The problem is - as I learnt the hard way and years ago - that some database operations (h-commands in fact) do not work correctly on the database records sitting in those subdirectories. Therefore I recommended a different setup. No wonder that other database engines obviously do not allow subdirectories at all ...
My solution is
\GenLedger <- herein you have all those datafiles which will not change by the year (e.g. accounts, VAT rates etc)
\GenLedger2011
\GenLedger2012
\GenLedger2013
this setup will work just fine |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 15:32 |
Hi Guenter Predl,
I didnt understand your solution. Can u please give a brief explanation.
Thank you
Shijo S Philip |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,octubre 2016 - 19:01 |
Hi Guenter,
thanks for the info.
It still looks VERY STRANGE to me, to be able to use directories this way in a Client Server Engine.
Steven Sitas
www.alpha360.biz
The Open Source ERP |
| |
| |
| | | |
|
| | |
| |
| Publicado el 11,octubre 2016 - 08:00 |
Hi Steven,
for backup / restore purposes it seems to be the "natural" way indeed, just a single directory to save, no problems for that. In the old forum, as I remember now, I detailed the shortcomings and functional deficiences of such a setup. A few h-commands did not work correctly, so I had to change the setup and it worked fine then - as expected. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 11,octubre 2016 - 08:04 |
Hi Shijo,
the short explanation ist: subdirectories in a database setup do not work. Use single directories! |
| |
| |
| | | |
|
| | |