Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
2 synchronized DB
Hello,
given:
- The same DB on two seperate computers (e.g. Laptop, Server). Palo is running (independently) on both computers.
- One DB is continuously updated.
Objective:
- Subsequently to the update the data of the updated DB should be transferred into the other DB (computer) such that both DB (and Palos) are running on the same updated data.
How can this be ensured?
Regards, J.
RE: 2 synchronized DB
script something for the following steps.
e.g. batch file that you can then run with scheduler.
- shut down palo service (destination)
- delete db directory (destination)
- copy db directory soucre to destination
- start palo service (destination)
batch lines for stopping and starting palo service are
net start PALOServerService
net stop PALOServerService
where PALOServerService is the server name.
Rest are DOS like
rd for remove dir
and copy
Holger
wouldn't it be easier to just install ETL Server on one machine, maybe the desktop, and to write an ETL Project which simply copies everything over to the other maccina ??
Or is it somehow faster to copy the whole raw DB folder?
I know it's a "dirty" approach and no real replication but a fast way for when source machine is the "leading" one, so that destitnation can be overwritten.
Using ET-Server probably would be possible but you have to check everything: dimension, cbues, rules, data,...
Thanks a lot Holger and Phil_Ro for your prompt reply.
At first I had about the same ideas as Phil_Ro (would be pretty fine!), but after copying the folder, Palo didn't recognize the DB anymore on the destination computer. I didn't know if the whole approach is not working, or if I just made a minor mistake.
Holger, could you please tell something more about the need to check all the structure of the DB?
Thanks J.
my approach was the copy approach :-)
Try to delete palo.csv before restarting palo service. Is db recognized then. Otherwise check PaloServer.log.
Thanks for your reply Holger.
I'm afraid my problem starts even a bit earlier. I have a Palo-DB (whole folder from another computer) - which I would like to use on my Laptop. Is there a way to make this work?
Regards J.
- stop palo service on your laptop
- copy db directory to palo data directory of laptop
- start palo service on laptop
Thank you so much for your prompt reply Holger.
I did as advised:
- stop palo service on your laptop
(Right-klick on the icon of palo manager, choosing "Beenden des Palo Dienstes")
- copy db directory to palo data directory of laptop
(Copied the whole folder into Jedox-Palo-data)
- start palo service on laptop
(Started palo manager from the start-menue)
But I cannot see the DB in modeller. The DB is neither listed in palo.csv.
Any idea?
Regards J.
Jeanette,
delete palo.csv and restart service. It should be recreated after restart. if db does not appear, check paloserver.log for any warnings or errors.
Holger
