|
| [WD18] Access DB Modification |
| Iniciado por guest, 06,ene. 2015 13:13 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 06,enero 2015 - 13:13 |
Hi,
I have a MS Access project which i am recreating in Windev 18.
When i started the project i used the existing Access DB tables directly using the OLEDB Driver all worked fine, no problem.
Now i have converted all the tables from access into HyperFileSQL server and transferred all the data, all fine, but here my problem lies.
This project is in development and when i am finished i need to transfer again all the data from the Access DB as they are using it continually while i create the new program, but I have since made many changes to the HyperfileSQL datafiles. Is there a way to do a reverse synchronisation so the analysis actually updates (add the new fields) the MS access db?
Or is there another way apart from adding all the new fields manually to the access db?
many thanks
iso |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,enero 2015 - 13:38 |
If only added new fields you can move the data from one db to the other using two connections (one for the access the other for the HF), read the data from the access copy it to the hf record (HCOPYRECORD) and write it in the hf database.
If you change the name of the fields, the data type or some changes to the structure it depends and probably you will have to do it with some more work. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,enero 2015 - 13:53 |
Hi Paulo,
Yes i need to basically get my access db structure to look exactly the same as my HyperfileSQL structure, then i would use the 'import data from another database' feature.
Manually it would be a lot of work for me to go through each table so i just wondered if there a way to actually update the external database to match your analysis?
thanks
iso |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,enero 2015 - 13:59 |
Hi
There is not automatic way to do that (only available for HF)
However, you MAY be able to do it a little less painfully than by hand
There is an option in the analysis editor that allows you to generate a SQL script to CREATE an empty sql db matching your analysis
so if that works with access (don't know), you can recreate an empty access DB matching your analysis, then do your data transfer..
Of course, if you are good enough in SQL, you may be able to transform the script into a MODIYFING one, but that may not be worth your while
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,enero 2015 - 15:26 |
Hi Iso,
Seems like a waste of time to me to create empty new fields you will never use.
Writing a little copy utility is a 15 minute job in the way Paolo described and it gives you full control.
Regards,
Piet |
| |
| |
| | | |
|
| | | | |
| | |
|