Re: [firebird-support] Need data on server 1 up to date from server 2
Hi Thomas,thanks for your tip,so this is DATABASE REPLICATION I'll first start with some free tool,as I read : http://www.firebirdfaq.org/faq249/ there are some,please give me a good one for testing.I've downloaded ReplicadorBR (replicadorbr_0_5_5.zip) but this seems not to be in english and I got may times the error: Can't load library Thanks From: Thomas Steinmaurer t...@iblogmanager.com To: firebird-support@yahoogroups.com Sent: Tuesday, December 6, 2011 9:12 PM Subject: Re: [firebird-support] Need data on server 1 up to date from server 2 I'm using Firebird 2.5 on XP on 2 servers.I need to have on server 1 data up to date from server 2,there is a easy way to do that ? Sure I can add from my application but there must be some generators or else that have to be updated too. Thanks for any tip. If it's one-way (uni-directional), then have a look on the following standby implementation: http://www.iblogmanager.com/download/demos/iblm/iblm_hotstandby.htm If you are more looking into a full-fledged replication soluation, e.g. two-way with conflict resolution, then IBReplicator might be an option: http://www.ibphoenix.com/products/software/ibreplicator -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/ [Non-text portions of this message have been removed]
Re: [firebird-support] Checking if scripts ran correctly
Just found a remote database that did not have a field in a table which had been added some 4 or so scripts ago. That makes me suspect of all script updates. What is the fastest and most reliable way to check all my deployed databases (say 200 of them) to see if all the scripts have run correctly and applied the changes, or created triggers and procedures, contained in previously run scripts? Do I need a commercial product that can help? Or do I just have to visit each location and check the database structures manually? I use one script component developed by me that uses IBX. What i do is save a log file with the exceptions raised when runing the script. After running the scripts, i see that log files. It is not complicated to send the scripts by email, for example, after running the scripts. I think is not necessary a commercial component, just logging the exceptions when running the scripts and analyze them. Jesus [Non-text portions of this message have been removed]
Re: [firebird-support] Need data on server 1 up to date from server 2
Hi! Hi Thomas,thanks for your tip,so this is DATABASE REPLICATION I'll first start with some free tool,as I read : http://www.firebirdfaq.org/faq249/ there are some,please give me a good one for testing. Sorry, can't help you here, because I haven't used any of them. If your work time counts, then I wouldn't play around too much with them. I only can say that our standby implementation and IBReplicator is proven in the field. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/